TNS-12527: TNS:listener: all instances are in restricted
mode or blocking new connections
- 1 Answers
- 2466 Views
- I also Faced
- E-Mail Answers
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 |
ORA-14408: partitioned index contains subpartitions in a different tablespace
ORA-30756: cannot create column or table of type that contains a supertype attribute
ORA-32008: error while processing parameter update at instance string
ORA-32024: invalid directory specified for audit_file_dest parameter
ORA-26082: load of overlapping segments on table string.string is not allowed
NNL-00023: SET command is missing an argument
ORA-02067: transaction or savepoint rollback required
IMG-00577: invalid quantize argument
EXP-00027: failed to calculate ORACLE block size
ORA-07840: sllfop: LIB$GET_VM failure
NNL-00204: Cancelled shutdown
RMAN-06099: error occurred in source file: string, line: number
Oracle Errors 
