PING[ARCk]: Heartbeat failed to connect to standby

Issue: Unable to ship the logs.

Troubleshooting Steps:

1. Verify the listener and tnsnames configuration on PRIMARY and STANDBY.

2. Check the tnsping from the both nodes vice-versa.

3. Connect from primary as below

#sqlplus sys@standby

password: 

the above command should connect to the standby database.

verify using the below command.

select name, open_mode from v$database;

4. Repeat the step 3 from standby node using the connect identifier as primary.

5. If step 1 to 4 are successfully executed.

6. Bounce the services as below.

Bounce Standby Database.

1. stop MRP (Managed Recovery Process) if it is running.

2. Stop listener.

3. Stop database.

4. start listener.

5. Start database.

6. Alter system register

Bounce Primary Database.

1. Disable log shipping

2. Stop listener.

3. Stop database.

4. start listener.

5. Start database 

6. Alter system register.

7. Enable log shipping.

8. Start MRP on the standby node.