RE: changing password of user with sysdba/sysoper in RAC environment

  • From: "Matthew Zito" <mzito@xxxxxxxxxxx>
  • To: <piontekdd@xxxxxxxxx>, <TESTAJ3@xxxxxxxxxxxxxx>
  • Date: Wed, 25 Mar 2009 14:59:55 -0400

You can make a symlink from the dbs directory to a shared device or
mountpoint.  Definitely don't share your homes.

 

Matt

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bradd Piontek
Sent: Wednesday, March 25, 2009 2:34 PM
To: TESTAJ3@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: changing password of user with sysdba/sysoper in RAC
environment

 

having it on shared disk would require the oracle_home to be shared, I
think. At least in 10g, I didn't think you could have a password file
that was not in $ORACLE_HOME/dbs (this could be platform dependent).

 

I've always changed it once, and copied the password file to the other
nodes.

 

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 Wed, Mar 25, 2009 at 1:31 PM, <TESTAJ3@xxxxxxxxxxxxxx> wrote:


So you RAC people out there, whats the practice you're using? 

Single password file on shared disk? 

Change the password on each node with separate password files on each
OH/dbs directory? 

Any other options? 

thanks, joe 

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Consultant
Data Engineering and Administration
Nationwide Investments

(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

 

Other related posts: