1. Home
  2. Knowledge Base
  3. GoldenGate
  4. Exadata Cloud@Customer ZDM Online Logical Migration – Configuring GoldenGate Hub
  1. Home
  2. Knowledge Base
  3. Zero Downtime Migration
  4. Exadata Cloud@Customer ZDM Online Logical Migration – Configuring GoldenGate Hub

Exadata Cloud@Customer ZDM Online Logical Migration – Configuring GoldenGate Hub

One of the components of a Zero Downtime Migration online logical migration is a VM or Compute Instance which hosts an instance of GoldenGate MicroServices.

Typically for an ExaCS target database migration via ZDM, the VM or Compute Instance hosting GoldenGate would be OCI based.

But for a ZDM migration where the target database is an Exadata Cloud @ Customer (ExaCC) environment, the GoldenGate Microservices infrastructure can be located on-premise as opposed to OCI hosted.

This note describes the process to configure an instance of GoldenGate Microservices running on a podman/docker container – and which will serve as the GoldenGate “HUB” for the ZDM Online Logical Migration to Exadata Cloud @ Customer.

The first step we have to perform is to provision (temporarily) an Oracle Cloud Marketplace GoldenGate image. This Compute Instance will contain a “tar” file which will be used to create the docker container hosted GoldenGate Microservices instance.

Provision an Oracle Cloud Marketplace VM.

Copy the ora21c-2113000.tar file from the OCI Marketplace VM provisioned earlierto the on-premise VM which is going to serve the role as the ZDM GoldenGate Hub VM.

Execute the podman load < ora21c-2113000.tar command.

[root@lpoccpwsogg001 tmp]# podman load < ora21c-2113000.tar
Getting image source signatures
Copying blob 4411981a6090 done
Copying blob 67d008ba80bc done
Copying blob 5e5793be3604 done
Copying blob b8c7ceef0daa done
Copying blob 377155359816 done
Copying blob 69e9cf1483ea done
Copying config f9d2aea5f6 done
Writing manifest to image destination
Loaded image: docker.io/oracle/goldengate:21.13.0.0.0

Execute the command podman run –name ogg2113 -p 443:443 docker.io/oracle/goldengate:21.13.0.0.

[root@lpoccpwsogg001 tmp]# podman run --name ogg2113 -p 443:443 docker.io/oracle/goldengate:21.13.0.0.0
----------------------------------------------------------------------------------
-- Password for OGG administrative user 'oggadmin' is 'a82mUkYJu41e-3Vcs'
----------------------------------------------------------------------------------
2024-04-11T03:51:16.850Z | INFO | -------------------------------------------------------
2024-04-11T03:51:16.852Z | INFO | Copyright (c) 2014, 2020, Oracle and/or its affiliates.
2024-04-11T03:51:16.852Z | INFO | All rights reserved.
2024-04-11T03:51:16.852Z | INFO |
2024-04-11T03:51:16.852Z | INFO | Create deployment started on 04-11-2024 03:51:16
2024-04-11T03:51:16.852Z | INFO | JRE: 1.8.0_392
2024-04-11T03:51:16.853Z | INFO | -------------------------------------------------------
Password:
2024-04-11T03:51:16.855Z | INFO | Using hostname: 127.0.0.1
2024-04-11T03:51:16.856Z | INFO | Using default port for adminsrvr: 9001
2024-04-11T03:51:16.856Z | INFO | Using default port for distsrvr: 9002
2024-04-11T03:51:16.856Z | INFO | Using default port for rcvrsrvr: 9003
2024-04-11T03:51:16.856Z | INFO | Using default TCP port for pmsrvr: 9004
2024-04-11T03:51:16.856Z | INFO | Using default UDP port for pmsrvr: 9005
2024-04-11T03:51:16.856Z | INFO | Using default DataStore type 'BDB' for pmsrvr
2024-04-11T03:51:16.857Z | INFO | GGSCHEMA not provided. GLOBALS file won't be created.
2024-04-11T03:51:16.858Z | INFO | Creating deployment 'ServiceManager'
2024-04-11T03:51:16.858Z | INFO |
2024-04-11T03:51:16.858Z | INFO | Info: directory /u02/ServiceManager/etc already exists.
2024-04-11T03:51:16.858Z | INFO | Directory /u02/ServiceManager/etc/conf was created successfully.
2024-04-11T03:51:16.859Z | INFO | Directory /u02/ServiceManager/etc/conf/sca was created successfully.
2024-04-11T03:51:16.859Z | INFO | Directory /u02/ServiceManager/etc/conf/ogg was created successfully.
2024-04-11T03:51:16.859Z | INFO | Directory /u02/ServiceManager/etc/conf/logging was created successfully.
2024-04-11T03:51:16.859Z | INFO | Directory /u02/ServiceManager/etc/ssl was created successfully.
2024-04-11T03:51:16.860Z | INFO | Info: directory /u02/ServiceManager/var already exists.
2024-04-11T03:51:16.860Z | INFO | Directory /u02/ServiceManager/var/lib was created successfully.
2024-04-11T03:51:16.860Z | INFO | Directory /u02/ServiceManager/var/lib/checkpt was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/data was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/def was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/distpaths was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/info was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/report was created successfully.
2024-04-11T03:51:16.861Z | INFO | Directory /u02/ServiceManager/var/lib/sql was created successfully.
2024-04-11T03:51:16.862Z | INFO | Directory /u02/ServiceManager/var/lib/sql/install was created successfully.
2024-04-11T03:51:16.862Z | INFO | Directory /u02/ServiceManager/var/lib/wallet was created successfully.
2024-04-11T03:51:16.862Z | INFO | Directory /u02/ServiceManager/var/lib/www was created successfully.
2024-04-11T03:51:16.862Z | INFO | Directory /u02/ServiceManager/var/lib/credential was created successfully.
2024-04-11T03:51:16.862Z | INFO | Directory /u02/ServiceManager/var/lib/credential/secureStore was created successfully.
2024-04-11T03:51:16.863Z | INFO | Directory /u02/ServiceManager/var/lock was created successfully.
2024-04-11T03:51:16.863Z | INFO | Directory /u02/ServiceManager/var/log was created successfully.
2024-04-11T03:51:16.863Z | INFO | Directory /u02/ServiceManager/var/run was created successfully.
2024-04-11T03:51:16.863Z | INFO | Directory /u02/ServiceManager/var/run/BR was created successfully.
2024-04-11T03:51:16.863Z | INFO | Directory /u02/ServiceManager/var/temp was created successfully.
2024-04-11T03:51:16.863Z | INFO |
2024-04-11T03:51:16.864Z | INFO | Finished creating directories (0 errors).
2024-04-11T03:51:16.864Z | INFO |
2024-04-11T03:51:16.864Z | INFO |
2024-04-11T03:51:16.867Z | INFO | Creating global.dat file
2024-04-11T03:51:16.868Z | INFO | File created: '/u02/ServiceManager/var/temp/globalCfg.json'
2024-04-11T03:51:16.868Z | INFO | Setting file permissions on /u02/ServiceManager/var/temp/globalCfg.json
2024-04-11T03:51:16.869Z | INFO | Command: /u01/ogg/bin/pmsrvr --global=/u02/ServiceManager/var/temp/globalCfg.json --force --exit
2024-04-11T03:51:16.869Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/ServiceManager/var
2024-04-11T03:51:16.869Z | INFO | Setting child process environment variable LD_LIBRARY_PATH to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:
2024-04-11T03:51:16.869Z | INFO | Setting child process environment variable JAVA_HOME to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre
2024-04-11T03:51:16.869Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/ServiceManager/etc
2024-04-11T03:51:16.875Z | INFO | Waiting for the process to finish...
2024-04-11T03:51:16.934Z | INFO | exiting...
2024-04-11T03:51:16.934Z | INFO | Process exit value: 1
2024-04-11T03:51:16.934Z | INFO |
2024-04-11T03:51:16.935Z | INFO | Step 2: Import admin user.
2024-04-11T03:51:16.936Z | INFO | JSON payload:
{"oggadmin": {
"credential": "********",
"roles": ["Security"],
"type": "Basic",
"info": ""
}}
2024-04-11T03:51:16.936Z | INFO | Command: /u01/ogg/bin/pmsrvr --import-users=/u02/ServiceManager/var/temp/tmp_user.json --exit
2024-04-11T03:51:16.936Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/ServiceManager/var
2024-04-11T03:51:16.936Z | INFO | Setting child process environment variable LD_LIBRARY_PATH to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:
2024-04-11T03:51:16.942Z | INFO | Setting child process environment variable JAVA_HOME to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre
2024-04-11T03:51:16.942Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/ServiceManager/etc
2024-04-11T03:51:16.943Z | INFO | Waiting for the process to finish...
2024-04-11T03:51:17.076Z | INFO | Successfully imported 1 users.
2024-04-11T03:51:17.080Z | INFO | exiting...
2024-04-11T03:51:17.080Z | INFO | Process exit value: 1
2024-04-11T03:51:17.082Z | INFO |
2024-04-11T03:51:17.082Z | INFO |
2024-04-11T03:51:17.082Z | INFO | Step 3: Start ServiceManager.
2024-04-11T03:51:17.082Z | INFO | Starting up ServiceManager '/u01/ogg/bin/ServiceManager'
2024-04-11T03:51:17.083Z | INFO | Command: /u01/ogg/bin/ServiceManager --config /u02/ServiceManager/var/temp/ServiceManager-config.dat --force
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/ServiceManager/var
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable OGG_CONF_HOME to /u02/ServiceManager/etc/conf
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable OGG_SSL_HOME to /u02/ServiceManager/etc/ssl
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable LD_LIBRARY_PATH to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable JAVA_HOME to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/ServiceManager/etc
2024-04-11T03:51:17.083Z | INFO | Setting child process environment variable OGG_DATA_HOME to /u02/ServiceManager/var/lib/data
2024-04-11T03:51:18.084Z | INFO |
2024-04-11T03:51:18.084Z | INFO | Deployment (ServiceManager) creation succeeded.
2024-04-11T03:51:18.084Z | INFO | ALL DONE (0 errors).
Oracle GoldenGate Service Manager for Oracle
Version 21.13.0.0.0 OGGCORE_21.13.0.0.0OGGRU_PLATFORMS_240108.2205

Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved.

Oracle Linux 7, x64, 64bit (optimized) on Jan 9 2024 09:05:54
Operating system character set identified as UTF-8.
2024-04-11T03:51:20.357Z | INFO | Using default value for OGG_CONF_HOME: OGG_ETC_HOME/conf
2024-04-11T03:51:20.369Z | INFO | Using default value for OGG_SSL_HOME: OGG_ETC_HOME/ssl
2024-04-11T03:51:20.370Z | INFO | Using default value for OGG_DATA_HOME: OGG_VAR_HOME/lib/data
2024-04-11T03:51:20.370Z | INFO | -------------------------------------------------------
2024-04-11T03:51:20.370Z | INFO | Copyright (c) 2014, 2020, Oracle and/or its affiliates.
2024-04-11T03:51:20.370Z | INFO | All rights reserved.
2024-04-11T03:51:20.370Z | INFO |
2024-04-11T03:51:20.370Z | INFO | Create deployment started on 04-11-2024 03:51:20
2024-04-11T03:51:20.371Z | INFO | JRE: 1.8.0_392
2024-04-11T03:51:20.371Z | INFO | -------------------------------------------------------
Password:
2024-04-11T03:51:20.373Z | INFO | Using hostname: 127.0.0.1
2024-04-11T03:51:20.374Z | INFO | Creating deployment 'Local'
2024-04-11T03:51:20.374Z | INFO |
2024-04-11T03:51:20.375Z | INFO | Directory /u02/Deployment/etc was created successfully.
2024-04-11T03:51:20.375Z | INFO | Directory /u02/Deployment/etc/conf was created successfully.
2024-04-11T03:51:20.375Z | INFO | Directory /u02/Deployment/etc/conf/sca was created successfully.
2024-04-11T03:51:20.375Z | INFO | Directory /u02/Deployment/etc/conf/ogg was created successfully.
2024-04-11T03:51:20.376Z | INFO | Directory /u02/Deployment/etc/conf/logging was created successfully.
2024-04-11T03:51:20.376Z | INFO | Directory /u02/Deployment/etc/ssl was created successfully.
2024-04-11T03:51:20.376Z | INFO | Info: directory /u02/Deployment/var already exists.
2024-04-11T03:51:20.376Z | INFO | Info: directory /u02/Deployment/var/lib already exists.
2024-04-11T03:51:20.376Z | INFO | Directory /u02/Deployment/var/lib/checkpt was created successfully.
2024-04-11T03:51:20.376Z | INFO | Directory /u02/Deployment/var/lib/data was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/def was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/distpaths was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/info was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/report was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/sql was created successfully.
2024-04-11T03:51:20.377Z | INFO | Directory /u02/Deployment/var/lib/sql/install was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/lib/wallet was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/lib/www was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/lib/credential was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/lib/credential/secureStore was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/lock was created successfully.
2024-04-11T03:51:20.378Z | INFO | Directory /u02/Deployment/var/log was created successfully.
2024-04-11T03:51:20.379Z | INFO | Info: directory /u02/Deployment/var/run already exists.
2024-04-11T03:51:20.379Z | INFO | Directory /u02/Deployment/var/run/BR was created successfully.
2024-04-11T03:51:20.379Z | INFO | Info: directory /u02/Deployment/var/temp already exists.
2024-04-11T03:51:20.379Z | INFO |
2024-04-11T03:51:20.379Z | INFO | Finished creating directories (0 errors).
2024-04-11T03:51:20.380Z | INFO |
2024-04-11T03:51:20.380Z | INFO |
2024-04-11T03:51:20.383Z | INFO | File created: '/u02/Deployment/etc/conf/ogg/GLOBALS'
2024-04-11T03:51:20.384Z | INFO | Setting file permissions on /u02/Deployment/etc/conf/ogg/GLOBALS
2024-04-11T03:51:20.384Z | INFO | Creating global.dat file
2024-04-11T03:51:20.385Z | INFO | File created: '/u02/Deployment/var/temp/globalCfg.json'
2024-04-11T03:51:20.385Z | INFO | Setting file permissions on /u02/Deployment/var/temp/globalCfg.json
2024-04-11T03:51:20.385Z | INFO | Command: /u01/ogg/bin/pmsrvr --global=/u02/Deployment/var/temp/globalCfg.json --force --exit
2024-04-11T03:51:20.386Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/Deployment/var
2024-04-11T03:51:20.386Z | INFO | Setting child process environment variable LD_LIBRARY_PATH to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:
2024-04-11T03:51:20.386Z | INFO | Setting child process environment variable JAVA_HOME to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre
2024-04-11T03:51:20.386Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/Deployment/etc
2024-04-11T03:51:20.386Z | INFO | Setting child process environment variable TNS_ADMIN to /u02/Deployment/etc
2024-04-11T03:51:20.392Z | INFO | Waiting for the process to finish...
2024-04-11T03:51:20.450Z | INFO | exiting...
2024-04-11T03:51:20.451Z | INFO | Process exit value: 1
2024-04-11T03:51:20.451Z | INFO |
2024-04-11T03:51:20.451Z | INFO | Step 2: Import admin user.
2024-04-11T03:51:20.452Z | INFO | JSON payload:
{"oggadmin": {
"credential": "********",
"roles": ["Security"],
"type": "Basic",
"info": ""
}}
2024-04-11T03:51:20.452Z | INFO | Command: /u01/ogg/bin/pmsrvr --import-users=/u02/Deployment/var/temp/tmp_user.json --exit
2024-04-11T03:51:20.452Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/Deployment/var
2024-04-11T03:51:20.452Z | INFO | Setting child process environment variable LD_LIBRARY_PATH to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:
2024-04-11T03:51:20.452Z | INFO | Setting child process environment variable JAVA_HOME to /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre
2024-04-11T03:51:20.458Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/Deployment/etc
2024-04-11T03:51:20.459Z | INFO | Setting child process environment variable TNS_ADMIN to /u02/Deployment/etc
2024-04-11T03:51:20.459Z | INFO | Waiting for the process to finish...
2024-04-11T03:51:20.591Z | INFO | Successfully imported 1 users.
2024-04-11T03:51:20.595Z | INFO | exiting...
2024-04-11T03:51:20.595Z | INFO | Process exit value: 1
2024-04-11T03:51:20.596Z | INFO |
2024-04-11T03:51:20.596Z | INFO |
2024-04-11T03:51:20.597Z | INFO | Step 3: Using an existing ServiceManager (127.0.0.1:9011).
2024-04-11T03:51:20.597Z | INFO |
2024-04-11T03:51:20.597Z | INFO | Step 4: Create Deployment.
2024-04-11T03:51:20.597Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for '/services/v2/deployments/Local'
2024-04-11T03:51:20.597Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.645Z | INFO |
2024-04-11T03:51:20.645Z | INFO | Step 5: Create all SCA services.
2024-04-11T03:51:20.645Z | INFO | Connecting to ServiceManager, PATCH request to: http://127.0.0.1:9011/services/v2/deployments/Local
2024-04-11T03:51:20.645Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.645Z | INFO | JSON payload:
{"environment":[{"name":"LD_LIBRARY_PATH","value":"/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.392.b08-4.0.1.el8.x86_64/jre/lib/amd64/server:"},{"name":"TNS_ADMIN","value":"/u02/Deployment/etc"},{"name":"JAVA_HOME","value":"${OGG_HOME}/jdk"}]}
2024-04-11T03:51:20.660Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/adminsrvr'
2024-04-11T03:51:20.660Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.678Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/distsrvr'
2024-04-11T03:51:20.678Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.696Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/recvsrvr'
2024-04-11T03:51:20.696Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.712Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/pmsrvr'
2024-04-11T03:51:20.712Z | INFO | Auth user: 'oggadmin'
2024-04-11T03:51:20.726Z | INFO | Executing target DB-specific post deployment creation tasks.
2024-04-11T03:51:20.726Z | INFO | Nothing to be done for 'Oracle'.
2024-04-11T03:51:20.726Z | INFO | Deployment (Local) creation succeeded.
2024-04-11T03:51:20.726Z | INFO | ALL DONE (0 errors).
2024-04-11T03:51:26.191+0000 INFO | Restarted service 'distsrvr' in deployment 'Local' (Thread 5)
2024-04-11T03:51:26.192+0000 INFO | Task 'Local:distsrvr' started with process id 317 (Local:distsrvr)
2024-04-11T03:51:26.214+0000 INFO | Stopping service 'recvsrvr' in deployment 'Local' (Thread 7)
2024-04-11T03:51:26.411+0000 INFO | Stopped service 'recvsrvr' in deployment 'Local' (Thread 7)
2024-04-11T03:51:26.411+0000 INFO | Restarted service 'recvsrvr' in deployment 'Local' (Thread 7)
2024-04-11T03:51:26.411+0000 INFO | Task 'Local:recvsrvr' started with process id 351 (Local:recvsrvr)
2024-04-11T03:51:26.440+0000 INFO | Stopping service 'pmsrvr' in deployment 'Local' (Thread 4)
2024-04-11T03:51:27.035+0000 INFO | Stopped service 'pmsrvr' in deployment 'Local' (Thread 4)
2024-04-11T03:51:27.035+0000 INFO | Restarted service 'pmsrvr' in deployment 'Local' (Thread 4)
2024-04-11T03:51:27.043+0000 INFO | Task 'Local:pmsrvr' started with process id 417 (Local:pmsrvr)
Generating a RSA private key
.....................+++++
....................+++++
writing new private key to '/etc/nginx/cert/ogg.key'
-----
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful

Check the status of the docker container – via the command podman ps -a.

[root@lpoccpwsogg001 ~]# podman ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
06ebe0f7f6d2 docker.io/oracle/goldengate:21.13.0.0.0 4 minutes ago Up 4 minutes (healthy) 0.0.0.0:443->443/tcp ogg2113
[root@lpoccpwsogg001 ~]#

Obtain the password of the oggadmin user from the docker container logs. Make a note of this password – we will need this to login to the GoldenGate Console (and then from the console the oggadmin password can be changed).

Execute the command podman logs ogg2113|head -3

[root@lpoccpwsogg001 ~]# podman logs ogg2113|head -3
2024-04-11T03:51:16.850Z | INFO | -------------------------------------------------------
----------------------------------------------------------------------------------
-- Password for OGG administrative user 'oggadmin' is 'a82mUkYJu41e-3Vcs'
----------------------------------------------------------------------------------
2024-04-11T03:51:16.852Z | INFO | Copyright (c) 2014, 2020, Oracle and/or its affiliates.
2024-04-11T03:51:16.852Z | INFO | All rights reserved.
2024-04-11T03:51:16.852Z | INFO |
2024-04-11T03:51:16.852Z | INFO | Create deployment started on 04-11-2024 03:51:16
2024-04-11T03:51:16.852Z | INFO | JRE: 1.8.0_392
2024-04-11T03:51:16.853Z | INFO | -------------------------------------------------------

Connect as the ogg user and launch the adminclient utility. We can use the oggadmin password to connect to the deployment.

[root@06ebe0f7f6d2 /]# su - ogg
Last login: Thu Apr 11 03:57:00 UTC 2024 on pts/0
[ogg@06ebe0f7f6d2 ~]$ cd /u01
[ogg@06ebe0f7f6d2 u01]$ ls
app ogg
[ogg@06ebe0f7f6d2 u01]$ cd ogg
[ogg@06ebe0f7f6d2 ogg]$ cd bin
[ogg@06ebe0f7f6d2 bin]$ ./adminclient
Oracle GoldenGate Administration Client for Oracle
Version 21.13.0.0.0 OGGCORE_21.13.0.0.0OGGRU_PLATFORMS_240108.2205

Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved.

Oracle Linux 7, x64, 64bit (optimized) on Jan 9 2024 09:04:36
Operating system character set identified as US-ASCII.

OGG (not connected) 1> connect http://127.0.0.1 as oggadmin password a82mUkYJu41e-3Vcs
Using default deployment 'Local'

OGG (http://127.0.0.1 Local) 2> info all
Program Status Group Type Lag at Chkpt Time Since Chkpt

ADMINSRVR RUNNING
DISTSRVR RUNNING
PMSRVR RUNNING
RECVSRVR RUNNING

The ZDM online logical migration file parameter GOLDENGATEHUB_URL has the IP address of the VM hosting the docker container where GoldenGate Microservices is running.

Note: the parameter GOLDENGATEHUB_COMPUTEID has been commented out as there is no OCI located Compute Instance running GoldenGate Microservices in a ZDM logical online migration where the target database is Exadata Cloud @ Customer.

GOLDENGATEHUB_ADMINUSERNAME=oggadmin
#GOLDENGATEHUB_URL=https://ogghub.sub12080317360.vcngav.oraclevcn.com
GOLDENGATEHUB_URL=https://140.238.200.137
GOLDENGATEHUB_SOURCEDEPLOYMENTNAME=Local
GOLDENGATEHUB_TARGETDEPLOYMENTNAME=Local
#GOLDENGATEHUB_COMPUTEID=ocid1.instance.oc1.ap-sydney-1.anzxsljrs5nkwzacymmvm4teqw2euusw3xyelaxme25peqjecoe3qiisouyq
GOLDENGATEHUB_ALLOWSELFSIGNEDCERTIFICATE=TRUE

Connect to the GoldenGate console using the IP address included in the parameter GOLDENGATEHUB_URL and the oggadmin user name and password (obtained from the docker logs earlier)

Updated on April 21, 2024

Was this article helpful?

Related Articles

Leave a Comment