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
- 3047 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-19619: cannot call restoreValidate after files have been named
ORA-00750: database has been previously mounted and dismounted
ORA-02782: Both read and write functions were not specified
ORA-30051: VERSIONS clause not allowed here
ORA-22903: MULTISET expression not allowed
PCC-00091: TYPE statement requires format specification for this Oracle datatype
ORA-06117: NETTCP: unable to create ORASRV: quota exceeded
ORA-14458: attempt was made to create a temporary table with INDEX organization
ORA-19550: cannot use backup/restore functions while using dispatcher
ORA-31471: invalid OBJECT_ID value
TNS-00126: Missing Connection Manager name and address in TNSNET.ORA
TNS-02022: show rules: Show rules that are currently in effect
Oracle Errors 
