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
- 2912 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-23489: duplicate entry "string"
ORA-01338: Other process is attached to LogMiner session
ORA-29853: keyword UNIQUE may not be used in creating domain indexes
ORA-30556: functional index is defined on the column to be modified
ORA-28663: Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW
EXP-00073: dump file size too small
ORA-24756: transaction does not exist
ORA-29530: could not create shortened name for string
ORA-12404: invalid privilege string: string
ORA-12322: unable to mount database (link name string)
KUP-04049: record number discarded from file string
ORA-09881: sstasfre/sstasdel: shmdt error, unable to detach tas read page
Oracle Errors 
