WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Oracle database connection hangs

    Posted 10/19/20 10:24 PM

    Hello forum,

    We have WebSphere 8.5.17 using an Oracle database.

    We found some code will sometimes hang the database connection. When the connections reach the Maximum pool size our application and JVM will lock up. We then have to restart the jvm application to allow acces.

    How can fix this problem.

    thanks

    Jim



    #Support
    #SupportMigration
    #WebSphereApplicationServer(WAS)


  • 2.  RE: Oracle database connection hangs

    Posted 10/20/20 06:43 AM

    Hello jimmy,

    What I actually got from your query is that there is a error in configuration of your JVM.

    To Fix this error you have to configure and manage JVM correctly.

    Like this if your error is resolved.

    Thanks and Regards,

    Vaibhav Pal



    #Support
    #SupportMigration
    #WebSphereApplicationServer(WAS)


  • 3.  RE: Oracle database connection hangs

    Posted 10/22/20 02:44 PM

    Hey Bro,

    Fix Oracle Hanging:

    • Pathing hang - Make sure that your Oracle environment variables are properly set ($ORACLE_HOME).
    • External hang - The network being down, Kerberos security issues, SSO or a firewall issue can cause an Oracle connection to hang. ...
    • Listener down/hanging - Start by checking the listener (check lsnrctl stat).

    Read More Click: http://www.dba-oracle.com/t_fix_hanging.htm

    Thanks and Best Regards:

    thepermfumesdiary



    #Support
    #SupportMigration
    #WebSphereApplicationServer(WAS)