Preparing Oracle Database to Run Extract Process

Perform a few procedures to prepare the Oracle database to use GoldenGate replication.

1. On the Oracle Database system, prepare the parameter file for the GoldenGate Extract process. Using a text editor, create the file gg_home/dirprm/tt.prm with the following contents:

   EXTRACT tt
   USERID cacheadmin, PASSWORD ttpwd
   RMTHOST tthost1.example.com, MGRPORT 7809
   RMTTRAIL dirdat/tr
   TABLE oratt.customer;
   TABLE oratt.orders;
   TABLE oratt.item;

2. Start the GGSCI utility. Assuming that the GoldenGate home directory is in the $GG_HOME directory:

   cd $GG_HOME
   ./ggsci

   From here on all commands use GGSCI.

3. Start the GoldenGate Manager:

   GGSCI>start manager
   Manager started.

4. Run these commands in GGSCI to start the extract process.

   Configure Oracle for GoldenGate:

   GGSCI>DBLOGIN USERID cacheadmin, PASSWORD ttpwd
   GGSCI>ADD SCHEMATRANDATA oratt
   GGSCI>ADD EXTRACT tt, INTEGRATED TRANLOG, BEGIN NOW
   GGSCI>REGISTER EXTRACT tt, DATABASE
   GGSCI>ADD RMTTRAIL dirdat/tr, EXTRACT dirdat/tr

5. Start the GoldenGate Extract process using the file you configured above:

   GGSCI>start tt

For information on the GoldenGate Extract group, see ADD EXTRACT.