You are getting an error in LogTransportService
PING[ARC0]: Heartbeat failed to connect to standby . Error is 1031.
Explanation:
oerr ora 01031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
Resolution:
Check messages from:
SQL> select * from v$dataguard_status;
Code: Select all
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
1,031 PING[ARC0]: Heartbeat failed to connect to standby 'STDBY'. Error is 1031.
From primary database connect to the standby database as $sqlplus sys/****@standby as sysdba
From standby database connect to the primary database as $sqlplus sys/****@primary as sysdba
If the connection above works, this should resolve the issue.