Oracle DBA, How To, Error, Cause and Action

ORA-01035: ORACLE only available to users with RESTRICTED SESSIONprivilege

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




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




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