How to fix the Oracle error ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege?

In this post, you’ll learn more about the Oracle ErrorORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

Logins are disallowed because an instance started in restricted mode. Only users with RESTRICTED SESSION system privilege can log on.

How to fix the Error ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege ?

You can fix this error in Oracle by following the below steps

Request that Oracle be restarted without the restricted option or obtain the RESTRICTED SESSION system privilege.