TNS-12527: TNS:listener: all instances are in restricted
mode or blocking new connections



TNS-12527: TNS:listener: all instances are in restricted mode or blocking new connections..

Answer / guest

Cause: All appropriate database instances supporting the
service requested by the client reported that they either
were in restricted mode or were blocking the new
connections. The Listener does not allow connections to such
instances. This condition may be temporary, such as at
instance startup.

Action: Attempt the connection again. If error persists,
then contact the database administrator to check the status
of the instances.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27464: invalid schedule type string

1 Answers  


ORA-12334: database (link name string) is still open

1 Answers  


ORA-02819: Write failed

1 Answers  


ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers  


ORA-01104: number of controlfiles (string) does not equal string

1 Answers  






ORA-19030: Method invalid for non-schema based XML Documents.

1 Answers  


NZE-28783: invalid parameter

1 Answers  


TNS-04049: Specified connections do not exist

1 Answers  


ORA-06115: NETTCP: unable to create ORACLE logicals

1 Answers  


ORA-22275: invalid LOB locator specified

1 Answers  


NID-00106: LOGIN to target database failed with Oracle error: string

1 Answers  


ORA-31003: Parent string already contains child entry string

1 Answers  


Categories