Home » RDBMS Server » Server Administration » ORA-01000: maximum open cursors exceeded (Oracle 11G, Solaris 5.10)
ORA-01000: maximum open cursors exceeded [message #583115] Fri, 26 April 2013 00:31 Go to next message
Tlg13team
Messages: 82
Registered: June 2008
Location: MGL
Member
Dears,

My current database MAX OPEN CURSORS VALUE=300.
Applications "A","B","C" using same DB user (USER1) then connect to a database.

Last night I created dedicated DB user (USER2) then application "B" connect to DB using this new user.

Starting traffic increase today morning "B" application receiving "ORA-01000: maximum open cursors exceeded" error from DB.
When I change current DB user USER2 to USER1, application did not receiving above errors.

I don't understanding what happening in database?


Tugsuu
Re: ORA-01000: maximum open cursors exceeded [message #583119 is a reply to message #583115] Fri, 26 April 2013 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is in the application.
It MUST close its cursors.

Regards
Michel
Re: ORA-01000: maximum open cursors exceeded [message #583121 is a reply to message #583119] Fri, 26 April 2013 01:07 Go to previous messageGo to next message
Tlg13team
Messages: 82
Registered: June 2008
Location: MGL
Member
Hi Michel,

if it's related to the applition, why this error doesn't occur when application user USER1?
Re: ORA-01000: maximum open cursors exceeded [message #583122 is a reply to message #583121] Fri, 26 April 2013 01:14 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because the application behaves differently.

Regards
Michel
Re: ORA-01000: maximum open cursors exceeded [message #583141 is a reply to message #583122] Fri, 26 April 2013 05:11 Go to previous messageGo to next message
Tlg13team
Messages: 82
Registered: June 2008
Location: MGL
Member
I found the reason of this issue.
USER2 doesn't have some tables permission.
when a query execution failed in the application, application do not close db session in the code.
Re: ORA-01000: maximum open cursors exceeded [message #583142 is a reply to message #583141] Fri, 26 April 2013 05:22 Go to previous message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
This is what I was thinking.

Regards
Michel
Previous Topic: pga_aggregate_target
Next Topic: ORA-00119: invalid specification for system while dbca deleteDatabase
Goto Forum:
  


Current Time: Sat Apr 19 16:35:34 CDT 2014

Total time taken to generate the page: 0.05306 seconds