OCI - adminclient for Golden Gate Deployments
Published: 2022-11-15 17:55:48

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
https://dev.to/abhilash8/oci-oracle-golden-gate-deployment-status-for-extracts-and-replicats-1o7a

The below details are how to get you started for setting up the adminclient for Golden Gate Deployments 

## **Pre-requisite**

- 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 OCU 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.

## **adminclient Installation**

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 
$ /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 21.3.0.0.0 OGGCORE_21.3.0.0.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

```


# #oracle #oci #oracledatabase #goldengate #curl #api #oraclecloud #oracledba #nabhaas