ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2275 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 |
ORA-01217: logfile member belongs to a different logfile group
ORA-02805: Unable to set handler for SIGTPA
ORA-37070: You may not execute OLAP DML programs in a parallel query session.
NZE-28861: SSL connection would block
PCC-02426: Incompatible LOB types
ORA-22907: invalid CAST to a type that is not a nested table or VARRAY
RMAN-00572: waiting for dbms_pipe input
ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
TNS-12634: Memory allocation failed
DRG-50935: parser component failure
ORA-23329: successful user-provided ddl but no materialized view "string"."string"
ORA-31122: The string operator has incorrect RHS value
Oracle Errors 
