Re: Question on password file

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 17 Jul 2009 11:51:33 -0500
Message-ID: <e9569ef30907170951oac98e09i2d77ab4321528d7_at_mail.gmail.com>



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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 17 2009 - 11:51:33 CDT

Original text of this message