Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

edited Mar 21, 2021 1:01PM in Autonomous Database 13 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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