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:

Concurrent Processing - Product Information Center (PIC) (Doc ID 1304305.1)

 huge library of Oracle support documents to deep dive into Oracle concurrent managers. Concurrent Processing - Product Information Center (...