Day: July 29, 2021

How to Create Password File on ASM diskgroup

1) Make sure compatible.asm at least 12.1.

SQL> SELECT NAME,VALUE,GROUP_NUMBER FROM V$ASM_ATTRIBUTE where name like '%compatible%'

NAME                                     VALUE                                                                  GROUP_NUMBER
---------------------------------------- ---------------------------------------------------------------------- ------------
compatible.asm                           19.0.0.0.0                                                                        1
compatible.rdbms                         11.2.0.4                                                                          1
compatible.advm                          19.0.0.0                                                                          1
compatible.asm                           19.0.0.0.0                                                                        2
compatible.rdbms                         11.2.0.4.0                                                                        2
compatible.advm                          19.0.0.0.0                                                                        2

6 rows selected.

2) Create password by using ‘pwcreate’.

ASMCMD> pwcreate --dbuniquename TESTDB '+datac1/TESTDB/password/pwdtestdb'
Enter password: *********
ASMCMD>

3) Verify the password by :

$ crsctl stat res ora.testdb.db -f | grep PWFILE
PWFILE=+DATAC1/TESTDB/PASSWORD/pwdtestdb

For 11.2, there is no support for this feature.

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