Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

CloudDBApr 11 2014 — edited Apr 15 2014

Hello Gurus

we are facing below issue in oracle11g r2 11.2.0.3.0 platform

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

please help us

we are using this Oracle RAC - JDBC URL

jdbc:oracle:thin:@(DESCRIPTION = (ENABLE=BROKEN)

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(Host = x.x.x.1)

(Port = 1521)) (ADDRESS = (PROTOCOL = TCP)(Host = x.x.x.2)(Port = 1521)))

(FAILOVER = ON) (LOAD_BALANCE=on) (CONNECT_DATA=(SERVICE_NAME = orcl)

(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))))

share your suggestions

Thanks

hitgon

This post has been answered by CloudDB on Apr 15 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2014
Added on Apr 11 2014
2 comments
3,227 views