SQL> connect firstname.lastname@example.org as sysdba
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
No change has been made, before sometime it was working fine
Originally Posted by davey23uk
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.
Are you getting this?
Instance "prod", status READY, has 1 handler(s) for this service...
"DEDICATED" established:9906 refused:0 state:ready
The command completed successfully
"What is past is PROLOGUE"
Someone's not listening...
Click Here to Expand Forum to Full Width