Home » SQL & PL/SQL » Client Tools » geting error when trying to connect to oracle (oracle 8i)
geting error when trying to connect to oracle [message #289590] Mon, 24 December 2007 03:32 Go to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi
sometime i am getting the error when i am trying to connect to oracle.
ora-00020: maximun number of process(59) exceeded

i want to know the solution and reason of that error.

regards
jitender.
Re: geting error when trying to connect to oracle [message #289591 is a reply to message #289590] Mon, 24 December 2007 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your database has a limit of 59 sessions and you reached it.
Ask your DBA to increase the SESSIONS parameter.

Regards
Michel
Re: geting error when trying to connect to oracle [message #289592 is a reply to message #289591] Mon, 24 December 2007 03:44 Go to previous messageGo to next message
jitender.sadh
Messages: 82
Registered: May 2007
Member
hi
can you tell me the file name from which i can increase that limit.

regards
jitender
Re: geting error when trying to connect to oracle [message #289606 is a reply to message #289592] Mon, 24 December 2007 04:51 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask you DBA, this depends on your configuration.

Regards
Michem
Previous Topic: SQL*PLUS, TOAD and Command Prompt
Next Topic: Difference between DEFINE and VARIABLE
Goto Forum:
  


Current Time: Sat Dec 03 01:34:19 CST 2016

Total time taken to generate the page: 0.21239 seconds