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
- 2975 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-39700: database must be opened with UPGRADE option
TNS-00519: Operating system resource quota exceeded
LPX-00655: Invalid output comment '~S'.
CLSR-00525: prsr initialization failed
ORA-12540: TNS:internal limit restriction exceeded
ORA-25140: %s space policy cannot be specified for the string extent management
ORA-07455: estimated execution time (string secs), exceeds limit (string secs)
ORA-14117: partition resides in offlined tablespace
ORA-15003: diskgroup "string" already mounted in another lock name space
ORA-21707: pin duration is longer than allocation duration
TNS-12641: Authentication service failed to initialize
ORA-02829: No segment of the proper size is available
Oracle Errors 
