ORA-12526: TNS:listener: all appropriate instances are in
restricted mode



ORA-12526: TNS:listener: all appropriate instances are in restricted mode..

Answer / guest

Cause: Database instances supporting the service requested
by the client were in restricted mode. The Listener does not
allow connections to instances in restricted mode. This
condition may be temporary, such as during periods when
database administration is performed.

Action: Attempt the connection again. If error persists,
then contact the database administrator to change the mode
of the instance, if appropriate.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12590: TNS:no I/O buffer

1 Answers  


ORA-16550: truncated result

1 Answers  


ORA-00051: timeout occurred while waiting for a resource

1 Answers  


TNS-00530: Protocol adapter error

1 Answers  


EXP-00080: Data in table "string" is protected. Using conventional mode.

1 Answers  






NNL-00801: Queries received, type ANY: number

1 Answers  


SQL*Loader-00925: Error while string

1 Answers  


ORA-01176: data dictionary has more than the string files allowed by the controlfie

1 Answers  


ORA-33265: (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.

1 Answers  


NNO-00321: statistic counter dump disabled

1 Answers  


ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  


ORA-03222: average row size and row count must be greater than zero

1 Answers  


Categories