Configure Oracle Net on the Standby Site Oracle Tips by Burleson

Oracle Data GuardChapter 3 - Implementing Standby Databases

Modifying the Initialization Parameter File on the Standby Site

# Miscellaneous

COMPATIBLE=9.2.0
DB_NAME=appsdb
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=appsstdby
FAL_CLIENT=appsprim

# Network Registration

INSTANCE_NAME=appsdb

The remote_archive_enable parameter should be TRUE.  Otherwise, the log transfer process will not start writing the archived redo logs to the standby site. If the Oracle instance is being created on the local host, set the lock_name_space parameter to a unique value such that the distributed lock manager can generate unique lock names. Also, change the instance_name parameter so that the instance_name of the primary and the standby database are different.

Configure Oracle Net on the Standby Site

Configure the Oracle Net on the standby site to add a listener for this logical Oracle instance and services for the logical Oracle instance and the primary standby database. Either the tnsnames.ora and listener.ora files can be edited or Oracle Net Assistant can be used for this purpose. For the details about Oracle Net configuration, read “Creating a Physical Standby Database” section.