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...
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
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
ReplyDeleteData Analytics Courses in Mumbai
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.
ReplyDeleteExcelR Machine Learning Training in Bangalore
Welcomhotel Bangalore Escorts
ReplyDeleteLe Meridien Bangalore Escorts
Taj MG Road Bangalore Escorts
AirHostess Escorts Bangalore
Verified Bangalore Escorts
Models Escorts Bangalore
Beautiful Escorts in Bangalore
Beautiful Bangalore Escorts
Bangalore Escorts
This comment has been removed by the author.
ReplyDeleteHousewives Escorts
ReplyDeleteCall Center Girls Escorts
VIP Escorts
Fresh Escorts
Escorts in Chennai
Chennai Escorts
Bangalore Escorts
Escorts in Bangalore
I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeletedata analytics courses
This comment has been removed by a blog administrator.
ReplyDeleteSo this is the thing that happens when an author does the schoolwork expected to compose quality material. Much thanks for sharing this awesome substance.
ReplyDeleteSEO services in kolkata
Best SEO services in kolkata
SEO company in kolkata
Best SEO company in kolkata
Top SEO company in kolkata
Top SEO services in kolkata
SEO services in India
SEO copmany in India
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.
ReplyDeleteOnline 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
"Hi! If you need technical help regarding QuickBooks
ReplyDeleteQuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Tech Support
QuickBooks Support Phone Number
QuickBooks Enterprise Support
QuickBooks tech Support
QuickBooks Payroll Support
QuickBooks Payroll Support Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Support Phone Number
QuickBooks Tech Support Phone Number
QuickBooks Pro Support Phone Number
QuickBooks Enterprise Support Phone Number
QuickBooks Support Phone Number
QuickBooks Payroll Support Phone Number"
"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.
ReplyDeleteQuickbooks Support Phone Number (800)754-6180"
Hi! If you need technical help regarding Quickbooks issues, dial toll-free number +1-800-754-6180 for quickbooks support phone number.
ReplyDeleteQuickbooks Support Phone Number (800)754-6180
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
Hi! If you need technical help regarding QuickBooks Tech Support Number
ReplyDeleteQuickBooks Tech Support Number
QuickBooks Tech Support Number
QuickBooks Tech Support Number
QuickBooks Tech Support Number
QuickBooks Tech Support Number
Hi! If you need technical help regarding
ReplyDeleteQuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
QuickBooks enterprise support number
Hi! If you need technical help regarding quickbooks, dial
ReplyDeletequickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
quickbooks support phone number
Hi! If you need technical help regarding quickbooks enterprise phone number please contact.
ReplyDeletequickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
quickbooks enterprise phone number
curry shoes
ReplyDeletelebron shoes
off white shoes
kobe shoes
bape
golden goose outlet
nike x off white
giannis shoes
golden goose sneakers
lebron 18
Your blog is extremely wonderful. Whenever I read your blog, I prefer it considerably. many thanks considerably for sharing such a blog with us.
ReplyDeleteLocal 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
Nice blog, informative content. I really enjoyed while reading this blog. I bookmarked your site for further reads. Keep sharing more.
ReplyDeleteData Science Course Training in Hyderabad
Data Science Course Training Institute in Hyderabad with Placements
شركة دهب كلين اقوى شركات مكافحة الحشرات هى التى تتخالص من جميع انواع الحشرات بدون المغادره
ReplyDeleteشركة مكافحة حشرات بالخبر
شركة مكافحة حشرات بالجبيل
شركة مكافحة حشرات بالاحساء
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
ReplyDeletePackers 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
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
ReplyDeletepackers and movers quotation
ReplyDeletePackers and Movers Whitefield Bangalore
Packers and Movers Bangalore to Ahmedabad
Packers and Movers Bangalore to Chennai
Packers and Movers Bangalore to Coimbatore
Packers and Movers Bangalore to Delhi
Packers and Movers Bangalore to Erode
Packers and Movers Bangalore to Gurgaon
Packers and Movers Bangalore to Guwahati
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.
ReplyDeleteData science courses in Gurgaon
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!
ReplyDeleteData Science Courses in Singapore
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.
ReplyDeleteData science courses in Ghana
This comment has been removed by the author.
ReplyDeleteThis 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
ReplyDeleteThe post provides detailed information about the topic Oracle. Loved enjoyed reading the details.
ReplyDeleteData Science Courses in Hauz Khas
excellent post with step by step explanation very useful content. I enjoyed reading it.
ReplyDeleteOnline Data Science Course
nice piece of work and very detailed explanation on Oracle db
ReplyDeletedata analytics courses in Singapore
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.
ReplyDeleteOnline Data Science Course
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!
ReplyDeleteThanks 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!
ReplyDeleteData science courses in Bangalore
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.
ReplyDeleteHi blogger, really nice blog and very informative content, thank you for sharing.
ReplyDeleteData science course in Bangalore
This is a nice blog. It is very short and direct.
ReplyDeleteData science courses in chennai
Such a thought-provoking article! I loved how you explained complex ideas in such a simple, relatable way
ReplyDeleteData science courses in Bangalore
The insights into WebLogic JDBC extensions are fantastic and very helpful for database professionals. Thanks for explaining it so well. Keep posting technical guides
ReplyDeleteData science course in Gurgaon
Nice article. Good to know new information!
ReplyDeleteDigital marketing courses in mumbai
This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. Investment Banking Course
ReplyDeleteThis informational resource in blog format is very useful and informational.
ReplyDeletetechnical writing course
the article about the oracle extension have verified at DB level and everything working fine except more connections hanging around and not releasing. IIM SKILLS Data Science Course Reviews
ReplyDeleteVery good article on Oracle DBA. Thanks for the share.
ReplyDeletetechnical writing course
Thank you for this detailed and insightful post.digital marketing courses in delhi
ReplyDeleteGreat troubleshooting approach! It's crucial to regularly review configurations and ensure proper load balancing to prevent issues like pool suspension and connection leaks in WebLogic.
ReplyDeleteData science courses in Mumbai
Data science courses in Mumbai
Name: INTERN NEEL
Email ID: internneel@gmail.com
The insights into WebLogic JDBC extensions are fantastic and very helpful for database professionals. Thanks for explaining it so well. Keep posting technical guides
ReplyDeleteData Science Courses in Micronesia
https://iimskills.com/data-science-courses-in-micronesia/
Data Science Courses in Micronesia
This is such a great resource that you are providing, and sharing it with us . I love seeing blog that understand the value of providing a quality resource to others Best Medical Coding Course
ReplyDeletemanaging database is tricky. there are lot of learning on the jobMedical Coding Course
ReplyDeleteThank you so much for providing this informative post !!!
ReplyDeleteMedical Coding Courses in Chennai
It sounds like the issue stems from a combination of inefficient query execution, potential connection leaks, and misconfigured connection timeouts. If the database itself is performing well but connections are still lingering, the recent patch and outdated configurations (Pcclient.jnlp, Jndiurl.properties) could be redirecting traffic inefficiently or preventing proper connection release.Medical Coding Courses in Kochi
ReplyDeleteThis site gives us information about the issues in the web logic.
ReplyDeleteMedical Coding Courses in Bangalore
Begin by recognizing the effort, time, or expertise invested in the work.
ReplyDeletehttps://iimskills.com/medical-coding-courses-in-delhi/
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.
ReplyDeleteMedical Coding Course in Hyderabad
Thank you for sharing this detailed analysis! It’s great to see how identifying connection imbalances and updating the configuration resolved the WebLogic pool exhaustion issue effectively. A clear and practical approach!
ReplyDeleteMedical coding courses in Delhi/
"The support system at IIM SKILLS is fantastic. They helped me navigate through the course and provided valuable career resources."
ReplyDelete"The instructors at IIM SKILLS go beyond teaching. They are genuinely invested in the students' success and provide personalized attention.
Medical Coding Courses in Coimbatore
It sounds like the WebLogic connection pool exhaustion issue is causing significant slowdowns. Checking and tuning connection pool settings, such as increasing the maximum pool size or enabling connection leak profiling, might help. Hope you find a stable solution soon! Medical Coding Courses in Delhi
ReplyDeleteIIMs taught me to think strategically. The focus on long-term goals, risk assessment, and market analysis prepared me for decision-making in the corporate world.
ReplyDeleteMedical Coding Courses in Chennai
Great troubleshooting approach! It's crucial to regularly review configurations and ensure proper load balancing to prevent issues like pool suspension and connection leaks in WebLogic.
ReplyDeletehttps://iimskills.com/medical-coding-courses-in-bangalore/
Thank you for this detailed and insightful post.
ReplyDeletehttps://iimskills.com/medical-coding-courses-in-hyderabad/
Optimizing systems is key—just like precision in medical coding! Explore medical coding courses in Delhi for a growing career.
ReplyDeleteMedical Coding Courses in Delhi
Great insights! You’ve made this topic so much easier to understand. Medical Coding Courses in Delhi
ReplyDeleteThanks for the detailed breakdown! Faced a similar issue recently—your insights on connection leaks and load balancing really helped us pinpoint the root cause. Much appreciated
ReplyDeleteMedical Coding Courses in Delhi
I was stuck on this for a while, and your post helped me move forward. Much appreciated!
ReplyDeleteMedical Coding Courses in Bangalore
I learn new information from your article , you are doing a great job .
ReplyDeleteMedical Coding Courses in Delhi
This typically happens when the pool runs out of available connections. https://iimskills.com/data-science-courses-in-india/
ReplyDeleteI feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
ReplyDeleteData Science Courses in India
This typically happens when the pool runs out of available connections.
ReplyDeleteData Science Courses in India