Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    BHOPAL - INDIA
    Posts
    1

    Unhappy Unanswered: ORA-12540:TNS:internal limit restriction exceeded

    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.

    I want my 450 users to get connected to my database server

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    do you want all your 450 users to connect as sysdba?

    when creating a database instance there most the times the number of dbas is restricted to some number of 3 to five (orapwd located $ORACLE_HOME/dbs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •