Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE



TNS-12522: TNS:listener could not find available instance with given INSTANCE_ROLE..

Answer / guest

Cause: There are not any available and appropriate database
instances registered with the listener, that are part of the
service identified by SERVICE_NAME given in the connect
descriptor and that have the specified INSTANCE_ROLE (and
INSTANCE_NAME, if specified).

Action: Check to make sure that the INSTANCE_ROLE specified
is correct. Run "lsnrctl services" to ensure that the
instance(s) have registered with the listener and that they
are ready to accept connections.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16175: cannot shut down database when media recovery is active

1 Answers  


ORA-07273: sppst: invalid semaphore id.

1 Answers  


DRG-50903: invalid weight string

1 Answers  


RMAN-12008: could not locate backup piece string

1 Answers  


ORA-22629: OCIAnyData is null

1 Answers  






NNL-00913: Server-generated requests sent: number

1 Answers  


ORA-13627: Setting of parameter string is disallowed until the task is reset.

1 Answers  


ORA-15016: invalid ASM_DISKGROUPS initialization parameter "string"

1 Answers  


LRM-00122: value 'string' for 'string' must be between 'number' and 'number'

1 Answers  


ORA-27049: unable to seek to and read the last block

1 Answers  


ORA-16600: Failover operation can only be submitted at target database.

1 Answers  


NZE-28773: failure to write magic and version numbers

1 Answers  






Categories