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:

manage long running sessions with "screen" on linux OS - handy utility for Oracle APPS DBA for cloning, patching etc

  n Oracle E-Business Suite (EBS), there is no standard   -S   flag for the primary cloning commands ( adpreclone.pl   or   adcfgclone.pl )....