Skip to content

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

  • by

ORA-12526

When we tried to connect to the database, it failed with ORA-12526 like the following.

SQL> conn hr/hr@orcl
ERROR:
ORA-12526: TNS:listener: all appropriate instances are in restricted mode

ORA-12526 means that the database is in a very special mode which restrict all external connections except SYS from accessing the database. It's called restricted mode.

Solution

For users privileged with RESTRICTED SESSION like SYS or SYSTEM who want to remotely connect to the database in restricted mode, you should configure a static service in listener by adding a SID_LIST_LISTENER entry for them.

The way we solve ORA-12526 is just like we did in how to connect a restricted database.

Leave a Reply

Your email address will not be published. Required fields are marked *