If the logs are transmitted and not applied to the standby side, if you get the error in the “alert log” file as follows, the only reason is that the orapw file differs with standby because of the sys password change of the database.
1 2 3 4 5 6 7 8 | Error 1017 received logging on to the standby ------------------------------------------------------------ Check that the primary and standby are using a password file and remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files. returning error ORA-16191 ------------------------------------------------------------ FAL[client, ARC2]: Error 16191 connecting to ORCL for fetching gap sequence |
The solution is very simple. It is necessary to copy your database’s $ORACLE_HOME/dbs/orapw[SID] file to the same directory on the standby server.