TNS-12523: TNS:listener could not find instance appropriate
for the client connection



TNS-12523: TNS:listener could not find instance appropriate for the client connection..

Answer / guest

Cause: The listener could not find any available (database)
instances, that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the
instance(s) are registered with the listener, and have
status READY.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-15030: diskgroup name "string" is in use by another diskgroup

1 Answers  


PLS-00513: PL/SQL function called from SQL must return value of legal SQL type

1 Answers  


TNS-00518: Incomplete read or write

1 Answers  


NNO-00252: invalid administrative region parameter string value "string"

1 Answers  


ORA-25303: Buffered operation allowed only on the owner instance

1 Answers  


NNC-00421: invalid modification directive string, must be between string and string

1 Answers  


ORA-12731: invalid collation class in regular expression

1 Answers  


ORA-29378: invalid consumer group mapping priorities

1 Answers  


NNO-00330: server saved the config file "string".

1 Answers  


ORA-12484: invalid OS label

1 Answers  


ORA-01562: failed to extend rollback segment number string

1 Answers  


ORA-27460: cannot execute disabled job "string.string"

1 Answers  


Categories