Re: Question on password file
Date: Fri, 17 Jul 2009 11:51:33 -0500
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?
"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_at_gmail.com> wrote:
> 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
> 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