Re: sys password change in dataguard

From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Tue, 8 Mar 2011 18:03:58 -0800
Message-ID: <AANLkTikKiaeNGVNMr54bpFCe3uOaMFGZ_kyVTmHVBwmq_at_mail.gmail.com>



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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 08 2011 - 20:03:58 CST

Original text of this message