-
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
-
the listener doesnt know about the database you are trying to connect to
-
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
-
well, the listener isnt listening for the database you are connecting to, simple as that
-
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"
-
Someone's not listening...
Reject negationism
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|