Wednesday, July 24, 2013

ORACLE - orapw (password file)

How to create password file for Oracle database ?

SHUTDOWN IMMEDIATE

$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapw<SID> password=<password> force=y ignorecase=n entries=5

Add in the pfile or spfile follwoing parameter:
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

STARTUP

SQL> select * from v$pwfile_users;
USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE

Note:
You must re-start the database to acces re-created password file.
The password MUST be the password for sys.

No comments:

Post a Comment