ORA-12527: TNS:listener: all instances are in restricted
mode or blocking new connections
- 1 Answers
- 2902 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 ? | 1 Yes | 0 No |
ORA-15101: no action specified
TNS-01114: LSNRCTL could not perform local OS authentication with the listener
ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier
ORA-16614: object has an ancestor that is disabled
ORA-04086: trigger description too long, move comments into triggering code
LPX-00235: invalid XML version, must be 1.0 or 2.0
UDE-00005: unexpected End-Of-File encountered while reading input
LPX-00237: invalid condition section keyword, must be INCLUDE or IGNORE
ORA-16412: ONDEMAND archival requires active SQL apply operation
ORA-28584: heterogeneous apply internal error
NNO-00317: statistic counter reset interval changed to number seconds
AUD-00802: name of index is limited to 22 characters
Oracle Errors 
