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:
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)
host:/cots/ENet/log> vi enternetserver.log.112 Mar 11:42:10,116 [Thread-25890]: DEBUG geh.util.database.DBPoolFacade - GETTING CONNECTION FROM POOL: hisrdbora12 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 hisrdborajava.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
I'm not sure. The cache called 'hisrdbora' is not available under that name now
0
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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
The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.