2 Get Started with Oracle GoldenGate Cloud

Look here for everything you need to know on how to get started with Oracle GoldenGate Cloud Service.

Before You Begin

There are a few prerequisite tasks that you must complete before you can create Oracle GoldenGate Cloud Service instances. The prerequisites depend on how you want to provision your Oracle GoldenGate Cloud Service instances and what features you want in those instances.

Oracle Cloud Prerequisites

Before you begin with Oracle GoldenGate Cloud Service, you should have:
  1. An Oracle Cloud account.

    For additional information, see How Do I Sign Up.
  2. Your Oracle Cloud user name, password, and identity domain. You can locate your account details in the post-activation mail that you received from Oracle Cloud.

  3. Service Administrator role for your Oracle Cloud services. When the service is activated, Oracle sends the sign-in credentials and URL to the designated Account Administrator. The Account Administrator then creates an account for each user who needs access to the service.

  4. A supported browser, such as:

    • Microsoft Internet Explorer 11.x+

    • Mozilla Firefox ESR 38+

    • Google Chrome 42+

    • Apple Safari 8.x and 7.x

    For a complete list of supported browsers, see Web Browser Requirements.

Feature based Prerequisites

  • If you want Oracle GoldenGate Cloud Service with Oracle GoldenGate Cloud Control, you must already have Oracle Database Cloud Service.

  • If you want Oracle GoldenGate Cloud Service only for replication or if you want the Oracle GoldenGate MicroServices Architecture, you don’t need Oracle Database Cloud Service.

  • If you want backup for any scenario, then you must have Oracle Cloud Infrastructure Object Storage Classic. You have the option to create a bucket or container for backups during the creation of the Oracle GoldenGate Cloud Service instance.

How to Begin With Oracle GoldenGate Cloud Subscriptions

Here’s how to get started with Oracle GoldenGate Cloud Service promotions and subscriptions:

  1. Sign up for a free credit promotion or purchase a subscription.
  2. Access Oracle GoldenGate Cloud Service .

To grant access to other users:

Oracle GoldenGate Cloud Roles and Users

When your cloud account is first set up, the Oracle GoldenGate Cloud Service administrator is given an administrator role along with additional service roles that are required to work with Oracle GoldenGate Cloud Service.

Other users in your account must be assigned these same roles in order to use Oracle GoldenGate Cloud Service. Only the identity domain administrator is allowed to create user accounts and assign roles. As an identity domain administrator, you use options on the My Services Users page to manage users and their roles for Oracle GoldenGate Cloud Service.

To add a user account, you need the following information:

  • The first name and last name of the user

  • A valid business email address for the user (We recommend that you use this email address as the user name for each of your users.)

For Oracle GoldenGate Cloud Service users, you must assign the following roles. Roles control access to applications, resources, and services. 

  • Compute Operations

  • GGCS GG Administrator

If you plan to integrate with Oracle Cloud Infrastructure Object Storage Classic then you must also assign these roles:

  • Storage Administrator

  • Storage Read Only Group

  • Storage Read Write Group

Review Adding Users and Assigning Roles in Getting Started with Oracle Cloud.

Access Oracle GoldenGate Cloud

Before you can sign in to Oracle GoldenGate Cloud Service, you must have a user account that defines your credentials (user name, password, and identity domain) and access rights to the service. In addition, you need the web address (URL) for the service.

When the service is activated, Oracle sends the sign-in credentials and URL to the designated administrator. The administrator then creates an account for each user who needs access to the service. Check your email or contact your administrator for your account credentials and service URL. The service URL looks similar to this one:

https://myservices.us2.oraclecloud.com/mycloud/faces/dashboard.jspx

With your credentials and service URL in hand, you can access Oracle GoldenGate Cloud Service through a web browser.

Quick Tour of the Oracle GoldenGate Cloud Service Instances Page

When you open the service console for Oracle GoldenGate Cloud Service from My Services, the Instances page opens. This page provides access to common service instance-related features.

When you open the service console for Oracle GoldenGate Cloud Service from My Services for the first time, you’ll land on the Welcome page. Be sure to take advantage of the tutorial and video that can assist you with creating your first service instance and all its dependencies. Also note that there’s a link to this Welcome page on the Instances page so you can return to it at any time.

An Oracle GoldenGate Cloud Service instance is a virtual machine that provides replication services for a database that you specify for your data sources. Use the Oracle GoldenGate Cloud Service Instances page to perform these tasks:

  • View all Oracle GoldenGate Cloud Service instances

  • Create an Oracle GoldenGate Cloud Service instance

  • View detailed information about a specific Oracle GoldenGate Cloud Service instance

  • Delete Oracle GoldenGate Cloud Service instances.

What is Displayed on the Oracle GoldenGate Cloud Service Instances Page

The following table describes the key information shown on the Oracle GoldenGate Cloud Service Instances page.

Element Description

navigation navigation menu

Navigation menu providing access to My Services and other Oracle Cloud services in the identity domain.

username menu

User menu providing access to help, accessibility options, console version information and sign-out.

platform services menu

Menu that provides access to Platform Services.

Activity

Click to go to the Activity page.

SSH Access

Click to go to the SSH Access page.

welcome link

Click to go to the Oracle GoldenGate Cloud Service console Welcome page.

Instances, OCPUs, Memory, Storage, and Public IPs

Summary of resources being used:

  • Instances — Total number of configured service instances.

  • OCPUs — Total number of Oracle CPUs allocated across all service instances.

  • Memory — Total amount of compute node memory allocated across all service instances.

  • Storage — Total amount of Oracle Cloud Infrastructure Compute Classic storage allocated across all service instances.

  • Public IPs — Number of public IP addresses allocated across all service instances.

search

Enter a full or partial service instance name to filter the list of service instances to include only those that contain the string in their name.

create instance

Click to create a new service instance on Oracle GoldenGate Cloud Service.

GoldenGate as a Service icon

Click to view details for the service instance.

Status

Status of the service instance if it is not running. Status values include “In Progress”, “Maintenance”, “Stopped”, and “Terminating”.

Version

Version of Oracle GoldenGate configured on the service instance. For example: 12.2.0.3.

Edition

Software edition of Oracle GoldenGate Cloud Service configured on the service instance. For example: Enterprise Edition or Standard Edition.

Created On or Submitted On

Date when the service instance was created. During the creation process, the date when the creation request was submitted.

OGGC-JMC2

Name of the service instance.

OCPUs

Number of Oracle CPUs associated with the service instance.

Memory

Amount of compute node memory in GBs associated with the service instance.

Storage

Amount of storage in GBs associated with the service instance.

action menu for each service instance

Menu that provides the following options:

Description of action-menu.png follows
Description of the illustration action-menu.png

Note:

To ensure security by default, the ports required to access these consoles are initially blocked. To use any of the consoles, you must first enable network access to the console’s port or create an SSH tunnel to the console’s port.

Instance Create and Delete History

Listing of attempts to create or delete a service instance. Click expand to view the history listing.

Typical Workflow for Implementing Oracle GoldenGate Cloud Service

Use this typical workflow as a guide when implementing Oracle GoldenGate Cloud Service for replication.

Task Description

Set up a replication database

You use Oracle Database Cloud Service or Oracle Database Exadata Cloud Service as target when replicating from on-premises to cloud, or from cloud to cloud.

Create an Oracle GoldenGate Cloud Service instance

See Before You Begin for the Oracle Cloud services and service-specific information that you must have before you can create an Oracle GoldenGate Cloud Service instance.

Configure Replicat

Use previously created SSH keys and Oracle GoldenGate command-line tools to connect to a service instance and configure a Replicat process to interact with the database.

Set up the gguser alias and credential store

Configure your template files, to set up the gguser alias and credential store..

Set up SOCKS5 proxy

After setting up the SOCKS5 proxy, you can set up Oracle GoldenGate on-premises Pump component to deliver data to GoldenGate Cloud Service through the proxy.

Configure an Extract process and data pump

To configure an Extract process and a data pump, use Oracle GoldenGate command-line tools and service instance information.

Back up your data

Use your storage container to backup and keep your data safe.

Restore your data from a backup

Use your backup to restore your data keep it safe from system failures

Patch your service instances after an upgrade

Apply patches to get all your instance services working with the latest features.

Delete a service instance

Remove a service instance.