Kumar, The password file on the standby would be the SID of the standby (I'm not sure if you are changing this or not). From the sounds of things, you'll have a single-instance (Non-RAC) standby? Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class job under your direction." -- William Feather On Fri, Jul 17, 2009 at 11:24 AM, Kumar Madduri <ksmadduri@xxxxxxxxx> wrote: > Hi > Environment:2 node rac; no spfile; > $ORACLE_HOME/dbs is shared between the two nodes (only dbs directory, not > the $ORACLE_HOME) > If i want to create a password file, should I create one password file for > both instances or two password files (one for each). > I want to use this password file to copy to standby server to set up > Dataguard. > > > I am thinking if I create it like this > cd $ORACLE_HOME/dbs > orapwd file=orapwSID1 password=abc force=y > orapwd file=orapwSID2 password=abc force=y > > it does not matter which one I copy but is it required to create two > password files in such a scenario or just one password file would suffice. > > > Thank you > - Kumar >