Monday , September 25 2017
Home / Oracle DBA / ORACLE PASSWORD FILE (PFILE)

ORACLE PASSWORD FILE (PFILE)

ORACLE PASSWORD FILE (PFILE)

  1. This file contain sysdba password and will be used if any user with sysdba permission is trying to connect database remotely.
  2. It will be in the form of orapw<SID> and resides in ORACLE_HOME/dbs (on unix) and ORACLE_HOME/database. (on windows)
  3. If we forgot password of sys user or lost password file, it can be recreated using ORAPWD utility as follows.
$ ORAPWD file=orapwtest password=oracle entries=5 force=y (here TEST is SID)
Entires represents those many users can use this password file
Force=y will allow DBA to overwrite password file
  1. To make password file affective, define REMOTE_LOGIN_PASSWORD=EXCLUSIVE.
Read More:
SOX compliance database
ORACLE AUDITING
PROFILE MANAGEMENT

Comments

comments

Check Also

How to switch on primary database to physical standby database

After configuration data guard then data is switching  into primary database  to standby database : …

Leave a Reply

Your email address will not be published. Required fields are marked *