When password file was used for Redo Transport authentication, the password of Redo Transport user should be same across PR Imary and all its physical and snapshot standby databases. By default SYS user was used to authenticate redo transport sessions when password file was used.
Till 12CR1 Dataguard Setup, if there is a change in password file of Primary database like changes in password or changes In admin privileges, then the password file needs to is copied from Primary database to standby database server and rename It according to standby database Instance name. If the password file of Primary and Standby databases is not same, then errors would be seen.
In 12cr2, the password file of standby database gets synchronized automatically when there was a change in Primary database Password file. The password file change of Primary would be included in Redo and when the Redo are applied to standby, the synchronization Happens in the background.
Here are a few points of knowledge:
1, 11g password file can not be stored in ASM shared access, modify the SYS password, you need to manually implement synchronization for each RAC node, the same library password file to manually update the overwrite
Version 2, 12.1 can implement the password file ASM shared storage, RAC only need a node to execute the ALTER user SYS to achieve the main library all node synchronization, this is not possible in 11g. However, the password file in the repository still needs to manually synchronize the password file of the main library to overwrite it.
3, 12.2 version of Oracle in the password file ASM shared storage, the implementation of the password file automatic synchronization of the primary and standby all nodes
MOS---
Automatic Password file synchronization in 12.2 Dataguard Standby database
Oracle 11g 12c DG Environment sys Password Synchronization problem