1 Prerequisites

Ensure that you go through the following prerequisites before using Oracle GoldenGate on Oracle Cloud Marketplace.

Supported Browsers

Oracle Cloud Infrastructure supports the latest desktop versions of Google Chrome, Microsoft Edge, Internet Explorer 11, Safari, Firefox, and Firefox ESR. Note that Mobile browsers as well as private browsing mode is not supported for Firefox, Internet Explorer, or Edge.

1.1 Prerequisites to Deploy Oracle GoldenGate Microservices

By using Oracle GoldenGate Microservices on Marketplace, you can deploy Oracle GoldenGate in an off-box architecture, which means you can run and manage your Oracle GoldenGate deployment from a single location.

Here are the prerequisites required to deploy Oracle GoldenGate Microservices:

  • Oracle Cloud Account
  • Access to assigned Oracle Cloud Tenant
  • Compute node resources within Oracle Cloud Tenant
  • Local SSH/RSA Key

Create an SSH/RSA Key

To work with the Oracle Cloud Infrastructure once the Oracle GoldenGate Compute Node is built, you have to provide a SSH Public Key during the interview process that will allow you to log in to the node once built.

In order to build your SSH keys, perform the following steps:

  1. Open a Terminal window and start the key generation program by typing the following command:
    $ ssh-keygen Generating public/private rsa key pair.
  2. Enter the path to store this file. By default, this gets saved in your home directory under a hidden folder called .ssh. Change this default location, if required.
    Enter file in which to save the key (/Users/johndoe/.ssh/id_rsa): <Return>
  3. Enter a passphrase for using your key.
    Enter passphrase (empty for no passphrase): <passphrase>
  4. Re-enter the passphrase to confirm it.
    Enter same passphrase again: <passphrase>
  5. Check the results.

    The key fingerprint (a colon separated series of 2 digit hexadecimal values) is displayed. Check if the path to the key is correct. In the above example, the path is /Users/johndoe/.ssh/id_rsa.pub. You have now created a public or private key pair.

Note:

For generating key pair on Windows platform, refer to Creating a Key Pair section in Oracle Cloud Infrastructure Documentation.

1.2 OCI Policies Needed for Creating Oracle GoldenGate Marketplace Instances

The following OCI policies are required for creating Oracle GoldenGate Market Place instances:

  • Allow group <ggowner> to manage instance-family in compartment <Compartment Name>
  • Allow group <ggowner> to manage orm-family in compartment <Compartment Name>
  • Allow group <ggowner> to manage volume-family in compartment <Compartment Name>
  • Allow group <ggowner> to use virtual-network-family in compartment <Compartment Name>
  • Allow group <ggowner> to manage public-ips in compartment <Compartment Name>
  • Allow group <ggowner> to use tag-namespaces in tenancy
  • Allow group <ggowner> to inspect compartments in tenancy

Where <ggowner> is an example for a group and <Compartment Name> is an example of a compartment. The following are permission names: instance-family, orm-family, volume-family, virtual-network-family, and public-ips.

Note:

  • The manage public-ips permission is required only if you give the instance a public IP address. Oracle GoldenGate uses reserved IP addresses so that the public address is preserved across stack upgrades.
  • The Networks compartment is an assumption that the customers follow the practice of having a separate network group manage the network resources for all users in the tenancy. If the tenancy instead allows you to create network resources of your own, then the policy would be: Allow group <marketplace-permissions> to manage virtual-network-family in compartment <Marketplace-Test>.

1.3 Configuring Source or Target Database for Replication

Before you can begin replicating data, you should prepare the source or target database to support Oracle GoldenGate. For more information about steps to prepare your Oracle database, see Preparing the Database for Oracle GoldenGate in the Using Oracle GoldenGate for Oracle Database Guide. See also Preparing the System for Oracle GoldenGate (for DB2), Preparing and Configuring the System for Oracle GoldenGate (MySQL), and SQL Server: Preparing the System for Oracle GoldenGate in Using Oracle GoldenGate for Heterogeneous Databases guide.