Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

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)

Open in new window

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

Open in new window

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
0
carlino70
Asked:
carlino70
  • 4
  • 3
1 Solution
 
CEHJCommented:
Looks like you might have your connection pool and cache misconfigured now
0
 
carlino70Author Commented:
there is a method to test the connection from the pool to the Oracle database?
0
 
CEHJCommented:
I'm not sure. The cache called 'hisrdbora' is not available under that name now
0
Free Tool: ZipGrep

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.

 
carlino70Author Commented:
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
0
 
CEHJCommented:
Not sure i'm afraid
0
 
carlino70Author Commented:
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
0
 
CEHJCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

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.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now