PING[ARC0]: Heartbeat failed to connect to standby 'stand'. Error is 1031 Reason for the above error:
Standby database password file was missing.
Solution:
Copy the primary database password file to standby server.
Issue 2:
PING[ARC0]: Heartbeat failed to connect to standby 'stand'. Error is 16047 Reason for the above error:
For LOG_ARCHIVE_DEST_2 db_unique_name was wrongly specified.
LOG_ARCHIVE_DEST_2='service=standby valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=prim'
Solution:
Changed db_unique_name from 'prim' to 'stand'
LOG_ARCHIVE_DEST_2='service=standby valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=stand'
Issue 3: While creating spfile from pfile got the below error:
ORA-00600: internal error code, arguments: [kspsetpao1]
Solution:
Metalink DOC: 444917.1
