TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2554 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 |
O2F-00314: AS expected but not seen in the INTYPE file
ORA-06127: NETTCP: unable to change username
ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications
ORA-02795: Request list is empty
ORA-02377: invalid resource limit
NNL-00291: Statistic counters are next reset in string
PCB-00702: Out-of-range item number
ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
ORA-31113: XDB configuration may not be updated with non-schema compliant data
ORA-29852: keyword IS is missing
ORA-19696: controlfile not found in backup set
ORA-01618: redo thread string is not enabled - cannot mount
Oracle Errors 
