Friday, September 20, 2019

weblogic.jdbc.extensions.PoolDisabledSQLException

We have come across content pool suspended issue in WebLogic as pool got exhausted. All new connections failings and existing connections are running very slow. Which intern created issue in Agile PLM as it is using WebLogic.

weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool AgileContentPool is Suspended, cannot allocate resources to applications..
        at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:265)
        at weblogic.jdbc.jts.Driver.newConnection(Driver.java:900)
        at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:220)
        at weblogic.jdbc.jts.Driver.connect(Driver.java:170)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:523)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:516)
        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:512)
<2019-09-10 10:38:56,366> <PCMHelperSessionBean_9xz6y2_Impl:ERROR> Session terminated...

To find the root causes examine the thread dumps while the error is occurring and pay attention to stuck thread.

If there are long running queries find out what it is running and users may see ORA-00020: Maximum number of processes reached.

Possible reasons :

1. Database running some custom or un-optimized long running queries
2. Application forgot to release the connection back to pool due to recent config changes, which can result connection leak.
3. Inactive connection timeout value may need to change to support system growth/load.

We have verified at DB level and everything working fine except more connections hanging around and not releasing. After investigation we found that most of the connections going though one server due to recent patch and didn’t update the Pcclient.jnlp, Jndiurl.properties..etc

After updating the config we see that user connections going trough all servers and connection load balance happening as expected and issue has been resolved.

Hope this post helps to resolve Agile Content pool suspended issue.

Thanks,
Satishbabu Gunukula, Oracle ACE

43 comments:

  1. Attend Business Analytics Training in Mumbai with 100% Syllabus Covered also Attend the Best Data Science Course in Mumbai. Faculty are From IIT & ISB. ExcelR is the Best Institute for Data Science Training in Mumbai
    Data Analytics Courses in Mumbai

    ReplyDelete
  2. Attend The Machine Learning Training in Bangalore From ExcelR. Practical Machine Learning Training in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Machine Learning Training in Bangalore.
    ExcelR Machine Learning Training in Bangalore

    ReplyDelete
  3. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    data analytics courses

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete
  5. On the off chance that individuals that compose articles thought progressively about composing incredible material like you, more perusers would peruse their substance. It's invigorating to discover such unique substance in an in any case duplicate feline world. Much obliged to you to such an extent.

    Online Teaching Platforms
    Online Live Class Platform
    Online Classroom Platforms
    Online Training Platforms
    Online Class Software
    Virtual Classroom Software
    Online Classroom Software
    Learning Management System
    Learning Management System for Schools
    Learning Management System for Colleges
    Learning Management System for Universities

    ReplyDelete
  6. "Hi! If you need technical help regarding Quickbooks issues, dial Quickbooks Support Phone Number (800)754-6180, dial our toll-free number +1-800-754-6180 for technical support.
    Quickbooks Support Phone Number (800)754-6180"

    ReplyDelete
  7. Your blog is extremely wonderful. Whenever I read your blog, I prefer it considerably. many thanks considerably for sharing such a blog with us.
    Local packers and movers in Rohini
    Local packers and movers in Dwarka
    Local packers and movers in Shalimar Bagh
    Local packers and movers in Pitam Pura

    ReplyDelete
  8. Nice blog, informative content. I really enjoyed while reading this blog. I bookmarked your site for further reads. Keep sharing more.
    Data Science Course Training in Hyderabad
    Data Science Course Training Institute in Hyderabad with Placements

    ReplyDelete
  9. شركة دهب كلين اقوى شركات مكافحة الحشرات هى التى تتخالص من جميع انواع الحشرات بدون المغادره
    شركة مكافحة حشرات بالخبر
    شركة مكافحة حشرات بالجبيل
    شركة مكافحة حشرات بالاحساء

    ReplyDelete
  10. Relocation for companies and private individuals with a free viewing and preliminary discussion. Your house or office furniture dismantling and furniture assemblies are carried out by a packing and assembly specialist

    Packers and movers in Sector 22
    Packers and movers in Sector 44
    Packers and movers in Sector 39
    Packers and movers in Sector 137
    Packers and movers in Sector 19
    Packers and movers in Sector 18

    ReplyDelete
  11. best replica bags online 2018 replica gucci l9c66l0y59 replica bags in london image source z0y13a3d08 replica designer bags wholesale replica bags india pop over to these guys m9z92x8q70 replica ysl replica bags hermes v7b08o3j59

    ReplyDelete
  12. WebLogic JDBC extensions provide additional features for JDBC connections, including enhanced connection pooling, transaction management, and support for distributed transactions, enabling efficient database interactions and improved performance in Java applications.
    Data science courses in Gurgaon

    ReplyDelete
  13. Great insights on handling the PoolDisabledSQLException in WebLogic! Your thorough explanation helps demystify a common issue many developers face, and sharing such valuable knowledge is what builds a supportive community. Keep up the fantastic work!
    Data Science Courses in Singapore

    ReplyDelete
  14. It discusses the symptoms of the issue, including exhausted pools, slow connections, and a terminated session. The article also details possible causes, such as long-running queries, connection leaks, and misconfigured inactive connection timeouts.
    Data science courses in Ghana

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. This post provides a valuable insight into handling the PoolDisabledSQLException in WebLogic. It's crucial for anyone managing connections to understand how to prevent exhaustion and ensure smooth operation, especially with applications like Agile PLM. Thank you for sharing this informative content! Data Science Courses In Malviya Nagar

    ReplyDelete
  17. The post provides detailed information about the topic Oracle. Loved enjoyed reading the details.
    Data Science Courses in Hauz Khas

    ReplyDelete
  18. excellent post with step by step explanation very useful content. I enjoyed reading it.
    Online Data Science Course

    ReplyDelete
  19. This was such a delightful read! Your humor and personal touch on oracle is really appreciative as it helped me a lot. Such a useful post.
    Online Data Science Course







    ReplyDelete
  20. Very insightful post! The explanation of the WebLogic/JDBC ExtensionsPoolDisabledSQLException issue is clear and practical. Your troubleshooting steps are detailed and helpful for anyone managing Oracle environments. Thanks for sharing this valuable knowledge

    data analytics courses in dubai

    ReplyDelete
  21. What a great post! Your insights into data science are incredibly informative. If anyone is considering a career change, the Data Science course in Dadar sounds like a perfect option. It could provide the skills needed to excel in today’s job market. Your writing style is engaging and makes complex ideas more digestible. I’m definitely more interested in data science after reading this! Thank you for sharing!

    ReplyDelete
  22. Thanks for the detailed explanation regarding the WebLogic JDBC extensions! Your insights on troubleshooting the pool disabled issue are incredibly helpful. It's great to see practical solutions for common problems. Keep up the great work!
    Data science courses in Bangalore

    ReplyDelete
  23. Data science is such a versatile field, and it’s fantastic to see more opportunities available in Iraq. These courses not only provide valuable knowledge but also equip you with the practical skills needed to thrive in the industry. If you're ready to dive into data science, I highly recommend checking out the full list of courses here.

    ReplyDelete
  24. Hi blogger, really nice blog and very informative content, thank you for sharing.
    Data science course in Bangalore

    ReplyDelete
  25. What a fantastic read. Your perspective on web logic was refreshing and thought-provoking. I’m definitely going to take action on your suggestions.
    Data Science Courses in China


    ReplyDelete
  26. Such a thought-provoking article! I loved how you explained complex ideas in such a simple, relatable way
    Data science courses in Bangalore

    ReplyDelete
  27. This post on WebLogic JDBC Extensions is incredibly detailed and useful. It’s a fantastic resource for database administrators. Excellent work!
    Data science course in Lucknow

    ReplyDelete
  28. The insights into WebLogic JDBC extensions are fantastic and very helpful for database professionals. Thanks for explaining it so well. Keep posting technical guides
    Data science course in Gurgaon

    ReplyDelete
  29. Nice article, I got new information from your article, keep sharing.
    IIM SKILLS Data Science Course Review 

    ReplyDelete