carlino70
asked on
Problem with connection between APP JAVA and Oracle Database.
Hi experts, I try to access from an application to the Oracle database, but I detect this error in the logs:
How I can test a connection from Java to the Oracle database?
Note: In the Oracle server, a name change and IP was performed. After that the application could not connect.
Thanks
Regards
host:/cots/ENet/log> vi stdout.log
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
geh.data.ViewException: Unable to perform operation
at geh.appserver.DataBroker.getHISRFrequencyData(DataBroker.java:9567)
at geh.appserver.AppServerController.getHISRFrequencyData(AppServerController.java:11398)
at geh.appserver.AppServer.getHISRFrequencyData(AppServer.java:8670)
at geh.servlet.AdapterServlet.invokeCommand(AdapterServlet.java:2241)
at geh.servlet.AdapterServlet.doPost(AdapterServlet.java:163)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:138)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:197)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
and:host:/cots/ENet/log> vi enternetserver.log.1
12 Mar 11:42:10,116 [Thread-25890]: DEBUG geh.util.database.DBPoolFacade - GETTING CONNECTION FROM POOL: hisrdbora
12 Mar 11:42:10,116 [Thread-25890]: DEBUG geh.util.database.DBPoolFacade - ERROR GETTING NUMBER OF AVAILABLE CONNECTIONS FOR CACHE [hisrdbora]
java.sql.SQLException: Connection Cache with this Cache Name does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.pool.OracleConnectionCacheManager.getNumberOfActiveConnections(OracleConnectionCacheManager.java:621)
at geh.util.database.DBPoolFacade.getCheckedOutConnections(DBPoolFacade.java:1859)
at geh.util.database.DBPoolFacade.access$2100(DBPoolFacade.java:46)
at geh.util.database.DBPoolFacade$5.doExecute(DBPoolFacade.java:1099)
at geh.util.ExecutionTimer$2.run(ExecutionTimer.java:103)
at java.lang.Thread.run(Thread.java:619)
12 Mar 11:42:10,116 [Thread-25890]: ERROR geh.util.database.DBPoolFacade - UNABLE TO GET CONNECTION FROM DATABASE POOL hisrdbora
java.sql.SQLException: Oracle Pool is null...Oracle unavailable
at geh.util.database.DBPoolFacade.getConnectionFromPool(DBPoolFacade.java:1899)
at geh.util.database.DBPoolFacade.access$2200(DBPoolFacade.java:46)
at geh.util.database.DBPoolFacade$5.doExecute(DBPoolFacade.java:1101)
at geh.util.ExecutionTimer$2.run(ExecutionTimer.java:103)
at java.lang.Thread.run(Thread.java:619)
12 Mar 11:42:10,117 [Connection Ping Timer for Pool: hisrdbora]: ERROR geh.util.database.DBPoolFacade - UNABLE TO OBTAIN CONNECTION, RETURNED NULL
Could you please guide me in finding the solution?How I can test a connection from Java to the Oracle database?
Note: In the Oracle server, a name change and IP was performed. After that the application could not connect.
Thanks
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I'm not sure. The cache called 'hisrdbora' is not available under that name now
ASKER
sorry, but "hisrdbora" would be on the app server or on oracle server?
I'm not a Java developer, and I did not do the installation.
Thankyou
I'm not a Java developer, and I did not do the installation.
Thankyou
Not sure i'm afraid
ASKER
The connection between APP and the Oracle database, It is configured to read the service_name parameter. I added a second option of service_name and the connection was established.
Thankyou
Thankyou
:)
ASKER