Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Ora-12540 error when i connect as sysdba

Ora-12540 error when i connect as sysdba

From: Joop Gijsbers <joopgij_at_xs4all.nl>
Date: 7 Feb 2003 09:11:17 -0800
Message-ID: <680c3066.0302070911.e5cc289@posting.google.com>


On a new testmachine Windows XP Professional Sp1 with Oracle 9i release 2 iget when i connect from the command prompt as sysdba the following message:

ORA-12540:TNS:internal limit restriction exceeded

On metalink i found a possible reason for this problem:

The previous SQL*Plus session terminated abnormally which left a shadow process which was not properly cleaned up. If more than 3 of these shadow processes have been left, the next SQL*Plus session gets an error and is not able to connect.

How can i see that shadow processes on NT? And what might be a solution? Received on Fri Feb 07 2003 - 11:11:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US