TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2317 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-36681: (XSDPART19) Partitions string and string are out of order.
ORA-01882: timezone region string not found
NNL-00935: Requests refused, SINGLE-VALUE violation: number
ORA-22167: given trim size [string] must be less than or equal to [string]
QSM-02179: MV with UNION ALL requires compatibility >= 9.2
NNL-00809: Queries received, multiple types: number
ORA-02446: CREATE TABLE ... AS SELECT failed - check constraint violated
QSM-00755: a set of workload statements already exists for workload string
ORA-25457: evaluation function string returns failure
NID-00401: Must finish REVERT changes before attempting any database operation.
ORA-19924: there are no row with id string
ORA-24434: OCIStmtRelease called before OCIStmtPrepare2.
Oracle Errors 
