Interested to Buy Any Domain ? << Click Here >> for more details...
TNS-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2991 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 |
PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE
ORA-28673: Merge operation not allowed on an index-organized table
ORA-25229: error on transformation of message string string
NID-00301: Datafile string - dbid changed, wrote new name
LFI-00108: Open expect the file [string][string] to exist.
ORA-24390: Unsupported scrollable cursor operation
PCC-00147: DBMS=V6 no longer supported; using DBMS=NATIVE
ORA-06910: CMX: Cannot start oracle process on remote machine
ORA-16808: unable to resolve the full path name
ORA-29363: plan directive string, string is mandatory and cannot be modified or deleted
QSM-01081: no primary key or row id found for table, string, in MV, string
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Oracle Errors 
