DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL*Plus Error

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    SQL*Plus Error

    SQL> connect sys/gateway@ncl.nctex.com as sysdba
    ERROR:
    ORA-12523: TNS:listener could not find instance appropriate for the client connection

    Listener is up and running
    OracleServer is running
    Tnsnames have configured with appropriate services

    Can anybody help me in this regard
    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the listener doesnt know about the database you are trying to connect to

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by davey23uk
    the listener doesnt know about the database you are trying to connect to
    No change has been made, before sometime it was working fine
    and listener is configured to listen for the database to which we are trying to connect

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well, the listener isnt listening for the database you are connecting to, simple as that

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    In Other Words:

    The database you are connecting is not registered with the listener. Means, when you type lsnrctl services the instance you are connecting should show the status as READY.

    Code:
    Instance "prod", status READY, has 1 handler(s) for this service...
        Handler(s):
          "DEDICATED" established:9906 refused:0 state:ready
             LOCAL SERVER
    The command completed successfully
    Are you getting this?

    "What is past is PROLOGUE"

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Someone's not listening...

    Reject negationism
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

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


Click Here to Expand Forum to Full Width