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
- 2959 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 |
TNS-12156: TNS:tried to reset line from incorrect state
DRG-10836: field section and attribute section can not be nested
QSM-02117: missing GROUPING_ID or GROUPING functions on GROUP BY column(s)
ORA-23458: inappropriate flavor string at string
LPX-00605: Invalid attribute '~1S' in element '~2S'.
PCC-02413: Number of attributes does not match number of host variables
AUD-00807: SpeechContains: index of indextype ORDSpeechIndex is required
ORA-38443: An attribute set should be assigned to the expression set for statistics collection.
ORA-07211: slgcs: gettimeofday error, unable to get wall clock.
ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string
ORA-02300: invalid value for OIDGENERATORS
ORA-14274: partitions being merged are not adjacent
Oracle Errors 
