Zero Downtime Installation Guide for Oracle

Zero Downtime Installation Guide for Oracle

Populate the Schemas

Populate the Schemas

The
deploy_zdt
command automatically updates the C_REPOS_ZDT_STATUS repository table in the source and target systems.
The following table summarizes the columns updated in the C_REPOS_ZDT_STATUS repository table:
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 must be sufficient for most environments.

0 COMMENTS

We’d like to hear from you!