How to fix the Oracle error TNS-12526: TNS:listener: all appropriate instances are in restricted mode?

In this post, you’ll learn more about the Oracle ErrorTNS-12526: TNS:listener: all appropriate instances are in restricted mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error TNS-12526: TNS:listener: all appropriate instances are in restricted mode

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.

How to fix the Error TNS-12526: TNS:listener: all appropriate instances are in restricted mode ?

You can fix this error in Oracle by following the below steps

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