TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 3107 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-22313: cannot use two versions of the same type "string"
ORA-09932: Close of ORACLE password file failed.
RMAN-08591: WARNING: invalid archivelog deletion policy
ORA-27191: sbtinfo2 returned error
ORA-24002: QUEUE_TABLE string does not exist
IMP-00066: Missing NLS_CHARACTERSET in props$
ORA-22913: must specify table name for nested table column or attribute
RMAN-06511: RMAN retention policy is set to redundancy number
ORA-27474: cannot give both an argument name and an argument position
DRG-50949: too many SQEs
SQL*Loader-00563: bad length for VAR record
NNL-00811: Fastest query processing time: string
Oracle Errors 
