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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...