TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2308 Views
- I also Faced
- E-Mail Answers
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 |
NZE-28833: inadequate information provided
ORA-16780: Destination to some database has used up its quota.
ORA-19696: controlfile not found in backup set
ORA-00166: remote/local nesting level is too deep
O2I-00124: Error opening the INITFILE file for writing
PLS-00627: 'string' must be a strongly typed ref cursor
RMAN-04014: startup failed: string
RMAN-08161: contents of Memory Script:
DRG-11501: identifier string found in place of column name on line string
ORA-16621: Database name for ADD DATABASE must be unique.
ORA-29856: error occurred in the execution of ODCIINDEXDROP routine
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
Oracle Errors 
