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 19c - patch 19.22 unavailability for Windows platform

 Oracle 19c - patch 19.22 unavailability for Windows platform  Having upgraded the Oracle 11g 11.2.0.4 database to Oracle 19c 19.3.0.0.0 whi...