Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE
- 1 Answers
- 2971 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-00397: Type mismatch in arguments to IN
ORA-12839: cannot modify an object in parallel after modifying it
PLS-00306: wrong number or types of arguments in call to 'string'
IMG-00802: empty or null attribute string
RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows
DRG-11839: Internal Server Error
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-02030: can only select from fixed tables/views
NNL-00239: Resetting of statistic counters is now disabled
ORA-31012: Given XPATH expression not supported
ORA-16066: remote archival disabled
ORA-13510: invalid RETENTION string, must be in the range (string, string)
Oracle Errors 
