Re: Question on password file
Date: Fri, 17 Jul 2009 12:04:14 -0500
You need just the one. The sysdba list and sys password should be the same in all Instances (in rac, you have to log in to each instance and alter user sys to achieve that).
"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 12:02 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
> 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.
> Thank you
> - Kumar
> 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