Starting weblogic results in ORA-01035: ORACLE only available to users with RESTRICTED SESSION privi

May 2024 ยท 1 minute read

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.

ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobW5oZ2eFd36OrKuaqqSeu6h51p6ZpaeXnrBuvsSsrKWso2K2r3nOq5hmaGFlgHZ5zquYnKSVYryvuNhmmK%2BZmaGuo7jEZquoZaWosrO%2FjLCgraBdp7K0wA%3D%3D