I have a DB connection to a Oracle 9i database that was working without any issues (61 records have been written succesfull so far) until just a few days ago. Now I am getting this error in my VXML log

com.avaya.sce.runtimecommon.SCERuntimeException: SQL Error on Database execution:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection 

NOTE: I can use SQLplus to connect to the database. I can connect from DD to creat new DBOP, the server can be pinged from the application server. So I''m not sure why it is saying the network adapter can not connect.

Here are the details in the report.log


java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
   at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:334)
   at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
   at java.sql.DriverManager.getConnection(DriverManager.java:512)
   at java.sql.DriverManager.getConnection(DriverManager.java:171)
   at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:160)
   at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:708)
   at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:445)
   at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:370)
   at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:631)
   at com.avaya.sce.runtime.jdbc.Database.open(Database.java:65)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:99)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:75)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:61)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:165)
   at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:148)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:536)
 | Exception stack trace | Error processing request
 EXCEPTION> 
com.avaya.sce.runtimecommon.SCERuntimeException: SQL Error on Database execution:java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
**** Root Cause 
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
   at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
   at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:334)
   at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:442)
   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:321)
   at java.sql.DriverManager.getConnection(DriverManager.java:512)
   at java.sql.DriverManager.getConnection(DriverManager.java:171)
   at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:160)
   at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:708)
   at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.registerPool(PerUserPoolDataSource.java:445)
   at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.getPooledConnectionAndInfo(PerUserPoolDataSource.java:370)
   at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:631)
   at com.avaya.sce.runtime.jdbc.Database.open(Database.java:65)
   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:99)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:75)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:61)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:165)
   at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:148)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:536)

   at com.avaya.sce.runtime.connectivity.db.DbQuery.execute(DbQuery.java:110)
   at com.avaya.sce.runtime.Data.handleRequest(Data.java:75)
   at com.avaya.sce.runtime.AppServlet.processRequest(AppServlet.java:61)
   at com.avaya.sce.runtime.SCEServlet.requestHandler(SCEServlet.java:165)
   at com.avaya.sce.runtime.SCEServlet.doGet(SCEServlet.java:148)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
   at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
   at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
   at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
   at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
   at java.lang.Thread.run(Thread.java:536)

I did a google search on the error you are getting and it seems like a common problem.  Possible problems looks to be:

1: If your client program is running in some machine(say windows) other than your Oracle Server machine(Say Solaris), sometimes, your client machine''s adaptor may not be able to resolve the IP of the Oracle server hostname. In this case you will get the above told error.

Instead giving hostname, just give IP address(like 189.8.9.x)

2: Check the database server is not running on mts mode

I''m using all IP''s (no hostnames) and the Oracle is running on a AIR so how would I check to see if the DB is running in MTS?

Did you check the datasouce definition in the app server, and make sure the ip and port are still correct? In the case of Tomcat, check the <app_name>.xml file in conf/catalina/localhost

Yes I did...

So you can ping the database server machine from the app server machine. can you ping the app server machine from the database machine?

Has anyone figured out this? We had an upgrade to our Oracle database from a single Sun box to a cluster of three high performance Linux hosts. Now I am getting this error:

event="error.runtime" message="Error processing request, com.avaya.sce.runtimecommon.SCERuntimeException: SQL Error on Database execution:java.sql.SQLExce
ption: Io exception: The Network Adapter could not establish the connectionDSRA0010E: SQL State = null, Error Code = 17,002DSRA0010E: SQL State = null, Error
Code = 17,002

I get a good test connection from the app server, and from DD, but when making a test call, it fails with the above message. I also tried replacing the hostnames with the IP addresses.

How did you do the test connect from DD? Did you use the validate.jsp page? If not, could you use the DB validation link in the validate.jsp page to test the datasource and let me know?

Sorry, there is no datasource validation in DD 3.0. Still my question is how you test the connection from DD as you claimed.

I did some google searches and it seems like it is a configuration issue on your oracle. Most of the threads I found point to the listeners.ora configuration. Basically it seems that the error can has many different causes, so it will take some playing around and research to figure out why you're getting the network adapter problems from JDBC/Oracle.

http://www.websina.com/bugzero/kb/oracle-connection.html
http://www.dbmotive.com/oracle_error_codes.php?errcode=17002
http://www.dbforums.com/archive/index.php/t-970300.html
http://forum.java.sun.com/thread.jspa?threadID=291584&start=0&tstart=0
http://forums.oracle.com/forums/thread.jspa?threadID=115573

(Wilson) To test my connection in DD, I add a DB operation with the database connection info. If there was a problem connecting to Oracle, it would spit out an error.

(Erik) Thanks, I'll check them out.

I see. But the development machine where you create the DB operation is different from the the machine where you run the apps, correct? In this case, you have to make sure the connection between the app server is good. Do try out what Erik suggests.

FYI

We found out that you need to reboot the Websphere server if there are changes made to Oracle.