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

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

    ReplyDelete
  7. 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
  8. 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
  9. Packers and Movers Ahmedabad - We Provide ***Best Service Providers, Safe, Reliable, Affordable, Trusted ###Movers and Packers in Ahmedabad List, Household Shifting, Office Relocation: Choose Top Verified Packers and Movers Ahmedabad Compare ???Shifting Service Chrages, Price Quotation, Rate List Charts and Save Money and Time @ Packers and Movers Ahmedabad

    ReplyDelete
  10. 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
  11. 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
  12. 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
  13. 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
  14. من افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل افضل شركه مكافحه حشرات بجده التي تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة

    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 courses

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

    ReplyDelete
  17. 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
  18. 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
  19. 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!
    data analytics course mumbai

    ReplyDelete
  20. 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
  21. I think your blog will easily to get the correct market, because it’s having the piece of content. So it can easily to attract the visitors. Please feel free visit our website @ Packers And Movers Mumbai

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

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

    ReplyDelete
  29. 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
  30. 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
  31. You should get certification in the relevant courses if you need to be considered for recruiting data experts.
    data science training in borivali

    ReplyDelete
  32. 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
  33. Acquire a firm grounding in the theory of Data Science by signing up for the Data Science courses in hyderabad. Master the relevant skills along with all the essential tools and techniques of Data Science. Get to avail benefits like Flexible timings, Best industry trainers, and a meticulously crafted curriculum with hands-on projects that will give you exposure to a real-world working environment.data scientist course in hyderabad

    ReplyDelete
  34. You have written an excellent article. After reading your article, people like us, and we get a lot of information. Please keep writing such articles in the feature, and I wish you all the best for sharing this excellent article with us
    Packers Mart
    Packers and movers Rohini
    Packers and movers Mumbai
    Packers and movers Pune
    Packers and movers Chandigarh
    Packers and movers Jaipur
    Packers and movers Noida
    Packers and movers Rohtak

    ReplyDelete