Standby Database Issue - Part 2

Issue 1:

 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