Create Password file for database in ASM Diskgroup - Oracle 12c RAC only

-- Verify Password file exists or not

$ crsctl stat res ora.HCMPRD.db -f | grep PWFILE
PWFILE=

-- Create password file in asm

orapwd file='+DATA/HCMPRD/orapwHCMPRD' dbuniquename='HCMPRD'

-- Now verify password file created or not

$ crsctl stat res ora.HCMPRD.db -f | grep PWFILE
PWFILE=+DATA/HCMPRD/orapwHCMPRD

-- you can see also in ASM_CLIENT

ASMCMD [+DATA/HCMPRD/PASSWORD] > ls
pwdHCMPRD.4594.1016696757
pwdHCMPRD.493.1016696613

-- you can find from asm diskgroup

$ asmcmd
ASMCMD> pwget --dbuniquename HCMPRD
+DATA/HCMPRD/orapwHCMPRD
ASMCMD>


-- Alternative method to create password file 12c asm

This method is valid only for oracle 12c onwards.

SYNTAX –
ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path}  {sys_password}

Example:

Here we will create a password file with dbuniquename HCMPRD.

ASMCMD> pwcreate --dbuniquename HCMPRD +DATA/PWDFILE/pwdHCMPRD oracle


-- You can check using srvctl also:

$ srvctl config database -d HCMPRD
Database unique name: HCMPRD
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DATA/HCMPRD/PARAMETERFILE/spfile.2557.2026287697
Password file: +DATA/HCMPRD/orapwHCMPRD
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: HCMPRD1,HCMPRD2
Configured nodes: example1a,example1b
Database is administrator managed
$