JDBC- Oracle RAC URL

[Arjun Shastry]

Hi,
I am getting "java.sql.SQLException NL Exception was generated" when connecting to Oracle 11.2 Database. Driver used- Oracle Thin,(ojdbc5.jar).
I am using RAC URL like this-

String sid = "(DESCRIPTION ="+
    "(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521))"+
    "(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))"+
    "(ADDRESS = (PROTOCOL = TCP)(HOST = host3)(PORT = 1521))"+
    "(ADDRESS = (PROTOCOL = TCP)(HOST = host4)(PORT = 1521))"+
    "(LOAD_BALANCE = yes)"+
    "(CONNECT_DATA ="+
     "(SERVER = DEDICATED)"+
      "(SERVICE_NAME = PQR)"+
      "(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 20)(DELAY = 1))"+ 
   " )";
String url = "jdbc:oracle:thin:@"+sid;
                	Class.forName("oracle.jdbc.driver.OracleDriver");
                    con = DriverManager.getConnection(url,userName,pwd);

Any idea?

[Wendy Gibbons]

did you copy and paste the SID from somewhere as all those hosts sharing the port looks a bit suspicious to me.

it is where i would start looking.

[Martin Vajsar]

If the hosts could no be reached, it would give a different exception (I'd say). Of course, the connection string can (and should!) be verified using TNSPING.

I've never heard of the NL Exception, but a cursory search on the net shows it is a wild beast. I'll move this question to our Oracle forum, where our Oracle folks hang out.

Also, ojdbc5.jar comes in different versions. You might try to download the most recent one.

[Arjun Shastry]

Wendy Gibbons wrote:did you copy and paste the SID from somewhere as all those hosts sharing the port looks a bit suspicious to me.

it is where i would start looking.

I copied from tnsnames.ora file from database server. All port values are 1521. I will try using ojdbc6.jar

[Arjun Shastry]

I used Service URL and was able to connect.