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-29703: error occurred in global enqueue service operation

1 Answers  


NNC-00005: cannot initialization stream subsystem

1 Answers  


ORA-01025: UPI parameter out of range

1 Answers   TCS,


ORA-26518: push queue synchronization error detected

1 Answers  


ORA-22858: invalid alteration of datatype

1 Answers  






ORA-01483: invalid length for DATE or NUMBER bind variable

1 Answers  


NNL-00957: Name nodes created: number

1 Answers  


ORA-27301: OS failure message: string

1 Answers  


ORA-34481: (MXMAINT07) You cannot string values of PARTITION TEMPLATE workspace object.

1 Answers  


LFI-01520: close() failed(OSD return value = string) in string.

1 Answers  


DRG-50303: error in bufout

1 Answers  


ORA-00348: single-process redo failure. Must abort instance

1 Answers  


Categories