Search This Blog

Saturday, 26 February 2011

login with sysdba ORA-01031: insufficient privileges

Introduction: If you try to connect with sysdba from client machine, it might give you the following error ORA-01031: insufficient privileges Cookbook: You need to create the password for in $ORACLE_HOME/dbs location, and following is an example to create the password file. $ orapwd file=$ORACLE_HOME/dbs/orapwSID password=type_password entries once you run this command on the Oracle Server, then again try to login from the client with sysdba, it will work.

No comments:

Oracle EBS Cloud manager deployment on OCI

 Please follow the Oracle support document. Deploying Oracle E-Business Suite Cloud Manager Version 20.1.1.X on Oracle Cloud Infrastructure ...