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-09818: Number is too large

1 Answers  


ORA-01370: Specified restart SCN is too old

1 Answers  


ORA-30181: integer in argument index is not immediately followed by )

1 Answers  


ORA-30927: Unable to complete execution due to failure in temporary table transformation

1 Answers  


ORA-01674: data file string is an old incarnation rather than current file

1 Answers  






ORA-01206: file is not part of this database - wrong database id

1 Answers  


NNO-00801: Error: OCI_SUCCESS_WITH_INFO: string

1 Answers  


ORA-07390: sftopn: translate error, unable to translate file name.

1 Answers  


ORA-16011: Archivelog Remote File Server process in Error state

1 Answers  


ORA-37078: (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.

1 Answers  


ORA-28010: cannot expire external or global accounts

1 Answers  


ORA-22865: more than one column specified

1 Answers  


Categories