Dealing with redo transport authentication problems
By default, the SYS user is used for redo transport in Data Guard configurations. Data Guard communication uses password files in the standby databases to authenticate redo transport sessions. If we change the password of the SYS user in the primary database, redo transport sessions will not be authenticated because the password file in the standby site will be outdated. So redo transport will raise the ORA-01017: invalid username/password or ORA-01031: insufficient privileges error. The primary database alert logfile will include the following lines:
Error 1017 received logging on to the standby PING[ARC0]: Heartbeat failed to connect to standby 'INDIAPS'. Error is 16191.
It can also include ...
Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
