Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
3
Views
9
Comments
edited Mar 21, 2021 1:01PM in Autonomous Database 9 comments

Summary

Trying to access my ADW today but getting ORA-01035 when trying to connect as any user other than ADMIN

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!