Home » RDBMS Server » Server Administration » Maximum open cursors exceeded error
Maximum open cursors exceeded error [message #59363] Thu, 13 November 2003 10:42 Go to next message
Josh
Messages: 9
Registered: August 1999
Junior Member
java.lang.Exception: CxConnectionProxy.handleException: the database connection
is bad and cannot be safely replaced (the connection failure occurred in the mid
dle of a transaction). java.sql.SQLException: ORA-01000: maximum open cursors ex
ceeded

Can someone tell me how i close the cursors using sql plus or toad?

Thanx

Report message to a moderator

Re: Maximum open cursors exceeded error [message #59371 is a reply to message #59363] Thu, 13 November 2003 21:33 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
U may increase the open_cursors parameter in initSID.ora/spfileSID.ora file. Need to restart the instance depending upon the version of Oracle u r using.

Regard,
Sachin

Report message to a moderator

Re: Maximum open cursors exceeded error [message #59374 is a reply to message #59363] Thu, 13 November 2003 22:42 Go to previous messageGo to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
U may increase the open_cursors parameter in initSID.ora/spfileSID.ora file. Need to restart the instance depending upon the version of Oracle u r using.

Regard,
Sachin

Report message to a moderator

Re: Maximum open cursors exceeded error [message #59381 is a reply to message #59363] Fri, 14 November 2003 07:35 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Long term soln would be to fix your app to close the cursors appropriately,whenever you are done.

You could do a alter system flush shared_pool; to close most of the cursors , but this is not the ideal way to do it. It flushes most of the contents of shared pool.

Report message to a moderator

Previous Topic: Re: how to do Incremental Export through export command ?
Next Topic: Database Name!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 15:40:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.