OCI Golden Gate Deployments have their own webconsole for managing Deployments and the API method to administer extracts and replicats are the new method for managing OCI , but there are cases where you would need the old school CLI way of managing the OCI Golden Gate Deployments , in most of the cases in my case are to work with MOS for issues with Extracts and Replicats.
The API methods and the adminclient are different ways of doing the same Golden Gate operations on the Deploymen.
In case you need reference to API way of managing Golden Gate Deployments please check my handy utility I created here
The below details are how to get you started for setting up the adminclient for Golden Gate Deployments
- Port access to 443 to the compute instance where the adminclient is required to be setup
- Need 1 GB of space and at least 2 GB of RAM
- OCI Golden Gate adminclient is not a heavy resource consuming application and in general would not require any additional blockstorage as the need is to to just have a client running to manage the Golden Gate Deployment.
- Download the 350+ MB software binary from MOS V1011471-01.zip
NOTE : adminclient can also be set up in OCI cloudshell which is a more economical way to run the adminclient , but if you are looking up to setting up monitoring cron jobs via adminclient the Cloud shell would not work , you will need a Compute instance in a compartment which has the required security lists / port access.
This is pretty straightforward activity , there is a good MOS Document " How to configure a GoldenGate adminclient to connect to a GoldenGate Service on OCI Deployment (Doc ID 2832984.1) "
The below steps show how the Adminclient is installed in the location /app/ogg_adminclient/sw
-------------- Download adminclient Files for OGG Deployment $ mkdir -p /app/ogg_adminclient/sw $ mkdir -p /app/ogg_adminclient/inv $ cd /app/ogg_adminclient $ unzip -q /tmp/V1011471-01.zip $ ls -l -------------- Prepare Response Files $ cat /app/ogg_adminclient/ogg_adminclient_rsp.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v21_1_0 INSTALL_OPTION=ora21c SOFTWARE_LOCATION=/app/ogg_adminclient/sw INVENTORY_LOCATION=/app/ogg_adminclient/inv UNIX_GROUP_NAME=oracle -------------- adminclient Installation $ ./runInstaller -silent -nowait -responseFile /app/ogg_adminclient/ogg_adminclient_rsp.rsp Starting Oracle Universal Installer... Checking Temp space: must be greater than 120 MB. Actual 20487 MB Passed Checking swap space: must be greater than 150 MB. Actual 8182 MB Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-11-15_01-22-36PM. Please wait ...$ You can find the log of this install session at: /app/app/oraInventory/logs/installActions2022-11-15_01-22-36PM.log Successfully Setup Software. The installation of Oracle GoldenGate Services was successful. Please check '/app/app/oraInventory/logs/silentInstall2022-11-15_01-22-36PM.log' for more details.
Working with the adminclient started up
$ /app/ogg_adminclient/sw/bin/adminclient Oracle GoldenGate Administration Client for Oracle Version 22.214.171.124.0 OGGCORE_126.96.36.199.0_PLATFORMS_210728.1047 Copyright (C) 1995, 2021, Oracle and/or its affiliates. All rights reserved. Oracle Linux 7, x64, 64bit (optimized) on Jul 28 2021 12:32:46 Operating system character set identified as UTF-8. OGG (not connected) 1> connect https://abcdefghij.deployment.goldengate.xx-yyyyyy-1.oci.oraclecloud.com:443 as ogguser ! OGG (https://abcdefghij.deployment.goldengate.xx-yyyyyy-1.oci.oraclecloud.com MYGGLAB) 2> info all Program Status Group Type Lag at Chkpt Time Since Chkpt EXTRACT RUNNING MYEXT INTEGRATED 00:00:00 00:00:08 REPLICAT RUNNING MYREP INTEGRATED 00:00:05 00:00:06 OGG (https://abcdefghij.deployment.goldengate.xx-yyyyyy-1.oci.oraclecloud.com MYGGLAB) 2> exit
Top comments (0)