Two Types of Parameter Files
GLOBALS File Parameters
* Stored in GG root directory with the fiel name ‘GLOBALS’.
* Applies to whole instance.
* Can be overridden by process parameters.
* Created with command ‘EDIT PARAMS ./GLOBALS’
GGSCI 26> EDIT PARAMS ./GLOBALS MGRSERVNAME gg_demo_src
Process Specific Parameters
* Applies to a specific process such as extract or replicat.
* One parameter file per process (use obey command to include other files).
Two types:
* Global parameters: apply to all db objects.
* Object specific parameters: apply to specific db objects.
Create a parameter file
* Created with command ‘EDIT PARAMS
extract e_cust userid system, password orcl exttrail C:\prog\GoldenGate\GoldenGate_Src\dirdat\cu TABLE GG_TEST_SRC.CUSTOMERS;
Verify a parameter file
* Add to parameter file: CHECKPARAMS
* Start process.
* View report for results.
* Remove ‘CHECKPARAMS’ if verified.
Use Parameter Substitution
* Prefix parameter name to be substituted with ?
SOURCEISFILE EXTFILE ?EXTFILE MAP ?TABNAME, TARGET account_targ;
* Set env var with the same name without ?
rem Windows set EXTFILE=C:\ggs\extfile set TABNAME=prod.accounts # Unix EXTFILE=/ggs/extfile export EXTFILE TABNAME=prod.accounts export TABNAME