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

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

Received Response
30
Views
18
Comments
edited Apr 16, 2022 7:54AM in Autonomous Database 18 comments

Summary

Not able to access Free ATP services after upgrade to 19c....

Content

Hi All,

I've been trying to access my free autonomous database after upgrade to 19c, however, "ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege" error is giving me when trying to connect with a user distinct to ADMIN .

Querying v$instance I see this:

SQL> select logins from v$instance;

LOGINS
----------
RESTRICTED

However, not able to change this connected with ADMIN user , e.g "alter system disable restricted session; " (not enough privileges..)

Does anybody can help?

Thanks a lot.

Version

19c

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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