TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2333 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 |
TNS-02519: no appropriate key-negotiation parameters
ORA-31439: subscription is already active
ORA-39098: Worker process received data objects while loading metadata. Invalid process order range is string..string
ORA-32815: message system link string is referenced by a foreign queue
ORA-36908: (XSAGDNGL46) In AGGMAP workspace object, MODEL workspace object has the repeating dimension with the previous model.
TNS-00273: Navigator: Logging is now ON
ORA-36804: (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC
PCC-02338: structure contains a nested struct or union
ORA-22922: nonexistent LOB value
DRG-10100: invalid argument found: string
ORA-13601 encountered when generating server alert SMG-3503
Oracle Errors 
