Background

This hands-on demonstration will showcase the highest level of security for provisioning OCI GoldenGate and its associated OCI resources. It will adhere to standard practices in creating OCI resources such as VCN, Private Subnets, Network Security Groups, Security Lists, and setting up Ingress/Egress rules on each subnet with specific port openings for the database and GoldenGate AdminClient.

With a heightened emphasis on accessing OCI GoldenGate, the GoldenGate AdminClient, and the database located within a private subnet, this discussion will delve into how the Bastion Service facilitates access to these.

Divided the demo into four segments, each of which can be displayed on four separate blogs

1. OCI Resource Creation

2. GoldenGate Artifacts Creation

3. GoldenGate AdminClient Artifacts Creation

4. DataBase Artifacts Creation

1. OCI Resource Creation

  • Compartments
  • VCN (Virtual Cloud Network)
  • Route Table
  • Subnet
  • Network Security Group (NSG)
  • Vault Key
  • Bastion Service

2. GoldenGate Artifacts Creation

  • Provision GoldenGate
  • AccessGoldenGate
    • Ingress rule for GoldenGate
    • Egress rule for GoldenGate
    • Access GoldenGate
    • Access GoldenGate webpage

3. GoldenGate AdminClient Artifacts Creation

  • Access GoldenGate AdminClient
    •  Bastion Service Creation
    • Ingress rule for GG Amdin client
    • Egress rule for GG Admin client
    • GoldenGate Admin client

4. DataBase Artifacts Creation

  • Provision database
  • Access Database
    • Ingress rule for ATP databse
    • Egress rule for ATP database
    • Access ATP database
  • Create GoldenGate Database connection
    • Egress rule for GG database connection
    • Ingeress rule for GG database connection

Outcomes : After completing this hands-on demonstration, you will be able to proficiently provision and manage OCI GoldenGate and its associated OCI resources with a focus on security.You will be equipped to create and configure Virtual Cloud Networks (VCNs), Private Subnets, Network Security Groups, and set up precise Ingress/Egress rules for controlled access. Additionally, you will understand how to use the Bastion Service to securely access OCI GoldenGate, the GoldenGate AdminClient, and databases within a private subnet. This knowledge will enable you to implement and maintain a secure and efficient data integration and replication environment within Oracle Cloud Infrastructure.