Prior to Oracle Database 12c, the password file was always located under $ORACLE_HOME/dbs file structure, even for RAC instances and for RAC ASM cluster. For RAC the DBA organisation had to managed to keep the password file in sync on each node. See for a solution in an earlier blog on my site "Password file maintenance on Clustered ASM and RAC databases 11gR2 and before" Oracle 12cNow in Oracle 12c, it is possible to store the password file on ASM. Wonderfule this means a shared password file for Oracle RAC databases , it is shared for all instances in the cluster. ORAPWD UtilityThe command utility to create the passowrd file is still the same. “orapwd” Oracle 11gR2 and before;Usage: orapwd file= entries= force= ignorecase= nosysdba= where:
There must be no spaces around the equal-to (=) character.Oracle 12c and after;Usage: orapwd file= entries= force= asm= dbuniquename= format= sysbackup= sysdg= syskm= delete= input_file=Usage: orapwd describe file= where:
There must be no spaces around the equal-to (=) character. For more information read Creating a Database Password File with ORAPWD The original post is on Joords Oracle DBA blog
© copyright, 2011.
Thorough knowledge of Oracle RDBMS technology, pragmatically Oracle database administrator.
(OCM 11g, OCP8 ,OCP8i,OCP9i,OCP10g,OCP11g, RAC Expert 10g and OCP12g)