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
- 2995 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 |
PLS-00587: a static method cannot be invoked on an instance value
ORA-12632: Role fetch failed
ORA-00360: not a logfile member: string
ORA-19653: cannot switch to older file incarnation
ORA-16225: Missing LogMiner session name for Streams
ORA-29306: datafile string is not online
PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands
ORA-23373: object group "string"."string" does not exist
PLS-00327: "string" is not in SQL scope here
ORA-37016: (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
ORA-30463: 'string' is not a detail table of any summary
ORA-06927: CMX: T_DATAIN received before all data written
Oracle Errors 
