INSTALLATION DOCUMENTS BY RAVI

Friday, January 17, 2020

Status : Failure -Test failed: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege


Status: Failure -Test failed: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege


Check the LOGINS status with the below SQL command.





















Connect to the database as an SYS user through command prompt and execute the below commands











Grant restricted session privilege to the required user as below.






No comments:

Post a Comment

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...