Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Ora-12540 error when i connect as sysdba
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
![]() |
![]() |