RE: changing password of user with sysdba/sysoper in RAC environment
- From: "Sais, Gene" <Gsais@xxxxxxxxxxxxxxxxxxxx>
- To: "'mzito@xxxxxxxxxxx'" <mzito@xxxxxxxxxxx>, "'piontekdd@xxxxxxxxx'" <piontekdd@xxxxxxxxx>, "'TESTAJ3@xxxxxxxxxxxxxx'" <TESTAJ3@xxxxxxxxxxxxxx>
- Date: Wed, 25 Mar 2009 16:01:52 -0400
I script the change to the db and password file for all servers.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Matthew Zito
Sent: Wednesday, March 25, 2009 3:00 PM
To: piontekdd@xxxxxxxxx; TESTAJ3@xxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: changing password of user with sysdba/sysoper in RAC environment
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<mailto: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:
