OraFAQ Forum: Client Tools » geting error when trying to connect to oracle

Home » Other » Client Tools » geting error when trying to connect to oracle (oracle 8i)

Mon, 24 December 2007 03:32

jitender.sadh
Messages: 86
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.

Mon, 24 December 2007 03:35

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

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

Mon, 24 December 2007 03:44

jitender.sadh
Messages: 86
Registered: May 2007

Member

hi
can you tell me the file name from which i can increase that limit.

regards
jitender

Mon, 24 December 2007 04:51

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

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: Fri Feb 07 05:07:54 CST 2025