BEA Weblogic Question: Download Questions PDF
Why am I getting an ORA-01000: maximum open cursors exceeded error, even though I closed all ResultSet, Statement, and Connection objects?
![BEA Weblogic Interview Answer BEA Weblogic Interview Question](https://globalguideline.com/public/images/interview/15.png)
Answer:
This is an Oracle issue. According to Oracle's documentation, dynamic cursors can remain open from run to run in a session and are not closeable when a procedure closes. To work around this issue, you can increase the number of open cursors allowed in the database or you can reset the connection pool (close and reopen database connections in the connection pool).
To reset the connection pool, you can untarget and retarget the connection pool using the Administration Console. You can also use the reset() method through the JMX API or the RESET_POOL command on the WebLogic Server command line interface.
To reset the connection pool, you can untarget and retarget the connection pool using the Administration Console. You can also use the reset() method through the JMX API or the RESET_POOL command on the WebLogic Server command line interface.
Download BEA Weblogic Interview Questions And Answers
PDF
Previous Question | Next Question |
How do I prevent errors when running t3dbping? | Are there C/C++ interfaces to WLS JMS? |