Oracle ORAPWD Password File Utility
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. 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 to version 12.1.0.1.
Operating System Privileges To access orapwd a user must have operating system level access to the ORACLE_HOME file system.
 
Help
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>

  where
    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
               (required).

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
Create a password file orapwd file=c:\app\oracle\product\12.1.0\dbhome_2\database\pwdorabase2.ora password="N0Access!" entries=3
 
DELETE
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_2\bin\pwdorabase.ora
 
AUDIT VAULT and DATA VAULT Extension
NOSYSDBA

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_2\database\pwdorabase2.ora password="N0Access!" entries=3 ignorecase=n nosysdba=y force=y
 
Addendum
DESCRIBE C:\Users\oracle>orapwd describe file=c:\app\oracle\product\12.1.0\dbhome_2\database\pwdorabase2.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
Security
Utilities

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