Oracle ORAPWD Password File Utility

General Information
Library Note Morgan's Library Page Header
"We don't live in a dictatorship or a monarchy. I swore an oath in the military and in the Senate to preserve, protect and defend the Constitution of the United States, not to mindlessly cater to the whims of Cadet Bone Spurs and clap when he demands I clap,"
~ Sen. Tammy Duckworth
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="N0WayIn!" 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="N0WayIn!" 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
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved