ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2562 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 |
NNL-01077: Save Config on Stop string
ORA-31416: invalid SOURCE_COLMAP value
PCC-02406: Expecting the form 'RETURN[ING] REF INTO :<ref>' only
ORA-38473: cannot drop a type used for Expression Filter attribute set
ORA-15112: No diskgroups are currently mounted.
NZE-28750: unknown error
ORA-12451: label not designated as USER or DATA
PCC-02040: CMD-LINE: Option selected, but no value provided
ORA-21605: property [string] is not a property of value instances
PCB-00231: Host and indicator variables may not have the same name.
ORA-02363: error reading from file: string
ORA-09769: osnmbr: cannot send break message
Oracle Errors 
