Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SID name and password file

greenyMar 20 2012 — edited Mar 20 2012
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?
This post has been answered by Shivananda Rao on Mar 20 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2012
Added on Mar 20 2012
5 comments
3,601 views