Oracle Database Discussions

Hi,

I am using Oracle 10.2.0.4 database on Solaris 10.

Our primary database is a 2-instance RAC database and the standby which has been configured is also a 2 instance RAC database.

log_archive_dest_1                   string      location="/u02/app/oracle/arch
                                                 /smttst", valid_for=(ONLINE_LO
                                                 GFILE,ALL_ROLES)
log_archive_dest_2                   string      SERVICE=smttstdr VALID_FOR=(ON
                                                 LINE_LOGFILES,PRIMARY_ROLE) DB
                                                 UNIQUENAME=smttstdr
log_archive_dest_state_1             string      ENABLE
log_archive_dest_state_2             string      ENABLE

Password files have all been set correctly in both primary and standby.

Initially I received these error messages

ARC1: Archival destination is a Primary RAC instance: 'smttstdr'
Mon Jun 22 15:46:55 2009
Errors in file /u01/app/oracle/admin/smttst/bdump/smttst1_arc1_20487.trc:
ORA-16047: DGID mismatch between destination setting and standby
PING[ARC1]: Heartbeat failed to connect to standby 'smttstdr'. Error is 16047.
Mon Jun 22 15:48:47 2009

This was due to the wrong entry in the tnsnames.ora which has been fixed now.

tnsnames.ora file in primary

SMTTST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.113.30)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.113.40)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = smttst)
    )
  )

SMTTSTDR =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.113.30)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.113.40)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = smttstdr)
    )
  )

tnsnames.ora file in standby

SMTTST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.113.30)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.130.113.40)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
     (SERVICE_NAME = smttst)
    )
  )

SMTTSTDR =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.113.30)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.113.40)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = smttstdr)
    )
  )

Any suggestions?