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


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

ORA-26694: error while enqueueing into queue string.string

1 Answers  


PCC-02384: Missing array length specifier

1 Answers  


QSM-02084: DISTINCT clause on a duplicate sensitive aggregate function

1 Answers  


ORA-12085: materialized view log on "string"."string" already has object id

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  






ORA-31023: Index size error

1 Answers  


TNS-12658: ANO service required but TNS version is incompatible

1 Answers  


ORA-09984: SGA file $ORACLE_HOME/dbs/sgadef$ORACLE_SID.dbf does not exist

1 Answers  


ORA-38485: invalid object type for the user-defined function

1 Answers  


TNS-00302: Connection Manager: Unknown Request

1 Answers  


ORA-19736: can not plug a tablespace into a database using a different national character set

1 Answers  


TNS-00272: Navigator

1 Answers  






Categories