RE: sys password change in dataguard
- From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: "ksmadduri@xxxxxxxxx" <ksmadduri@xxxxxxxxx>, "kp0773@xxxxxxxxx" <kp0773@xxxxxxxxx>
- Date: Wed, 9 Mar 2011 08:32:57 -0500
That's what we do. shutdown the standby and copy over the password file.
Never had a problem.
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Kumar Madduri
Sent: Tuesday, March 08, 2011 9:04 PM
To: kp0773@xxxxxxxxx
Cc: Oracle-L@xxxxxxxxxxxxx
Subject: Re: sys password change in dataguard
At our place, we just copied the password file before the next redo log
transport and log shipping was ok
On Tue, Mar 8, 2011 at 4:11 PM, K R
<kp0773@xxxxxxxxx<mailto:kp0773@xxxxxxxxx>> wrote:
All,
We have a need to change the sys user password in primary . and we have
recently put a standby in place.
so what will be the recommended way to change the sys user password so that it
wont break the physical standby .
on 11g doc it says
9.3.7 Refresh the Password File
If the REMOTE_LOGIN_PASSWORDFILE database initialization parameter is set to
SHARED or EXCLUSIVE, the password file on a physical standby database must be
replaced with a fresh copy from the primary database after granting or revoking
administrative privileges or changing the password of a user with
administrative privileges.
Failure to refresh the password file on the physical standby database MAY
cause authentication of redo transport sessions or connections as SYSDBA or
SYSOPER to the physical standby database to fail.
however it says it may cause to fail which confuses me .
appreciate any suggestion.
thanks
Kart
Other related posts:
