Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2935 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-06549: PL/SQL: failed to dynamically open shared object (DLL): string
NNC-00429: invalid octet string literal "string"
ORA-19013: Cannot create VARRAY columns containing XMLType
ORA-00299: must use file-level media recovery on data file string
RMAN-02006: script line too long
RMAN-06042: PLUS ARCHIVELOG option is not supported with non-datafile backups
ORA-06123: NETTCP: cannot set KEEPALIVE
ORA-38462: invalid attribute list
KUP-11008: conversion error loading table string.string partition string
NNL-00563: timed_query [<timestamp>] : query all objects in the Names server's cache
ORA-14521: Default tablespace string block size [string] for string string does not match existing string block size [string]
ORA-37030: (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
Oracle Errors 
