Skip to main content

GoldenGate Marketplace Image Installation

Installation and configuration of the Oracle GoldenGate Marketplace Image for Oracle database migrations.

Licensing​

The GoldenGate Marketplace Image for Migrations can be used for a period of 183 days for free when used to migrate Oracle databases to OCI with tools like Zero Downtime Migration or OCI Database Migration.

Prerequisites​

The following resources must be available in OCI to install the GoldenGate Marketplace Image:

  • Compartment
  • Virtual Cloud Network
  • Subnet

Installation​

1. Create Instance​

  1. After login to OCI click on the menu and select Marketplace from the drop down list
  2. Select All Aplications from the Marketplace menu

Open Marketplace

  1. Enter goldengate in the search field and hit enter
  2. Select the Oracle GoldenGate - Database Migrations image

Choose Migrations Image

  1. Make sure the latest version and correct image is selected (this should already be set by default)
  2. Choose a compartment
  3. Accept the terms of use
  4. Click on Launch Stack to create a Resource Manager stack in OCI

Launch Stack

  1. Specify a Name for the OCI Resource Manager stack
  2. Specify a Description for the OCI Resource Manager stack
  3. Click Next

Create Stack

  1. Specify a Display Name
  2. Specify a Host DNS Name
info

Make sure this name is not already used by another host in this network

  1. Select the VCN Network Compartment
  2. Select the VCN
  3. Select the Subnet Network Compartment
  4. Select the Subnet
  5. Select the Availability Domain
  6. Specifiy the Compute Shape
info

More information about the CPU requirements for the GoldenGate compute instance can be found in the ZDM documentation: Oracle GoldenGate server CPU requirements

  1. If the GoldenGate instance should be available via a public IP then select Assign Public IP
  2. Optionally specify a Custom Volume Size
  3. Specify a Deployment Name. Default Marketplace is fine
  4. If you have already created a target Autonomous Database to migrate to you can specify the database here
  5. Paste the SSH Public Key to allow SSH access to the instance
  6. Click Next

Create Stack Variables

On the stack summary information review page check Run apply and click Create to start the execution of the Resource Manager stack.
Wait until the status of the Resource Manager job changes to SUCCEEDED.

2. Compute Login​

  1. From the OCI menu select Compute
  2. Select Instances from the Compute menu

Compute Instances

  1. Get the IP address of the newly provisioned compute instance

Get IP adress

Use an ssh client to login to the system as opc user.

ssh opc@<ipadress/hostname>

3. GoldenGate Login​

In the opc home directory on the GoldenGate compute instance you will find the file ogg-credentials.json. This file contains the username and password to login to the GoldenGate instance after the installation.

cat ogg-credentials.json

The following output will be shown:

{"username": "oggadmin", "credential": "<password>"}

This information can now be used to login to GoldenGate. Open a Web Browser and connect to the GoldenGate compute instance IP or hostname.

https://<ipaddress or hostname>

tip

Accept any possible SSL certificate errors in your browser.

In case you are using Google Chrome click anywhere in the browser window and enter: thisisunsafe

Use the username and password from the ogg-credentials.json file to login to GoldenGate.

GoldenGate Service Manager Login

After you logged in you should see 4 services running:

GoldenGate Services

4. Change Passwords​

The password of the oggadmin user should be changed after the first login. It needs to be changed in the Service Manager and also in the Administration Service of GoldenGate.

Service Manager​

To change the password:

  1. In the upper right corner click on the user icon
  2. select Change Password from the menu

Change Password

Re-login to the Golden Gate Service Manager with the new password.

Administration Service​

  1. Click on the 9111 link in the Service Manager to open the Administration Service

Launch Administration Service

A new Tab will open with request to login to the GoldenGate Administration Service. Login with the credentials from the ogg-credentials.json file.

Login Administration Service

To change the password:

  1. In the upper right corner click on the user icon
  2. select Change Password from the menu

Change Password

Re-login to the Golden Gate Administration Service with the new password.

Parameters for DMS / ZDM​

The following relevant GoldenGate parameters are used in OCI Database Migration and Zero Downtime Migration:

  • GoldenGate Username
    Installation Default: oggadmin
  • GoldenGate URL
    https://<ipaddress or hostname>
  • Source Deploymentname
    Installation Default: Marketplace
  • Target Deploymentname
    Installation Default: Marketplace