Oracle Cloud Infrastructure Documentation

GoldenGate

Oracle GoldenGate on Oracle AI Database@Google Cloud is a fully managed, native cloud service that enables real-time, large-scale data movement. It processes data as it flows from one or more source data management systems to target databases. Creating an Oracle GoldenGate may take up to 1 hour or more.

  • Oracle GoldenGate deployment creation is only available through the Google Cloud (gcloud) CLI.

  • Oracle GoldenGate deployment creation is only available through the Google Cloud (gcloud) CLI.

  • Use the gcloud CLI to complete the following steps:
    1. Create a deployment
    2. Create a database connection
    3. Assign the connection

    Create a Deployment

    You can create an Oracle GoldenGate deployment using gCloud CLI v565.0.0 or higher.

    Prerequisites

    
gcloud auth login
export PROJECT_ID=omcpmout2
export REGION_ID=us-east4
export ODB_NETWORK_ID=my-odb-network
export ODB_SUBNET_ID=goldengatesubnet 
export ZONE_ID=us-east4-b-r1
export DISPLAY_NAME=testgg
export DEPLOYMENT_TYPE=DATABASE_ORACLE
export CPU_CORE_COUNT=2

Alternate command
gcloud --project=$PROJECT_ID oracle-database goldengate-deployments create \
$DISPLAY_NAME \
--location=$REGION_ID \
--display-name=$DISPLAY_NAME \
--properties-cpu-core-count=$CPU_CORE_COUNT \
--properties-deployment-type=$DEPLOYMENT_TYPE \
--properties-environment-type=PRODUCTION \
--ogg-data-deployment=$DISPLAY_NAME \
--ogg-data-admin-username="oggadmin" \
--ogg-data-admin-password='<user-password>' \
--odb-subnet=projects/$PROJECT_ID/locations/$REGION_ID/odbNetworks/$ODB_NETWORK_ID/odbSubnets/$ODB_SUBNET_ID \
--gcp-oracle-zone=$ZONE_ID

# Learn more on create command
gcloud oracle-database goldengate-deployments create --help
    Replace the following:
    • PROJECT_ID: The ID of your Google Cloud project where the deployment will be created.
    • REGION_ID: The region in which the GoldenGate deployment will be created.
    • ODB_NETWORK_ID: The identifier of the ODB Network associated with the deployment.
    • ODB_SUBNET_ID: The identifier of the ODB Subnet within the specified ODB Network.
    • ZONE_ID: The Oracle Database zone in which the deployment will run.
    • DISPLAY_NAME: A user-friendly name for the GoldenGate deployment.
    • DEPLOYMENT_TYPE: The type of deployment to create. For example, DATABASE_ORACLE.
    • CPU_CORE_COUNT: The number of CPU cores to allocate for the deployment.
    • <user-password>: The password for the GoldenGate administrator user.

    Create a Database Connection

    You can create a database connection using gCloud CLI v565.0.0 or higher. 

    
gcloud --project=$PROJECT_ID  oracle-database goldengate-connections create \
 $CONNECTION_ID \ --location=$LOCATION \ --properties-connection-type=ORACLE \
 --properties-display-name="$CONNECTION_ID" \
 --properties-routing-method=SHARED_DEPLOYMENT_ENDPOINT \
 --oracle-connection-properties-technology-type=$TECHNOLOGY_TYPE \
 --oracle-connection-properties-gcp-database-id= $DATABASE_ID\
 --oracle-connection-properties-session-mode=DIRECT \
 --oracle-connection-properties-username='<username>' \
 --oracle-connection-properties-password='<user-password>' \
 --gcp-oracle-zone='<zone>'

#Learn more on creating a database connection
gcloud oracle-database goldengate-connections create --help
    Replace the following:
    • PROJECT_ID: The ID of your Google Cloud project where the deployment will be created.
    • CONNECTION_ID: Unique ID for the GoldenGate connection being created.
    • LOCATION: Google Cloud region/location for the GoldenGate connection.
    • TECHNOLOGY_TYPE: Oracle AI Database technology type for the connection.
    • DATABASE_ID: ID of the Oracle AI Database@Google Cloud database that GoldenGate connects to.
    • <username>: Username that GoldenGate uses to connect.
    • <user-password>: The password for the GoldenGate administrator user.
    • <zone: The Oracle AI Database@Google Cloud zone where the database resource is located.

    Assign a Connection

    You can assign a connection using gCloud CLI v565.0.0 or higher. 

    
gcloud --project=$PROJECT_ID  oracle-database goldengate-connection-assignments create \
 $ASSIGNMENT_ID \
 --location=$LOCATION \
 --properties-goldengate-connection=projects/$PROJECT_ID /locations/$LOCATION/goldenGateConnections/$CONNECTION_ID \
 --properties-goldengate-deployment=projects/$PROJECT_ID /locations/$LOCATION/goldenGateDeployments/$DEPLOYMENT_ID
    Replace the following:
    • PROJECT_ID: the ID of your Google Cloud project where the deployment will be created.
    • ASSIGNMENT_ID: The unique identifier for the Oracle GoldenGate connection assignment that you want to create.
    • LOCATION: The Google Cloud region where the Oracle GoldenGate connection assignment is created.
    • CONNECTION_ID: The unique identifier of the Oracle GoldenGate connection that you want to assign.
    • DEPLOYMENT_ID: The unique identifier of the Oracle GoldenGate deployment that you want to associate with the connection.

  • Oracle GoldenGate deployment creation is only available through the Google Cloud (gcloud) CLI.

  • Oracle GoldenGate deployment creation is only available through the Google Cloud (gcloud) CLI.