ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE



ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE..

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-08024: channel string: restore complete

1 Answers  


NNL-00206: No reload check currently scheduled

1 Answers  


KUP-04038: internal error: string

1 Answers  


RMAN-06008: connected to recovery catalog database

1 Answers  


ORA-00222: operation would reuse name of a currently mounted controlfile

1 Answers  






TNS-00512: Address already in use

1 Answers  


ORA-19752: block change tracking is already enabled

1 Answers  


PROT-00016: Internal Error

1 Answers  


ORA-02795: Request list is empty

1 Answers  


ORA-19204: Non-scalar value 'string' is marked as XML attribute

1 Answers  


ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


NZE-28856: Buffer overflow error

1 Answers  


Categories