At the recent Oracle Cloud World 2023 conference which just concluded at Las Vegas, Oracle has made an announcement about the new Oracle GoldenGate 23c “Free“ release.
The free GoldenGate 23c release provides support for all the new Oracle Database 23c objects and data types including blockchain, immutable tables, Boolean data type, 4K columns, and SQL domains.
We can connect GoldenGate 23c to the Oracle 23c Database Developer free release (which is now available since April 2023) if we would like to test some of the new 23c features which we will discuss in a forth coming post.
More information about new features can be found in the documentation link below:
The software for GoldenGate 23c is available as docker image which can be downloaded and installed from Oracle Container Registry.
The link below also has a lot of information about the new Oracle GoldenGate 23c free release – new features, documentation, use cases, limitations etc.
https://www.oracle.com/au/integration/goldengate/free
We can use the following commands to install docker on Oracle Linux8. Follow Tim Hall’s excellent article https://oracle-base.com/articles/linux/docker-install-docker-on-oracle-linux-ol8 to get more details.
yum install docker-engine dnf config-manager --add-repo=https://download.docker.com/linux/centos/docker-ce.repo dnf install -y docker-ce --nobest systemctl enable docker.service systemctl start docker.service systemctl status docker.service docker version docker ps echo "oracle ALL=(ALL) NOPASSWD: /usr/bin/docker" >> /etc/sudoers echo "alias docker=\"sudo /usr/bin/docker\"" >> /home/oracle/.bash_profile
To install GoldenGate 23c free edition using the docker container, we can run the following command
docker run -p 80:80 -p 443:443 -e OGG_ADMIN=ggadmin -e OGG_ADMIN_PWD=mypassword -e OGG_DOMAIN=OGG23c -v /u01 container-registry.oracle.com/goldengate/goldengate-free:latest
Note: the following are the default settings if we just run the command :
docker run oracle/goldengate-free:latest
- auto generated container name
- 80 port for HTTP Server
- 443 port for HTTPS Server
oggadminfor the name of the administrative account- auto generated the password for the administrative account
Localfor the name of the deployment- Use container storage for
/u02and/u03volume - auto generated self-signed certificate
[oracle@db23c ~]$ docker run -p 80:80 -p 443:443 -e OGG_ADMIN=ggadmin -e OGG_ADMIN_PWD=DreamLiner787## -e OGG_DOMAIN=OGG23c -v /u01 container-registry.oracle.com/goldengate/goldengate-free:latest
Unable to find image 'container-registry.oracle.com/goldengate/goldengate-free:latest' locally
latest: Pulling from goldengate/goldengate-free
1144811781bb: Pull complete
826fe6b602ae: Pull complete
451e50970e5c: Pull complete
2c26026ba098: Pull complete
20dee2b41aba: Pull complete
5a195d007281: Pull complete
79fe305ec562: Pull complete
069a3423f558: Pull complete
796e61db87fc: Pull complete
ab850d192ed5: Pull complete
46ff7be623ff: Pull complete
20bf6d3bdd5b: Pull complete
39b2daf35cdb: Pull complete
7070892a2990: Pull complete
8a0b3eca2d74: Pull complete
e366ee17b25a: Pull complete
d2e28da0943e: Pull complete
bbcb6061422d: Pull complete
489d4513c301: Pull complete
5a38d7daa3a4: Pull complete
f43d7d6eb414: Pull complete
8d9c644fcc6c: Pull complete
a65c0d4e8282: Pull complete
59aba49f749e: Pull complete
5f0894b02b41: Pull complete
89b3f222e797: Pull complete
76a2cf5f874c: Pull complete
Digest: sha256:3ff3926adc53011bae1f71598d2239f091bcaf7736d22cabe033c00f8b108d3d
Status: Downloaded newer image for container-registry.oracle.com/goldengate/goldengate-free:latest
OGG_SECURE_DEPLOYMENT=false
APP_HOME=/u01/oggf
APP_DATA_HOME=/u02/oggf
/u02/oggf/deploymentId
OGGF_DEPLOYMENT_ID=a7cb79db-e4e0-43a8-b2e0-612766eef12b
/u02/oggf/certificate /u02/oggf
Generating a RSA private key
.....................................................................++++
.............++++
writing new private key to '/u01/oggf/certificate/ca-key.pem'
-----
Generating RSA private key, 4096 bit long modulus (2 primes)
..............++++
.....++++
e is 65537 (0x010001)
Signature ok
subject=CN = 8690bfe003db
Getting CA Private Key
/etc/nginx/cert/ogg.pem.full: OK
/etc/nginx/cert/ogg.pem: OK
/u02/oggf
OGG_SERVERCERT=/u02/oggf/certificate/server.pem
OGG_SERVERCERT_KEYFILE=/u01/oggf/certificate/server-key.pem
2023-10-02T06:20:35.922Z | INFO | -------------------------------------------------------
2023-10-02T06:20:35.923Z | INFO | Copyright (c) 2014, 2020, Oracle and/or its affiliates.
2023-10-02T06:20:35.926Z | INFO | All rights reserved.
2023-10-02T06:20:35.926Z | INFO |
2023-10-02T06:20:35.926Z | INFO | Create deployment started on 10-02-2023 06:20:35
2023-10-02T06:20:35.926Z | INFO | JRE: 17
2023-10-02T06:20:35.927Z | INFO | -------------------------------------------------------
Password:
2023-10-02T06:20:35.933Z | INFO | Using hostname: 127.0.0.1
2023-10-02T06:20:35.937Z | INFO | Using default port for adminsrvr: 9001
2023-10-02T06:20:35.938Z | INFO | Using default port for distsrvr: 9002
2023-10-02T06:20:35.938Z | INFO | Using default port for rcvrsrvr: 9003
2023-10-02T06:20:35.938Z | INFO | Using default TCP port for pmsrvr: 9004
2023-10-02T06:20:35.938Z | INFO | Using default UDP port for pmsrvr: 9005
2023-10-02T06:20:35.938Z | INFO | Using default DataStore type 'BDB' for pmsrvr
2023-10-02T06:20:35.938Z | INFO | GGSCHEMA not provided. GLOBALS file won't be created.
2023-10-02T06:20:35.939Z | INFO | Creating deployment 'ServiceManager'
2023-10-02T06:20:35.939Z | INFO |
2023-10-02T06:20:35.941Z | INFO | Info: directory /u02/ServiceManager/etc already exists.
2023-10-02T06:20:35.942Z | INFO | Directory /u02/ServiceManager/etc/conf was created successfully.
2023-10-02T06:20:35.942Z | INFO | Directory /u02/ServiceManager/etc/conf/sca was created successfully.
2023-10-02T06:20:35.942Z | INFO | Directory /u02/ServiceManager/etc/conf/ogg was created successfully.
2023-10-02T06:20:35.942Z | INFO | Directory /u02/ServiceManager/etc/conf/logging was created successfully.
2023-10-02T06:20:35.943Z | INFO | Directory /u02/ServiceManager/etc/ssl was created successfully.
2023-10-02T06:20:35.943Z | INFO | Info: directory /u02/ServiceManager/var already exists.
2023-10-02T06:20:35.943Z | INFO | Directory /u02/ServiceManager/var/lib was created successfully.
2023-10-02T06:20:35.943Z | INFO | Directory /u02/ServiceManager/var/lib/checkpt was created successfully.
2023-10-02T06:20:35.945Z | INFO | Directory /u02/ServiceManager/var/lib/data was created successfully.
2023-10-02T06:20:35.946Z | INFO | Directory /u02/ServiceManager/var/lib/def was created successfully.
2023-10-02T06:20:35.946Z | INFO | Directory /u02/ServiceManager/var/lib/distpaths was created successfully.
2023-10-02T06:20:35.946Z | INFO | Directory /u02/ServiceManager/var/lib/info was created successfully.
2023-10-02T06:20:35.946Z | INFO | Directory /u02/ServiceManager/var/lib/report was created successfully.
2023-10-02T06:20:35.947Z | INFO | Directory /u02/ServiceManager/var/lib/sql was created successfully.
2023-10-02T06:20:35.947Z | INFO | Directory /u02/ServiceManager/var/lib/sql/install was created successfully.
2023-10-02T06:20:35.947Z | INFO | Directory /u02/ServiceManager/var/lib/wallet was created successfully.
2023-10-02T06:20:35.949Z | INFO | Directory /u02/ServiceManager/var/lib/www was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/lib/credential was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/lib/credential/secureStore was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/lock was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/log was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/run was created successfully.
2023-10-02T06:20:35.950Z | INFO | Directory /u02/ServiceManager/var/run/BR was created successfully.
2023-10-02T06:20:35.951Z | INFO | Directory /u02/ServiceManager/var/temp was created successfully.
2023-10-02T06:20:35.951Z | INFO |
2023-10-02T06:20:35.951Z | INFO | Finished creating directories (0 errors).
2023-10-02T06:20:35.951Z | INFO |
2023-10-02T06:20:35.954Z | INFO |
2023-10-02T06:20:35.956Z | INFO |
2023-10-02T06:20:35.956Z | INFO | Step 2: Import admin user.
2023-10-02T06:20:35.957Z | INFO | JSON payload:
{"ggadmin": {
"credential": "********",
"roles": ["Security"],
"type": "Basic",
"info": ""
}}
2023-10-02T06:20:35.958Z | INFO | Command: /u01/ogg/bin/pmsrvr --import-users=/u02/ServiceManager/var/temp/tmp_user.json --exit
2023-10-02T06:20:35.958Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/ServiceManager/var
2023-10-02T06:20:35.958Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/ServiceManager/etc
2023-10-02T06:20:35.989Z | INFO | Waiting for the process to finish...
2023-10-02T06:20:36.083Z | INFO | Successfully imported 1 users.
2023-10-02T06:20:36.087Z | INFO | exiting...
2023-10-02T06:20:36.087Z | INFO | Process exit value: 1
2023-10-02T06:20:36.088Z | INFO |
2023-10-02T06:20:36.088Z | INFO |
2023-10-02T06:20:36.088Z | INFO | Step 3: Start ServiceManager.
2023-10-02T06:20:36.088Z | INFO | Starting up ServiceManager '/u01/ogg/bin/ServiceManager'
2023-10-02T06:20:36.089Z | INFO | Command: /u01/ogg/bin/ServiceManager --inventory /u02/ServiceManager/etc/conf
2023-10-02T06:20:36.089Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/ServiceManager/var
2023-10-02T06:20:36.089Z | INFO | Setting child process environment variable OGG_CONF_HOME to /u02/ServiceManager/etc/conf
2023-10-02T06:20:36.089Z | INFO | Setting child process environment variable OGG_SSL_HOME to /u02/ServiceManager/etc/ssl
2023-10-02T06:20:36.089Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/ServiceManager/etc
2023-10-02T06:20:36.089Z | INFO | Setting child process environment variable OGG_DATA_HOME to /u02/ServiceManager/var/lib/data
2023-10-02T06:20:37.098Z | INFO |
2023-10-02T06:20:37.099Z | INFO | Deployment (ServiceManager) creation succeeded.
2023-10-02T06:20:37.099Z | INFO | ALL DONE (0 errors).
Oracle GoldenGate Free Service Manager for Oracle
Version 23.3.0.0.0 Free OGGCORE_23.3.0.0.0_LINUX.X64_230915.1721_FBO
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
Linux, x64, 64bit (optimized) on Sep 15 2023 21:53:32
Operating system character set identified as UTF-8.
2023-10-02T06:20:39.501Z | INFO | Using default value for OGG_CONF_HOME: OGG_ETC_HOME/conf
2023-10-02T06:20:39.547Z | INFO | Using default value for OGG_SSL_HOME: OGG_ETC_HOME/ssl
2023-10-02T06:20:39.548Z | INFO | Using default value for OGG_DATA_HOME: OGG_VAR_HOME/lib/data
2023-10-02T06:20:39.548Z | INFO | -------------------------------------------------------
2023-10-02T06:20:39.548Z | INFO | Copyright (c) 2014, 2020, Oracle and/or its affiliates.
2023-10-02T06:20:39.548Z | INFO | All rights reserved.
2023-10-02T06:20:39.548Z | INFO |
2023-10-02T06:20:39.548Z | INFO | Create deployment started on 10-02-2023 06:20:39
2023-10-02T06:20:39.549Z | INFO | JRE: 17
2023-10-02T06:20:39.549Z | INFO | -------------------------------------------------------
Password:
2023-10-02T06:20:39.551Z | INFO | Using hostname: 127.0.0.1
2023-10-02T06:20:39.552Z | INFO | Creating deployment 'Local'
2023-10-02T06:20:39.552Z | INFO |
2023-10-02T06:20:39.552Z | INFO | Directory /u02/Deployment/etc was created successfully.
2023-10-02T06:20:39.552Z | INFO | Directory /u02/Deployment/etc/conf was created successfully.
2023-10-02T06:20:39.553Z | INFO | Directory /u02/Deployment/etc/conf/sca was created successfully.
2023-10-02T06:20:39.553Z | INFO | Directory /u02/Deployment/etc/conf/ogg was created successfully.
2023-10-02T06:20:39.553Z | INFO | Directory /u02/Deployment/etc/conf/logging was created successfully.
2023-10-02T06:20:39.553Z | INFO | Directory /u02/Deployment/etc/ssl was created successfully.
2023-10-02T06:20:39.553Z | INFO | Info: directory /u02/Deployment/var already exists.
2023-10-02T06:20:39.554Z | INFO | Info: directory /u02/Deployment/var/lib already exists.
2023-10-02T06:20:39.554Z | INFO | Directory /u02/Deployment/var/lib/checkpt was created successfully.
2023-10-02T06:20:39.554Z | INFO | Directory /u02/Deployment/var/lib/data was created successfully.
2023-10-02T06:20:39.554Z | INFO | Directory /u02/Deployment/var/lib/def was created successfully.
2023-10-02T06:20:39.554Z | INFO | Directory /u02/Deployment/var/lib/distpaths was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/info was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/report was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/sql was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/sql/install was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/wallet was created successfully.
2023-10-02T06:20:39.555Z | INFO | Directory /u02/Deployment/var/lib/www was created successfully.
2023-10-02T06:20:39.556Z | INFO | Directory /u02/Deployment/var/lib/credential was created successfully.
2023-10-02T06:20:39.556Z | INFO | Directory /u02/Deployment/var/lib/credential/secureStore was created successfully.
2023-10-02T06:20:39.556Z | INFO | Directory /u02/Deployment/var/lock was created successfully.
2023-10-02T06:20:39.563Z | INFO | Directory /u02/Deployment/var/log was created successfully.
2023-10-02T06:20:39.563Z | INFO | Info: directory /u02/Deployment/var/run already exists.
2023-10-02T06:20:39.563Z | INFO | Directory /u02/Deployment/var/run/BR was created successfully.
2023-10-02T06:20:39.563Z | INFO | Info: directory /u02/Deployment/var/temp already exists.
2023-10-02T06:20:39.564Z | INFO |
2023-10-02T06:20:39.564Z | INFO | Finished creating directories (0 errors).
2023-10-02T06:20:39.564Z | INFO |
2023-10-02T06:20:39.564Z | INFO |
2023-10-02T06:20:39.566Z | INFO | File created: '/u02/Deployment/etc/conf/ogg/GLOBALS'
2023-10-02T06:20:39.566Z | INFO | Setting file permissions on /u02/Deployment/etc/conf/ogg/GLOBALS
2023-10-02T06:20:39.567Z | INFO |
2023-10-02T06:20:39.567Z | INFO | Step 2: Import admin user.
2023-10-02T06:20:39.568Z | INFO | JSON payload:
{"ggadmin": {
"credential": "********",
"roles": ["Security"],
"type": "Basic",
"info": ""
}}
2023-10-02T06:20:39.568Z | INFO | Command: /u01/ogg/bin/pmsrvr --import-users=/u02/Deployment/var/temp/tmp_user.json --exit
2023-10-02T06:20:39.569Z | INFO | Setting child process environment variable OGG_VAR_HOME to /u02/Deployment/var
2023-10-02T06:20:39.569Z | INFO | Setting child process environment variable OGG_ETC_HOME to /u02/Deployment/etc
2023-10-02T06:20:39.569Z | INFO | Setting child process environment variable TNS_ADMIN to /u02/Deployment/etc
2023-10-02T06:20:39.599Z | INFO | Waiting for the process to finish...
2023-10-02T06:20:39.700Z | INFO | Successfully imported 1 users.
2023-10-02T06:20:39.703Z | INFO | exiting...
2023-10-02T06:20:39.704Z | INFO | Process exit value: 1
2023-10-02T06:20:39.704Z | INFO |
2023-10-02T06:20:39.705Z | INFO |
2023-10-02T06:20:39.705Z | INFO | Step 3: Using an existing ServiceManager (127.0.0.1:9011).
2023-10-02T06:20:39.705Z | INFO |
2023-10-02T06:20:39.705Z | INFO | Step 4: Create Deployment.
2023-10-02T06:20:39.706Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for '/services/v2/deployments/Local'
2023-10-02T06:20:39.706Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:39.778Z | INFO |
2023-10-02T06:20:39.778Z | INFO | Step 5: Create all SCA services.
2023-10-02T06:20:39.779Z | INFO | Connecting to ServiceManager, PATCH request to: http://127.0.0.1:9011/services/v2/deployments/Local
2023-10-02T06:20:39.779Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:39.779Z | INFO | JSON payload:
{"environment":[{"name":"TNS_ADMIN","value":"/u02/Deployment/etc"}]}
2023-10-02T06:20:39.797Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/adminsrvr'
2023-10-02T06:20:39.797Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:39.819Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/distsrvr'
2023-10-02T06:20:39.819Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:39.866Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/recvsrvr'
2023-10-02T06:20:39.866Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:40.002Z | INFO | Connecting to ServiceManager at http://127.0.0.1:9011 to issue a POST request for service '/services/v2/deployments/Local/services/pmsrvr'
2023-10-02T06:20:40.002Z | INFO | Auth user: 'ggadmin'
2023-10-02T06:20:40.130Z | INFO | Executing target DB-specific post deployment creation tasks.
2023-10-02T06:20:40.131Z | INFO | Nothing to be done for 'Oracle'.
2023-10-02T06:20:40.131Z | INFO | Deployment (Local) creation succeeded.
2023-10-02T06:20:40.131Z | INFO | ALL DONE (0 errors).
get_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/adminsrvr
set_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/adminsrvr
get_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/distsrvr
set_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/distsrvr
get_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/recvsrvr
set_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/recvsrvr
get_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/pmsrvr
set_service_config: http://127.0.0.1:9011/services/v2/deployments/Local/services/pmsrvr
2023-10-02T06:20:45.694+0000 INFO | Restarted service 'distsrvr' in deployment 'Local' (Thread 5)
2023-10-02T06:20:45.706+0000 INFO | Task 'Local:distsrvr' started with process id 314 (Local:distsrvr)
2023-10-02T06:20:45.724+0000 INFO | Stopping service 'recvsrvr' in deployment 'Local' (Thread 7)
2023-10-02T06:20:46.952+0000 INFO | Stopped service 'recvsrvr' in deployment 'Local' (Thread 7)
2023-10-02T06:20:46.952+0000 INFO | Restarted service 'recvsrvr' in deployment 'Local' (Thread 7)
2023-10-02T06:20:46.960+0000 INFO | Task 'Local:recvsrvr' started with process id 377 (Local:recvsrvr)
2023-10-02T06:20:46.980+0000 INFO | Stopping service 'pmsrvr' in deployment 'Local' (Thread 4)
2023-10-02T06:20:47.641+0000 INFO | Stopped service 'pmsrvr' in deployment 'Local' (Thread 4)
2023-10-02T06:20:47.641+0000 INFO | Restarted service 'pmsrvr' in deployment 'Local' (Thread 4)
2023-10-02T06:20:47.641+0000 INFO | Task 'Local:pmsrvr' started with process id 414 (Local:pmsrvr)
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful
OGG_DEPLOYMENT=Local
OGGF_DEPLOYMENT_ID=a7cb79db-e4e0-43a8-b2e0-612766eef12b
OGG_SERVERCERT=/u02/oggf/certificate/server.pem
2023-10-02T06:20:55+0000 INFO: *****************************************************************************************
2023-10-02T06:20:55+0000 INFO: ** Firing up service
2023-10-02T06:20:55+0000 INFO: *****************************************************************************************
OGGF_API_SERVER_PORT=8080
OGGF_API_SERVER_SPORT=8080
OGGF_DEPLOYMENT_ID=a7cb79db-e4e0-43a8-b2e0-612766eef12b
OGGF_SECURE=
OGGF_SERVER_CRT=
OGGF_SERVER_KEY=
OGGF_SIGN_JWK=
OGGF_VERIFY_JWK=
OGGF_SERVER_CRT_P12=
OGGF_UTIL_BIN=/usr/local/bin
OGGF_VERSION=23.3.0.16
OGG_DEPLOYMENT=Local
OGG_DOMAIN=OGG23c
OGG_DEPLOYMENT_HOME=/u02
OGG_SECURE_DEPLOYMENT=false
OGG_HOST=
OGG_SERVICE_MANAGER_PORT=
OGG_ADMIN_SERVER_PORT=
OGG_DISTRIBUTION_SERVER_PORT=
OGG_RECEIVER_SERVER_PORT=
OGG_METRIC_SERVER_PORT=
OGGF_USE_DAEMON=
OGGF_LOAD_SAMPLES=
OGGF_SERVICE=
----- Prepare --------
java version "17" 2021-09-14 LTS
Java(TM) SE Runtime Environment (build 17+35-LTS-2724)
Java HotSpot(TM) 64-Bit Server VM (build 17+35-LTS-2724, mixed mode, sharing)
Using existing service zip in /u01/oggf
JAVA_HOME=/usr/java/jdk-17
OGGF_API_SERVER_URL:8690bfe003db/oggfServices
OGGF_API_SERVER_SSL_URL:8690bfe003db/oggfServices
OGGF_DEPLOYMENT_ID=a7cb79db-e4e0-43a8-b2e0-612766eef12b
OGGF_KEY_STORE=/u02/oggf/config/ggfe.p12
Generating password key
Generating JWK Keys
key is written to : /u02/oggf/config/sign-jwk.json
publicKey is written to : /u02/oggf/config/verify-jwk.json
Using /u02/oggf/config/ggfe.p12
/u02/oggf/config/ggfe.p12 does not exist. Generating Key Store
Oct 02, 2023 6:20:56 AM oracle.cloud.ggfe.security.SecureKeyStore createKeyStore
INFO: /u02/oggf/config/ggfe.p12 created
OGGF_KEY_STORE=/u02/oggf/config/ggfe.p12
Creating Default Local Connections
Local Connections - /u02/oggf/local-connections.json
2023-10-02T06:20:58+0000 INFO: <== preStartup: Starting
2023-10-02T06:20:58+0000 INFO: ==> preStartup: Finished
Linux 8690bfe003db 5.4.17-2011.1.2.el8uek.x86_64 #2 SMP Mon Apr 20 22:10:46 PDT 2020 x86_64 x86_64 x86_64 GNU/Linux
{
"runtime": {
"majorVersion": "11"
},
"release": {
"build": "master",
"commit": "228b43c9",
"version": "23.3.0.16",
"buildTime": "2023-09-16 07:48"
},
"command": "sh bin/startup.sh",
"startupTime": "120",
"notes": "Java server api-server",
"mode": "rolling"
}
2023-10-02T06:20:58+0000 INFO: <== startup: Starting
2023-10-02T06:20:58+0000 INFO: startup: Launching Java process
JAVA_PROPERTIES=-XX:+ExitOnOutOfMemoryError -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/u02/oggf/oggf-oom-dump.hprof -Dggfe.conf=/u02/oggf/config/ggfe.conf -Dsecurity.conf=/u02/oggf/config/security.conf -Djava.net.preferIPv4Stack=true -Djava.security.egd=file:/dev/./urandom -Djavax.xml.parsers.SAXParserFactory=com.sun.org.apache.xerces.internal.jaxp.SAXParserFactoryImpl -Dhelidon.serialFilter.pattern=oracle.sql.converter.* -Djava.util.logging.config.file=/u02/oggf/config/logging.properties -Dmp.jwt.verify.publickey.location=file:///u02/oggf/config/verify-jwk.json -DOGGF_VERSION=23.3.0.16 -DAPP_HOME=/u01/oggf -DAPP_DATA_HOME=/u02/oggf -DoggfApiServerUrl=8690bfe003db/oggfServices -DdeploymentId=a7cb79db-e4e0-43a8-b2e0-612766eef12b -DoggfDomain=8690bfe003db -DsecureKeyStorePath=/u02/oggf/config/ggfe.p12
ARGS=
2023-10-02T06:20:58+0000 INFO: startup: Launched java class PID 599
2023-10-02T06:20:58+0000 INFO: ==> startup: Finished
2023-10-02T06:20:58+0000 INFO: <== postStartup: Starting
2023-10-02T06:20:58+0000 INFO: ==> postStartup: Finished
2023-10-02T06:20:58+0000 INFO: *****************************************************************************************
2023-10-02T06:20:58+0000 INFO: ** Finished all startup steps for service
2023-10-02T06:20:58+0000 INFO: *****************************************************************************************
This is a idle script (infinite loop) to keep container running.
2023.10.02 06:20:59 INFO oracle.cloud.ggfe.mds.bdb.BdbStorage Thread[main,5,main]: Storage : /u02/oggf/storage
2023.10.02 06:21:00 INFO oracle.cloud.ggfe.model.tool.SampleGenerator Thread[main,5,main]: 2 connections to populate from /u02/oggf/local-connections.json
2023.10.02 06:21:00 INFO oracle.cloud.ggfe.model.tool.SampleGenerator Thread[main,5,main]: 0 old connections
2023.10.02 06:21:00 INFO oracle.cloud.ggfe.model.tool.SampleGenerator Thread[main,5,main]: create connection:
...
...
...
From a web browser we can now connect to the GoldenGate 23c web console UI using the link below – the IP address is the IP address of my Oracle Virtual Box Linux 8 host – or we can just use “localhost:8080” instead to launch the web console.
https://192.168.56.200/oggf/index.html
In the next post we shall get to learn about some new GoldenGate 23c concepts like Recipes and Pipelines and we will see how the new Connection builder works when we create a GoldenGate connection to the Oracle 23c Developer Free Release database.
