RE: sys password change in dataguard

From: Sheehan, Jeremy <>
Date: Wed, 9 Mar 2011 08:32:57 -0500
Message-ID: <>

That's what we do. shutdown the standby and copy over the password file. Never had a problem.


From: [] On Behalf Of Kumar Madduri Sent: Tuesday, March 08, 2011 9:04 PM
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 <<>> 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.


Received on Wed Mar 09 2011 - 07:32:57 CST

Original text of this message