Changing a Parameter File

An Oracle GoldenGate process must be stopped before changing its parameter file, and then started again after saving the parameter file. Changing parameter settings while a process is running can have unexpected results, especially if you are adding tables or changing mapping or filtering rules.

Caution:

Do not use the EDIT PARAMS command to view or edit an existing parameter file that is in a character set other than that of the local operating system (such as one where the CHARSET option was used to specify a different character set). The contents may become corrupted. View the parameter file from outside GGSCI.

To Change Parameters:

1. Stop the process by issuing the following command in GGSCI. To stop Manager in a Windows cluster, use the Cluster Administrator.

   STOP {EXTRACT | REPLICAT | MANAGER} group_name
   

2. Open the parameter file by using a text editor or the EDIT PARAMS command in GGSCI.

   EDIT PARAMS mgr
   

3. Make the edits, and then save the file.
4. Start the process by issuing the following command in GGSCI. Use the Cluster Administrator if starting Manager in a Windows cluster.

   START {EXTRACT | REPLICAT | MANAGER} group_name