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

46 comments:

  1. Packers and Movers Hyderabad Give Certified and Verified Service Providers, Cheap and Best ###Office Relocation Charges, ***Home Shifting, ✔✔✔Goods Insurance worth Rs. 10,000, Assurance for Local and Domestic House Shifting. Safe and Reliable Household Shifting Services in Hyderabad with Reasonable Packers and Movers Price Quotation @ Packers And Movers Hyderabad

    ReplyDelete
  2. Packers and Movers Gurgaon Provide Reliable, Safe and Certified Service Provider list, Get Free ***Best Price Quotaition and Compare Charges. ???Hassle free Household Shifting Services, High Quality packing Material, Office Relocation, Car Transportaion, ###Local and Domestic Shifting Service @
    Packers And Movers Gurgaon

    ReplyDelete
  3. Get Shifting/Relocation Quotation from ###Packers and Movers Delhi. Packers and Movers Delhi 100% Affordable and Reliable ***Household Shifting Services. Compare Transportation Charges and Save Time, Verified and Trusted Packers and Movers in Delhi, Cheap and Safe Local, Domestic House Shifting @
    Packers And Movers Delhi

    ReplyDelete
  4. 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
  5. 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
  6. Attend The PMP Certification in Abu Dhabi From ExcelR. Practical PMP Certification in Abu Dhabi Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP Certification in Abu Dhabi.
    ExcelR PMP Certification in Abu Dhabi

    ReplyDelete
  7. Superb post, we enjoyed each and everything as per written in your post. Thank you for this informative article because it’s really helpful, I really like site.
    Please visit our website: @ Packers and Movers Kolkata

    ReplyDelete
  8. Attend The PMP Certification From ExcelR. Practical PMP Certification Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP Certification.
    ExcelR PMP Certification

    ReplyDelete
  9. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    ExcelR data science course in mumbai

    ReplyDelete
  10. Nice image visibility and well written blog. Thanks for sharing. I have recently come across a new online service provider company which provides Shifting Services .
    Packers And Movers Bangalore

    ReplyDelete
  11. I like viewing web sites which comprehend the price of delivering the excellent useful resource free of charge. I truly adored reading your posting. Thank you!
    data science course in mumbai

    ReplyDelete
  12. من افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل افضل شركه مكافحه حشرات بجده التي تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة

    ReplyDelete
  13. 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
  14. This comment has been removed by a blog administrator.

    ReplyDelete
  15. 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 course mumbai

    ReplyDelete
  16. Nice image visibility and well written blog. Thanks for sharing. I have recently come across a new online service provider company which provides Shifting Services @ Packers And Movers Gurgaon

    ReplyDelete
  17. Hey, Wow all the posts are very informative for the people who visit this site. Good work! We also have a Blog. Please feel free to visit our site. Thank you for sharing.
    Please visit our website : Local Packers And Movers Bangalore

    ReplyDelete
  18. 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
  19. Great information sharing by you, such a hard work post by blogzify

    ReplyDelete
  20. "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
  21. Get Packers and Movers Jaipur List of Top Reliable, 100% Affordable, Verified and Secured Service Provider. Get Free ###Packers and Movers Jaipur Price Quotation instantly and Save Cost and Time. Packers and Movers Jaipur ✔✔✔Reviews and Compare Charges for household Shifting, Home/Office Relocation, ***Car Transportation, Pet Relocation, Bike SHifting @ Packers And Movers Jaipur

    ReplyDelete
  22. 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
  23. 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
  24. شركة دهب كلين اقوى شركات مكافحة الحشرات هى التى تتخالص من جميع انواع الحشرات بدون المغادره
    شركة مكافحة حشرات بالخبر
    شركة مكافحة حشرات بالجبيل
    شركة مكافحة حشرات بالاحساء

    ReplyDelete
  25. 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
  26. We look forward to supporting you with your next household goods relocation and commercial goods relocation to or t Ghaziabad. With moving company Re-housing packers and movers in Ghaziabad, your house shifting and commercial goods relocation will be child's play. Movers and packers take care of all steps of the house relocation or office shifting to or from Ghaziabad, from the planning and packaging of your valuable belongings with a special focus on sensitive objects - to the transport on the day of the relocation. So you don't have to worry about anything and you can devote yourself to the really important things - and enjoy your new home to the fullest from day one.
    Packers and movers in Vasundhara
    Packers and movers in Rajendra Nagar
    Packers and movers in Chander Nagar
    Packers and movers in Nehru Nagar

    ReplyDelete
  27. You should get certification in the relevant courses if you need to be considered for recruiting data experts.
    data science training in borivali

    ReplyDelete
  28. You can take admission to one of the top institutes that offer degrees in data science. In this way, you will learn all the requirements of the field under one roof.
    data science training in lucknow

    ReplyDelete
  29. 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