Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-12522: TNS:listener could not find available instance
with given INSTANCE_ROLE



ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE..

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-06220: Creating automatic instance

1 Answers  


ORA-06401: NETCMN: invalid driver designator

1 Answers  


LPX-00316: invalid value ~S for ~S attribute ~S

1 Answers  


ORA-24315: illegal attribute type

1 Answers  


ORA-16719: unable to query V$ARCHIVE_DEST fixed view

1 Answers  






RMAN-06068: recovery aborted because of missing datafiles

1 Answers  


ORA-02089: COMMIT is not allowed in a subordinate session

1 Answers   Oracle,


ORA-36884: (XSSRF03) The value of the first parameter of the AW single row function is incorrect.

1 Answers  


ORA-02425: create table failed

1 Answers  


TNS-12633: No shared authentication services

1 Answers  


ORA-01137: data file string is still in the middle of going offline

1 Answers  


TNS-00232: Unable to setup connection

1 Answers  






Categories