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
- 2889 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-01042: Data streams answered by server: number
ORA-14030: non-existent partitioning column in CREATE TABLE statement
ORA-30438: unable to access named pipe 'string'
RMAN-08117: channel string: the autobackup does not contain an SPFILE
ORA-01104: number of controlfiles (string) does not equal string
ORA-12436: no policy options specified
RMAN-08130: failover to copy on device type string
ORA-04028: cannot generate diana for object stringstringstringstringstring
QSM-02121: set operator in a context not supported for fast refresh
ORA-19561: %s requires a DISK channel
ORA-30081: invalid data type for datetime/interval arithmetic
ORA-38722: ON or OFF expected.
Oracle Errors 
