Make log shipping to work without copying password file from primary to physical standby when changing sys password on primary? Sometimes in a dataguard configuration the user SYS must be changing because of security policies.
This results in a failed redolog shiping problem as describe by Harald van Breederode "Password file maintenance in a Data Guard environment"
In this blogpost Harald was also mentioning redo transport authentication by an other Oracle user then SYS.
To use an other Oracle user then SYS for redo transport authentication you have to do the following steps:
In Oracle 11gR1 Oracle has introduced an new init.ora parameter called REDO_TRANSPORT_USER, with this parameter Oracle can activate the redo transport authentication to be done by an other user then the default user SYS.
Showing posts with label V$PWFILE_USERS. Show all posts
Showing posts with label V$PWFILE_USERS. Show all posts
Subscribe to:
Posts (Atom)