Zero Downtime Installation Guide for Oracle

10.3 HotFix 3

Back Next

Populate the Schemas

Populate the C_REPOS_ZDT_STATUS repository table on the source system and the target system. Perform all steps as the schema user.

When you set the Local/Remote trail path, ensure that the physical directory exists, otherwise the process will abend. For example, create the

ENVA

and

ENVB

directories in

D:/GGS/dirdat

, and ensure that you have write privileges to those directories.

As the schema user, log in to the source schema.

Run the following command, substituting appropriate values for the environment name, schema names, directory names, user name, and port:

Insert into C_REPOS_ZDT_STATUS 
(REPLICATION_TARGET_IND, ACTIVE_UPGRADE_IND, CREATOR, CREATE_DATE 
, GGS_HOME_PATH, REPLICAT_NUMBER, TRAIL_FILE_SIZE, DISCARD_FILE_SIZE 
, ACCEPTABLE_LAG_MINUTES 
, LAG_DETECTION_TOKEN 
, LOCAL_ENVIRONMENT_NAME, LOCAL_SCHEMA_NAME, LOCAL_TRAIL_PATH, PUMP_RMTHOST, PUMP_MGRPORT 
, REMOTE_TRAIL_PATH, REMOTE_ENVIRONMENT_NAME, REMOTE_SCHEMA_NAME 
, REGULAR_STREAM_ID, EVENT_QUEUE_ID, EXTRACT_PREFIX, REPLICAT_PREFIX 
, BATCH_DISABLED_IND, DEFAULT_TIMEOUT_MINUTES, ROWID_ZDT_STATUS, WRITE_SIF_API_DISABLED_IND) 
Values (0, 0, 'MRM Installer', sysdate 
, 'D:/GGS', 1, 10, 10, 5 
, 'LAG_TOKEN_SRC' 
, 'ENVA', 'cmx_ors_a', 'D:/GGS/dirdat/enva/', 'envb_hostname', 9999, 'D:/GGS/dirdat/envb/', 'ENVB', 'cmx_ors_b' 
, 'C', 'Q', 'E','R' 
, 0, 40, '1', 0
); 
COMMIT;

Run the following command, substituting appropriate values for the environment name, schema names, directory names, user name, and port:

Insert into C_REPOS_ZDT_STATUS 
(REPLICATION_TARGET_IND, ACTIVE_UPGRADE_IND, CREATOR, CREATE_DATE 
, GGS_HOME_PATH, REPLICAT_NUMBER, TRAIL_FILE_SIZE, DISCARD_FILE_SIZE 
, ACCEPTABLE_LAG_MINUTES 
, LAG_DETECTION_TOKEN 
, LOCAL_ENVIRONMENT_NAME, LOCAL_SCHEMA_NAME, LOCAL_TRAIL_PATH, PUMP_RMTHOST, PUMP_MGRPORT 
, REMOTE_TRAIL_PATH, REMOTE_ENVIRONMENT_NAME, REMOTE_SCHEMA_NAME 
, REGULAR_STREAM_ID, EVENT_QUEUE_ID, EXTRACT_PREFIX, REPLICAT_PREFIX 
, BATCH_DISABLED_IND 
, DEFAULT_TIMEOUT_MINUTES 
, ROWID_ZDT_STATUS
, WRITE_SIF_API_DISABLED_IND) 
Values 
(1, 0, 'MRM Installer', sysdate 
, 'D:/GGS', 1, 10, 10, 5 
, 'LAG_TOKEN_TGT' 
, 'ENVB', 'cmx_ors_b', 'D:/GGS/dirdat/envb/', 'enva_hostname', 9999, 'D:/GGS/dirdat/enva/', 'ENVA', 'cmx_ors_a' 
, 'C', 'Q', 'E','R' 
, 1, 40, '1', 1
); 
COMMIT;

The following table summarizes the status of C_REPOS_ZDT_STATUS repository table:

C_REPOS_ZDT_STATUS Column Name	Source Schema Value	Target Schema Value
REPLICATION TARGET IND	0	1
LOCAL ENVIRONMENT NAME	ENVA	ENVB
LOCAL SCHEMA NAME	cmx_ors_a	cmx_ors_b
LOCAL TRAIL PATH	D:/ggs/dirdat/ENVA/	D:/ggs/dirdat/ENVB/
PUMP RMTHOST	[target host name]	[source host name]
PUMP MGRPORT	[target goldengate mgr port, such as 9999]	[source goldengate mgr port, such as 9999
REMOTE TRAIL PATH	D:/ggs/dirdat/ENVB	D:/ggs/dirdat/ENVA
REMOTE ENVIRONMENT NAME	ENVB	ENVA
REMOTE SCHEMA NAME	cmx_ors_b	cmx_ors_a
REGULAR_STREAM_ID	C	C
EVENT_QUEUE_ID	Q	Q
EXTRACT_PREFIX	E	E
REPLICAT_PREFIX	R	R

The default values from the inserts for the ENVA and ENVB directory for C_REPOS_ZDT_STATUS should be sufficient for most environments.

Rename Saved Search

Table of Contents

Zero Downtime Installation Guide for Oracle

Zero Downtime Installation Guide for Oracle

Populate the Schemas

Populate the Schemas