Monitor installation and startup

It can take up to 20 minutes for the Grid Infrastructure (GI) installation to complete. SSH into node1 of the Primary cluster and Standby cluster in single- or multi-region configurations, Primary cluster if primary only configuration, or Standby cluster if Standby only configuration. to monitor this process.

  1. Get the Public IP address of node1 of the primary cluster:
    1. In the Oracle Cloud console, in the navigation menu, click Compute, and then Instances.
    2. In the Instances list, locate your node1 of the primary cluster, and then copy its Public IP.

      Tip:

      The naming convention of your primary cluster's node1 is <cluster-prefix>1-<node-prefix>1.
  2. Use a terminal application or Cloud Shell to SSH into node1 of the primary cluster as the opc user.
  3. Open /tmp/startupScript.log in a supported text editor, for example: tail -f /tmp/startupScript.log.
  4. Monitor the messages outputted to this file until you see the following:

    For Single and Multi region primary and standby clusters:

    ################################################################################
Deployment is successful, all resources are online and ACFS replication is healthy
################################################################################

    For Standby cluster only:

    #############################
Deployment is successful
##############################

    This indicates that the GI installation completed, and Oracle GoldenGate is ready for you to use.

Establish ACFS replication for independently created clusters

If you've just configured and installed a Single-region Standby Cluster only or Single-region Primary Cluster only deployment, follow the instructions below to establish ACFS replication between independently created primary and standby clusters.

You can run /u01/oracle/scripts/hybrid_replconfig.sh to establish ACFS replication between independently created Primary and Standby clusters.

This script:

  1. (Optional) Enables password less SSH for grid user for all nodes in both clusters.
  2. Initiates ACFS replication between the Primary and Standby cluster.
  3. Updates Standby cluster GoldenGate XAG resource configurations if they're are different from the Primary cluster. For example, the Service Manager port, configuration and var directories.
  4. Generates and pushes Nginx configuration file to all Standby cluster nodes, and then restarts Nginx on these nodes so that Nginx references the new configuration file.
  5. Verifies that ACFS replication is healthy and all the GGHub Standby cluster resources are in expected the state.

Tip:

Before you begin, ensure that you:
  • Add the XAG path to the root user PATH for all nodes of the primary and standby clusters.
  • Set OGG_HOME for the oracle user for all nodes of the primary and standby clusters.

This script takes the following inputs:

Parameter Parameter description/example
-p

Required. Primary cluster host names.

Example: -p oggclp1-node1,oggclp1-node2
-s

Required. Standby cluster host names.

Example: -s oggcls2-node1,oggcls2-node2
-a

Required. Primary cluster VIP DNS name.

Example: -a <primary-vip-dns-name>
-b

Required. Standby cluster VIP DNS name.

Example: -b <standby-vip-dns-name>
-u Optional. SSH username to connect to clusters from client host. This user should have sudo privileges. Default: opc

Example: -u <username>
-m Optional. ACFS mount point.

Example: -m /mnt/acfs_gg
-d Optional. GoldenGate deployment name.

Example: -d Marketplace
-e Optional. Enable passwordless SSH. Enter n to skip enabling passwordless SSH for the grid user. Default: y

Example: -e n
-h Optional. Show Help.

Run the script on a client host configured to SSH. For example:

hybrid_replconfig.sh -p oggcla1-node1,oggcla1-node2 -s oggclb2-node1,oggclb2-node2 -a oggcla1.cluster.ggoraclevcn.com -b oggclb2.cluster.ggoraclevcn.com -m /mnt/acfs_gg1 -d Marketplace -u opc -e n

If you don't input the ACFS mount point or GoldenGate deployment name, the script prompts you with a mount point or deployment name retrieved from the cluster resource details so that you can select them or enter your preference.

After all configurations are set up successfully, the following message displays:
#### ACFS replication and GoldenGate configuration successful between Primary and Standby cluster ####

Verify VIP and ACFS failover

Optionally, you can run the /u01/oracle/scripts/verify_vip_and_acfs_failover.sh script to validate the configuration.

WARNING:

Running the script could trigger an ACFS role reversal by changing the ACFS replication sites.
Run this script as grid user on the standby cluster node where ACFS is currently mounted.
verify_vip_and_acfs_failover.sh [-m <ACFS mount point>] [-d <Goldengate deployment name>] [-r <Application VIP resource name>] [-h]
Example: 
verify_vip_and_acfs_failover.sh -m /mnt/acfs_gg1 -d Marketplace

Next, configure the source and target databases.