Re: Question on password file

  • From: Bradd Piontek <piontekdd@xxxxxxxxx>
  • To: ksmadduri@xxxxxxxxx
  • 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?


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
>

Other related posts: