Configuring Oracle GoldenGate for PeopleSoft

Configure Oracle GoldenGate with information for the source and target databases.

Configuring the Source and Target Databases

When working with each database, ensure that the ORACLE_HOME and ORACLE_SID environment variables are set before invoking the Oracle GoldenGate command line interpreter (GGSCI). Make sure you invoke GGSCI from $OGG_HOME or add $OGG_HOME to the $PATH environment variable.

To configure the source and target databases:

Add supplemental log groups to the source database.
```
adminclient> obey ./priaddtrndata.
```
Configure the Oracle GoldenGate processes on the source database.
```
adminclient> obey ./configure_primary.oby
```
Configure the Oracle GoldenGate processes on the target database.
```
adminclient> obey ./configure_standby.oby
```

Starting the Oracle GoldenGate Processes on the Source and Target Databases

To start the Oracle GoldenGate processes on the source and target databases:

Issue the following commands on the source database server to start the Oracle GoldenGate processes:
```
GGSCI > start manager
GGSCI> start primecap
GGSCI > info all
```
Issue the following commands on the target database server to start the Oracle GoldenGate processes:
```
GGSCI > start manager
GGSCI > info all
```
Issue the following command on the source database server to start the Oracle GoldenGate pump processes.
```
GGSCI> start primepmp
GGSCI> info all
```
Issue the following command on the target database server to start the Oracle GoldenGate repository processes.
```
GGSCI> start trgtrep
GGSCI> info all
```