1. Migrating Non-CDBs to New Hardware with the Same Operating System and Release
  2. Preparing the Auxiliary Instance on the Destination Host
  3. Configuring the Network Between Source and Target Oracle Databases
  4. Adding Static Service to Listener

Adding Static Service to Listener

Insert a static entry for the standby database in the listener.ora file, and save the file.

Example 3-3 Adding Static Service to Listener

[oracle @ ora12c-dup admin] $ cat listener.ora 
 # listener.ora Network Configuration File: 
 /u01/app/oracle/product/12.2.0/dbhome/network/admin/listener.ora 
 # Generated by Oracle configuration tools. 
  SID_LIST_LISTENER    = 
 (SID_LIST = 
 (SID_DESC = 
 (GLOBAL_DBNAME = dupdb ) 
 (ORACLE_HOME = /u01/app/oracle/product/12.2.0/dbhome) 
 (SID_NAME = dupdb ) 
 ) 
 ) 
 LISTENER = 
 (DESCRIPTION_LIST = 
 (DESCRIPTION = 
 (ADDRESS = (PROTOCOL = TCP) (HOST = ora12c-dup.localdomain) (PORT = 1521)) 
 ) 
 (DESCRIPTION = 
 (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521)) 
 ) 
 ) 
 ADR_BASE_LISTENER = / u01 / app / oracle 
[oracle @ oel62-ora12c-dup admin] $ lsnrctl status

Parent topic: Configuring the Network Between Source and Target Oracle Databases