totn Oracle Error Messages

Oracle / PLSQL: ORA-01035 Error Message

Learn the cause and how to resolve the ORA-01035 error message in Oracle.

Description

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

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

Cause

You tried to connect to Oracle, but logins are not allowed because the Oracle instance was started in restricted mode. Only users with RESTRICTED SESSION privileges can log in.

Resolution

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

Option #1

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

Option #2

Contact your DBA and ask for RESTRICTED SESSION privileges.