ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

This is an error similar to ORA-12526, but it is returned when you attempt a local connection to the database with a user who doesn't hold the RESTRICTED SESSION privilege.

If you are a standard user, you should contact your DBA for more information.

See message translations for ORA-01035 and search additional resources

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

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

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