so i tried restarting weblogic server and restart failed with error ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege. i granted restricted session to the db user but still getting the same error.

1

1 Answer

Option 1:

i) Check with the Database Administrator and disable the restricted mode. Steps may vary according to the database.

alter system disable restricted session; ii) Verify that the login is allowed.

select logins from v$instance;

LOGINS

ALLOWED

iii) Restart the Database.

iv) Restart the AdminServer.

Option 2:

Contact the Database Administrator to grant RESTRICTED SESSION privileges for all the required DB users.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.