DB version : 11.2
Platform : AIX 6
I am going to create a Physical standby. My primary database's DB_NAME =
jedprod
From googling , I have learnt that from 11g onwards , instead of creating a separate password file at the standby site , you need to copy the password file from Primary to standby and RENAME it with the standby name ?
But, my Primary and standby database's
DB_NAME is going to be same. Right?
esentially this is what I got from googling.
--In Primary
cd $ORACLE_HOME/dbs
$ orapwd file=orapw<SID_PRIMARY> password=mypass entries=15 force=y
-- copy the password file to standby site and then
--In Standby
cd $ORACLE_HOME/dbs
$ orapwd file=orapw<SID_STANDBY> password=mypass entries=15 force=y # Is stanby DB's name going to be different ?
So, If my DB was standalone
--In Primary
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod password=mypass entries=15 force=y
-- copy the password file to standby site and then
--In Standby
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod password=mypass entries=15 force=y
and If my DB was in RAC
--In Primary Node1
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
--In Standby Node1
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod1 password=mypass entries=15 force=y
--In Primary Node2
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
--In Standby Node2
cd $ORACLE_HOME/dbs
$ orapwd file=orapwjedprod2 password=mypass entries=15 force=y
Are my above assumptions right?