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
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
ReplyDeletedata analytics courses in dubai
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!
ReplyDeleteThis post is full of useful insights. Thanks for always delivering quality content.
ReplyDeleteData science courses in Thailand