Questions on Sharing the password file in ASM
Hi, DBAs
I have many Oracle HOMEs and Clusterware, so the idea of sharing the password file and storing it in ASM sounded like a good idea when I started installing 12.1.
Right up until I realized that Clusterware will fail to start if the ASM password is lost (or accidentally deleted), and that having the password in ASM has added yet another step to setting up standby databases.
According to note How to Restore ASM Password File if Lost ( ORA-01017 ORA-15077 ) (Doc ID 1644005.1), the password file must be restored from a backup.
Questions:
1. In 12.1 and later, must the password file be stored in ASM, or can I go back to using orapwd to $ORACLE_HOME/dbs?