This blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments.
Also to make this blog more useful, please give your comments and share your experience. Thanks

Friday, 25 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.

No comments:

About Me

I have more than 15 years of experience in IT. I am working being Senior Database Administrator / APPS DBA for an IT consultng company in New Zealand. I am Oracle Certified Professional DBA in Oracle 7.3, 8.0, 8i, 9i and 10g. I have worked on Oracle 10g RAC, Oracle Replication and Oracle Data Guard technologies.