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|
ORA-16175: cannot shut down database when media recovery is active
ORA-07273: sppst: invalid semaphore id.
DRG-50903: invalid weight string
RMAN-12008: could not locate backup piece string
ORA-22629: OCIAnyData is null
NNL-00913: Server-generated requests sent: number
ORA-13627: Setting of parameter string is disallowed until the task is reset.
ORA-15016: invalid ASM_DISKGROUPS initialization parameter "string"
LRM-00122: value 'string' for 'string' must be between 'number' and 'number'
ORA-27049: unable to seek to and read the last block
ORA-16600: Failover operation can only be submitted at target database.
NZE-28773: failure to write magic and version numbers