How to resolve ORA-01035 Error Message in Oracle database

Learn the purpose and how to unravel the ORA-01035 error message in Oracle.


When you encounter an ORA-01035 error, the following error message will appear:

ORA-01035: Oracle solely available to customers with RESTRICTED SESSION privilege


You tried to connect to Oracle, however logins are not allowed due to the fact the Oracle instance was once started in limited mode. Only users with RESTRICTED SESSION privileges can log in.


The option(s) to resolve this Oracle error are:

Option #1

Contact your DBA and have the Oracle instance restarted except the restriction.

Option #2

Contact your DBA and ask for RESTRICTED SESSION privileges.