ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
Summary
Trying to access my ADW today but getting ORA-01035 when trying to connect as any user other than ADMINContent
Hi,
I hope you can help. When I try and log into my ADW as any user other than ADMIN, I'm getting the following error.
An error was encountered performing the requested operation:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege
01035. 00000 - "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
Tagged:
0