Wednesday, January 14, 2009

How to create password file when it is not present ?

Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores The passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect.

Follow this procedure to create a new password file:

*  Log in as the Oracle software owner

*  Run command: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypasswd

*  Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE)

*  Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set.

*  Startup the database (SQLPLUS> STARTUP)[/list]

NOTE: The orapwd utility presents a security risk in that it receives a password from the command line. This password is visible in the process table of many systems. Administrators needs to be aware of this!

Adding users to Password File:

One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility


No comments:

Post a Comment


About Me

My photo
N.Delhi, Delhi, India
I am an Oracle Certified Professional, Oracle 9i/10G DBA, having 4+ years of core DBA experience.