Task 2: Prepare Oracle Database for GoldenGate Extraction

You can follow several steps to prepare the Oracle database for GoldenGate extraction.

Note:

After installing GoldenGate, assign the necessary user privileges that are required for connecting to Oracle database from Oracle GoldenGate. For details, see Oracle in the Microservices Architecture Documentation.

To prepare your database for GoldenGate extraction:

  1. Use the Oracle GoldenGate Configuration Assistant (OGGCA) utility to create deployments and the Service Manager process on a host machine. Add a deployment using the OGGCA wizard and then create a Service Manager. For details, see Add a Deployment in the Microservices Architecture Documentation.
  2. Start the Service Manager. See Start and Stop the Service Manager in the Microservices Architecture Documentation.
  3. Start the Admin Client and then connect to your deployment, see About Admin Client in the Microservices Architecture Documentation.
  4. The Extract process is the extraction or the data capture mechanism of Oracle GoldenGate. Before you add an Extract, ensure that the following settings are configured:
    • Add database connections
    • Add SCHEMATRANDATA
    • Register an Extract

    For details, see Add an Online Extract in the Microservices Architecture Documentation.

  5. Create a parameter file for an Extract and edit it (see Create a Parameter File for Extract in the Microservices Architecture Documentation). In this example, the FQDN (Fully Qualified Domain Name) of the system hosting the TimesTen database is tthost1.example.com (see Set the Net Service Name for the Oracle Database in the tnsnames.ora File). Edit the parameter file with the following content for the GoldenGate Extract process:
    EXTRACT tt
USERID cacheadmin, PASSWORD ttpwd
RMTHOST tthost1.example.com, MGRPORT 7809
RMTTRAIL dirdat/tr
TABLE oratt.customer
TABLE oratt.orders
TABLE oratt.item
  6. Before you start an Extract process, determine the current SCN value (see Task 5: Perform the Initial Data Load). Now, start the Extract process. For details, see Start or Stop Extract in the Microservices Architecture Documentation.