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 Admin Client or GGSCI.

To Change Parameters:

Stop the process by issuing the following command in Admin Client or GGSCI. To stop Manager in a Windows cluster, use the Cluster Administrator.
```
STOP {EXTRACT | REPLICAT | MANAGER} group_name
```
Open the parameter file by using a text editor or the EDIT PARAMS command in Admin Client GGSCI.
```
EDIT PARAMS mgr
```
Make the edits, and then save the file.
Start the process by issuing the following command in Admin Client GGSCI. Use the Cluster Administrator if starting Manager in a Windows cluster.
```
START {EXTRACT | REPLICAT | MANAGER} group_name
```

When an Extract process or Replicat process is restarted, it picks up right where it left off. You do not need to queisce database activity prior to bouncing the Oracle GoldenGate process to replace a parameter file.