OraFAQ Forum: Server Administration » ORA-01000: maximum open cursors exceeded

Home » RDBMS Server » Server Administration » ORA-01000: maximum open cursors exceeded (Oracle 11G, Solaris 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01000: maximum open cursors exceeded [message #583115]

Fri, 26 April 2013 00:31

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior 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

Report message to a moderator

Re: ORA-01000: maximum open cursors exceeded [message #583119 is a reply to message #583115]

Fri, 26 April 2013 00:59

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The problem is in the application.
It MUST close its cursors.

Regards
Michel

Report message to a moderator

Re: ORA-01000: maximum open cursors exceeded [message #583121 is a reply to message #583119]

Fri, 26 April 2013 01:07

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior Member

Hi Michel,

if it's related to the applition, why this error doesn't occur when application user USER1?

Report message to a moderator

Re: ORA-01000: maximum open cursors exceeded [message #583122 is a reply to message #583121]

Fri, 26 April 2013 01:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Because the application behaves differently.

Regards
Michel

Report message to a moderator

Re: ORA-01000: maximum open cursors exceeded [message #583141 is a reply to message #583122]

Fri, 26 April 2013 05:11

Tlg13team
Messages: 100
Registered: June 2008
Location: MGL

Senior 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.

Report message to a moderator

Re: ORA-01000: maximum open cursors exceeded [message #583142 is a reply to message #583141]

Fri, 26 April 2013 05:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.
This is what I was thinking.

Regards
Michel

Report message to a moderator

Previous Topic:	pga_aggregate_target
Next Topic:	ORA-00119: invalid specification for system while dbca deleteDatabase

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:36:41 CST 2024