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



ORA-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 ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LFI-01000: Unable to write line to file.

1 Answers  


ORA-23502: valid directory for offline instatiation is not specified

1 Answers  


ORA-30373: object data types are not supported in this context

1 Answers  


PLS-00437: FORALL bulk index cannot be used in string clause

1 Answers  


ORA-24300: bad value for mode

1 Answers  






KUP-04068: internal error fetching attribute string

1 Answers  


SQL*Loader-00129: Invalid number of rows for direct path column array

1 Answers  


ORA-16783: instance string not open for read and write access

1 Answers  


ORA-27473: argument string does not exist

1 Answers  


ORA-01184: logfile group string already exists

1 Answers  


DRG-12223: section name string is a reserved name

1 Answers  


ORA-37080: Advice requested for hierarchy with too many levels

1 Answers  


Categories