Re: Question on password file
Date: Fri, 17 Jul 2009 10:02:55 -0700
Yes you are right. The password file on the standby would be the SID of the standby. So my intent is to generate password file on primary and copy it to standby
cp orapwSID1.ora orapwSTBYSID.ora
But question is should I require 2 or 1 password files. and it is going to be a single instance (non-rac) standby.
On Fri, Jul 17, 2009 at 9:51 AM, Bradd Piontek <piontekdd_at_gmail.com> wrote:
> 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
> -- 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