Oracle ORAPWD Password File Utility

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version to Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Password File Utility

The syntax elements SYSBACKUP, SYSDG, and SYSKM are new as of version
Operating System Privileges To access orapwd a user must have operating system level access to the ORACLE_HOME file system.
This is not the utility's full syntax. Note the following entries that show the missing pieces C:\Users\oracle>orapwd -h
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n>
       asm=<y/n> dbuniquename=<dbname> format=<legacy/12> sysbackup=<y/n>
       sysdg=<y/n> delete=<y/n> input_file=<input-fname>

Usage: orapwd describe file=<fname>

    file - name of password file (required),
    password - password for SYS will be prompted
               if not specified at command line.
               Ignored, if input_file is specified,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    asm - indicates that the password to be stored in
          Automatic Storage Management (ASM) disk group
          is an ASM password. (optional).
    dbuniquename - unique database name used to identify database
                   password files residing in ASM diskgroup only.
                   Ignored when asm option is specified (optional),
    format - use format=12 for new 12c features like SYSBACKUP, SYSDG and
             SYSKM support, longer identifiers, etc.
             If not specified, format=12 is default (optional),
    delete - drops a password file. Must specify 'asm',
             'dbuniquename' or 'file'. If 'file' is specified,
             the file must be located on an ASM diskgroup (optional)
    sysbackup - create SYSBACKUP entry (optional and requires the
                12 format). Ignored, if input_file is specified,
    sysdg - create SYSDG entry (optional and requires the 12 format).
            Ignored, if input_file is specified,
    syskm - create SYSKM entry (optional and requires the 12 format),
            Ignored, if input_file is specified,
    input_file - name of input password file, from where old user
                 entries will be migrated (optional),
    describe - describes the properties of specified password file

There must be no spaces around the equal-to ('=') character.
Retrieve password file metadata SELECT *
FROM v$pwfile_users;
Retrieve dbuniquename value SQL> show parameter unique
Create a password file orapwd file=c:\app\oracle\product\12.1.0\dbhome_1\database\PWDorabase.ora password="N0Access!" entries=3
Drop a password file with ASM TBD
Drop a password file with a file system orapwd delete=y password="N0Access!" dbuniquename=orabase

orapwd delete=y file=c:\app\oracle\product\12.1.0\dbhome_1\bin\PWDorabase.ora

This appears to still be valid syntax but no longer disables logins with "/ as sysdba"
nosysdba=<y | n>
orapwd file=c:\app\oracle\product\12.1.0\dbhome_1\database\PWDorabase.ora password="N0Access!" entries=3 ignorecase=n nosysdba=y force=y
DESCRIBE C:\Users\oracle>orapwd describe file=c:\app\oracle\product\12.1.0\dbhome_1\database\PWDorabase.ora

Password file Description : format=12 ignorecase=N
IGNORECASE This extension is deprecated as of 12cR1 as the default is "no" which means case is not ignored.

Related Topics
Data Guard

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved