ORA-12526: TNS:listener: all appropriate instances are in restricted mode
You are trying to connect to a database that has been started in restricted mode.
When a database is put in restricted mode for maintenance operations only users with the RESTRICTED SESSION privilege can connect to it (SYSDBAs and SYSOPERs) and only by using a local database connection.
In other words, any attempt to connect even as SYSDBA or SYSOPER through the listener will result in an ORA-12526 error.
Local database connections are those opened from a terminal running on the same server where the database is located and without specifying a database connection, for instance:
sqlplus "sys/pwd as sysdba"If you specify a database connection as in:
sqlplus "sys/pwd@orcl as sysdba"you'll get ORA-12526 in all cases.
A database in restricted mode can be put into normal (non-restricted) mode by issuing the following command:
ALTER SYSTEM DISABLE RESTRICTED SESSION;
See message translations for ORA-12526 and search additional resources