8 Frequently Asked Questions

This section presents answers to frequently asked questions about Oracle GoldenGate Cloud.

Topics:

What's the Data Replication Scope for Oracle GoldenGate Cloud Service?

Oracle GoldenGate replication works with the following data sources:

For non-cloud to cloud replication:

  • Non-cloud source:

    • Oracle Databases 11g, Release 11.2.0.4.0 and 12c,

    • DB2 z/OS On-Premises

    • MySQL 5.6

    Note:

    Oracle 11.2.0.4 can also be used for SOCKS proxy, and Oracle versions supported by OGG 12.1.2.0.1+
  • Cloud target:

    • Oracle 12c, Release 12.1.0.2.0 - 64 Bit Production

    • Oracle Database 11g Release 11.2.0.4.0 - 64 Bit Production

    • Oracle 12c Release 12.2

For cloud to cloud replication:

  • Cloud source:

    • Oracle Databases 11g, Release 11.2.0.4.0

    • 12c, Release 12.1.0.2.0 - 64 Bit Production

  • Cloud target:

    • Oracle Databases 11g, Release 11.2.0.4.0

    • 12c, Release 12.1.0.2.0 - 64 Bit Production

    • Oracle 12c Release 12.2

For cloud to non-cloud replication:

  • Cloud source:

    • Oracle Databases 11g, Release 11.2.0.4.0

    • 12c, Release 12.1.0.2.0 - 64 Bit Production

  • Non-cloud target:

    • Oracle Databases 11g, Release 11.2.0.4.0

    • 12c (both 12.1 and 12.2)

    • MySQL 5.6

    Note:

    Oracle 11.2.0.4 can also be used for SOCKS proxy, and Oracle versions supported by OGG 12.1.2.0.1+

Note:

All Database Cloud Service editions are supported and using SOCKS5 proxy, Corente, and SSH connection.

What are the supported topologies for GGCS replication?

Now Oracle GoldenGate Cloud Service supports the following topologies:

  • One-to-one replication of on-premises to cloud where local data is replicated in the cloud.

    Architecture diagram for replication one to one from on-premises to cloud.
  • One-to-one, one-to-many (broadcast) and bi-directional replication of cloud data in the cloud.

    Architecture diagram for replication one to one, one to many, and bi-directional from cloud to cloud.

    Bi-directional replication of cloud data in the cloud now includes the Conflict Detection and Recovery (CDR) feature of GoldenGate.

  • One-to-one replication from cloud to on-premises.

    Architecture diagram for replication one to one from cloud to on-premises.

Corente allows you to provision and manage global private networks connecting to any site, over any IP network, in a secure, centralized, and simple manner.

Why Is Oracle GoldenGate Cloud Service set up with Oracle Database Cloud Service?

Oracle Database Cloud Service is an ideal fit for:
  • Maintaining synchronized Oracle standby or Replicat databases for disaster recovery and/or query offloading using Oracle Active Data Guard or Oracle GoldenGate Cloud Service.

  • Quickly provisioning high-performance Oracle databases for dynamic business reasons such as feature development, functionality testing, application certification, proof of concept, and try before buy.

  • Executing time-sensitive large-scale business applications such as launching a web-based marketing campaign, running loyalty programs, and rolling out new business initiatives.

What are the benefits of using your current Oracle GoldenGate installation with Oracle GoldenGate Cloud Service?

Oracle GoldenGate installation is used to support mission-critical systems for data availability and integration. Oracle GoldenGate also addresses your requirements for ensuring your data is consistent between cloud and on-premises instances.

Can I use my existing GoldenGate deployments with GoldenGate Cloud Service?

Yes, you can use your existing non-cloud GoldenGate Extract and data pump to deliver data to GoldenGate Cloud Service.

The Replicat in GoldenGate Cloud Service instance delivers the data to Oracle Database Cloud Service.

Do I have to subscribe Oracle Database Cloud Service?

Yes you do. As a prerequisite for using GoldenGate Cloud Service you need:
  • Oracle Database Cloud Service for in cloud delivery.

Is there any additional charge for support?

No, support is included in the subscription price for this service.

How Can I Enable Multiple Users to Access the Same GGCS Virtual Machine?

You could have a requirement to enable multiple users in your organization to access the same Oracle GoldenGate Cloud Service virtual machine to provide support or perform maintenance tasks.

To enable multiple users to access a single virtual machine, Oracle recommends the following:
  1. Login to the virtual machine as the OPC user.
  2. Create a new user in the virtual machine.
    useradd -m -d /home/<your username> -s /bin/bash <your username>
  3. Create a new SSH public key from the machine a user will use to access the Oracle GoldenGate Cloud Service virtual machine.
    ssh-keygen -t dsa
  4. Copy the SSH key from the user machine /home/username/.ssh/id_dsa.pub to the Oracle GoldenGate Cloud Service virtual machine /home/<your username>/.ssh/authorized_keys.
  5. Set the following permissions for the files on the Oracle GoldenGate Cloud Service virtual machine:
    • chown -R username:username /home/username/.ssh
    • chmod 700 /home/username/.ssh
    • chmod 600 /home/username/.ssh/authorized_keys
The new user can now SSH into the Oracle GoldenGate Cloud Service virtual machine using: <your username>@<OGG vm IP>.

Note:

Since this approach does not use private keys, it is machine specific. Since the key is generated on a particular machine, a user can login to the virtual machine using that machine alone. If you want to enable multiple machines to access the virtual machine using the same user, individual keys need to be generated on each of those machines and copied to /home/username/.ssh/authorized_keys in the Oracle GoldenGate Cloud Service virtual machine.