INSTALLATION DOCUMENTS BY RAVI

Wednesday, July 25, 2018

ORA-01031 INSUFFICIENT PRIVILEGES

When trying to connect to the database as sys from command prompt getting the below error







The issue is due to the password file got corrupted
Creating a new password file will resolve the issue
Back up the password file under ORACLE_HOME/database (PWDorcl.ora)









Create new password file with the command below:

Note: set the ORACLE_HOME, ORACLE_SID and PATH variables 
before running the below command



Try to connect again







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...