java.sql.SQLRecoverableException: IO Error: NL Exception was generated

Tested LAB Details
================================
DB Version 11g r2 11.2.0.3.0
RHEL 6.4 64bit

faced this issue…

11 Apr 2014 14:40:45,078 [TRACE] SVR-SCH0 [TRAN-FACTORY] ST KEY : [11] com.elitecore.core.commons.util.db.DatabaseInitializationException: java.sql.SQLRecoverableException: IO Error: NL Exception was generated
 at com.elitecore.core.commons.util.db.datasource.OracleConnectionDataSource.init(OracleConnectionDataSource.java:103)
 at com.elitecore.core.commons.util.db.DBConnectionManager.init(DBConnectionManager.java:264)
 at com.elitecore.core.commons.util.db.DBConnectionManager.init(DBConnectionManager.java:203)
 at com.elitecore.core.commons.util.db.DBConnectionManager.reInit(DBConnectionManager.java:173)
 at com.elitecore.core.commons.utilx.db.TransactionFactory.scan(TransactionFactory.java:93)
 at com.elitecore.core.commons.utilx.db.TransactionFactory$2.execute(TransactionFactory.java:165)
 at com.elitecore.core.serverx.BaseEliteServer$BaseServerContext$2.run(BaseEliteServer.java:378)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
 at java.util.concurrent.FutureTask.run(FutureTask.java:138)
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)
 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
 at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLRecoverableException: IO Error: NL Exception was generated
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
 at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536)
 at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)
 at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
 at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
 at java.sql.DriverManager.getConnection(DriverManager.java:582)
 at java.sql.DriverManager.getConnection(DriverManager.java:185)
 at com.elitecore.core.commons.util.db.datasource.OracleConnectionDataSource.init(OracleConnectionDataSource.java:98)
 ... 14 more
Caused by: oracle.net.ns.NetException: NL Exception was generated
 at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:614)
 at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:411)
 at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:678)
 at oracle.net.ns.NSProtocol.connect(NSProtocol.java:238)
 at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
 ... 21 more
jdbc:oracle:thin:@(DESCRIPTION = (ENABLE=BROKEN)
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = dbnode1-vip)
(Port = 1521)) (ADDRESS = (PROTOCOL = TCP)(Host = dbnode2-vip)(Port = 1521)))
(FAILOVER = ON) (LOAD_BALANCE=on) (CONNECT_DATA=(SERVICE_NAME = orcl)(SERVER=DEDICATED)
(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))))

working fine with any of below jar.

ojdbc6.jar 11.2.0.2.0
ojdbc6.jar 11.2.0.3.0

http://www.dba-oracle.com/bk_nl_exception_connecting_10g_rac_jdbc.htm

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s