Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Upgrade Goldengate 21c to 23ai

cptkirkshJan 23 2025

So I went through the upgrade steps on my 21c box. I have no extracts or replicats running at this time. the install was successful. I went into my GUI on 21c and changed the GG home path just like it says here. This is a secure deployment with ngnix as a reverse proxy. Well it seems I can't get the GUI to come back up and work properly. Here is the link to how to upgrade.

https://docs.oracle.com/en/middleware/goldengate/core/23/coredoc/upgrading-oracle-goldengate-microservices-gui-oracle-database-1.html

If you notice is that there is and error that sticks out. SecureStore failed on open with error. I even disabled the nginx reverse proxy and tired just using the ports and it can't bring up the GUI. What else can I look at? I even put in a SR with Oracle and we all know that could take a while. Any idea where to look?

2025-01-22T16:34:41.814-0600 INFO | Loading deployment inventory from '/u01/app/oracle/product/ogg21c_sm/etc/conf/deploymentRegistry.dat' (main)
2025-01-22T16:34:41.814-0600 INFO | Loading configuration '/u01/app/oracle/product/ogg21c_sm/etc/conf/deploymentConfiguration.dat' (main)
2025-01-22T16:34:41.814-0600 INFO | Service logging already initialized (main)
2025-01-22T16:34:41.814-0600 ERROR| Configuration does not contain a 'config/network' specification. (ServiceManager.Topology)
2025-01-22T16:34:41.814-0600 INFO | Installation topology updated (ServiceManager.Topology)
2025-01-22T16:34:41.884-0600 INFO | Non-FIPS mode. (main)
2025-01-22T16:34:41.885-0600 WARN | Certificate Events server not available (main)
2025-01-22T16:34:41.885-0600 WARN | Certificate Events server not available (main)
2025-01-22T16:34:41.887-0600 INFO | Installation topology updated (ServiceManager.Topology)
2025-01-22T16:34:42.026-0600 ERROR| SecureStore failed on open with error: Cannot import PKCS #12 wallet (Error NZE-29106). (main)
2025-01-22T16:34:42.026-0600 ERROR| Failed to open '{1}' storage 4 (Operation or action failed) (main)
2025-01-22T16:34:42.026-0600 INFO | Changed process umask from 0022 to 0027 (main)
2025-01-22T16:34:42.026-0600 INFO | Oracle GoldenGate Service Manager for Oracle (main)
2025-01-22T16:34:42.026-0600 INFO | Version 23.4.1.24.05 OGGCORE_23.4.0.0.0OGGR_LINUX.X64_240529.0500_FBO (main)
2025-01-22T16:34:42.026-0600 INFO | Copyright (C) 1995, 2024, Oracle and/or its affiliates. All rights reserved. (main)
2025-01-22T16:34:42.026-0600 INFO | Linux, x64, 64bit (optimized) on May 29 2024 09:22:42 (main)
2025-01-22T16:34:42.026-0600 INFO | Operating system character set identified as UTF-8. (main)
2025-01-22T16:34:42.159-0600 INFO | Service Manager listening on port 7000 (main)
2025-01-22T16:34:42.168-0600 INFO | OGG Inventory loaded (main)
2025-01-22T16:34:42.168-0600 INFO | Deployment: 'ServiceManager' (main)
2025-01-22T16:34:42.168-0600 INFO | - Enabled:   true (main)
2025-01-22T16:34:42.168-0600 INFO | - Home:     '/u01/app/oracle/product/ogg23ai_ma' (main)
2025-01-22T16:34:42.169-0600 INFO | - Binaries: '/u01/app/oracle/product/ogg23ai_ma/bin' (main)
2025-01-22T16:34:42.169-0600 INFO | - Etc:      '/u01/app/oracle/product/ogg21c_sm/etc' (main)
2025-01-22T16:34:42.169-0600 INFO | - Conf:     '/u01/app/oracle/product/ogg21c_sm/etc/conf' (main)
2025-01-22T16:34:42.169-0600 INFO | - SSL:      '/u01/app/oracle/product/ogg21c_sm/etc/ssl' (main)
2025-01-22T16:34:42.169-0600 INFO | - Variable: '/u01/app/oracle/product/ogg21c_sm/var' (main)
2025-01-22T16:34:42.169-0600 INFO | - Data:     '/u01/app/oracle/product/ogg21c_sm/var/lib/data' (main)
2025-01-22T16:34:42.169-0600 INFO | - Service:    'ServiceManager' (main)
2025-01-22T16:34:42.169-0600 INFO | --- Locked:    false (main)
2025-01-22T16:34:42.169-0600 INFO | --- Enabled:   true (main)
2025-01-22T16:34:42.177-0600 INFO | --- Status:    running (main)
2025-01-22T16:34:42.177-0600 INFO | --- Quiet:     false (main)
2025-01-22T16:34:42.177-0600 INFO | --- Config:    {
                                        "network": {
                                            "serviceListeningPort": {
                                                "address": "127.0.0.1",
                                                "port": 7000
                                            },
                                            "ipACL": [
                                                {
                                                    "permission": "allow",
                                                    "address": "ANY"
                                                }
                                            ]
                                        },
                                        "legacyProtocolEnabled": false,
                                        "asynchronousOperationEnabled": true,
                                        "defaultSynchronousWait": 30,
                                        "workerThreadCount": 5,
                                        "taskManagerEnabled": true,
                                        "csrfTokenProtectionEnabled": true,
                                        "csrfHeaderProtectionEnabled": false,
                                        "authorizationDetails": {
                                            "sessionDurationSecs": 3600,
                                            "useMovingExpirationWindow": false,
                                            "movingExpirationWindowSecs": 900,
                                            "common": {
                                                "allow": [
                                                    "Digest",
                                                    "x-Cert"
                                                ],
                                                "customAuthorizationEnabled": true
                                            }
                                        },
                                        "securityDetails": {
                                            "network": {
                                                "common": {
                                                    "id": "OracleSSL",
                                                    "fipsEnabled": false
                                                },
                                                "inbound": {
                                                    "role": "server",
                                                    "authMode": "clientOptional_server",
                                                    "cipherSuites": "^((?!anon|RC4|NULL|3DES).)*$",
                                                    "crlEnabled": false,
                                                    "certACL": [
                                                        {
                                                            "permission": "allow",
                                                            "name": "ANY"
                                                        }
                                                    ],
                                                    "sessionCacheEnabled": false,
                                                    "sessionCacheDetails": {
                                                        "limit": 20480,
                                                        "timeoutSecs": 1800
                                                    }
                                                },
                                                "outbound": {
                                                    "role": "client",
                                                    "authMode": "client_server",
                                                    "cipherSuites": "^.*$",
                                                    "crlEnabled": false,
                                                    "sessionCacheEnabled": false
                                                }
                                            }
                                        },
                                        "hstsEnabled": true,
                                        "hstsDetails": "max-age=31536000;includeSubDomains"
                                    } (main)
2025-01-22T16:34:52.762-0600 INFO | Cryptographic hardware acceleration has been ENABLED. (Thread 4)
2025-01-22T16:34:52.765-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:34:52.765-0600 INFO | Communications security FIPS mode disabled. (Thread 4)
2025-01-22T16:34:52.765-0600 INFO | Initialized non-FIPS-140 mode. (Thread 4)
2025-01-22T16:34:52.838-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:34:52.838-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:34:52.895-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:34:52.895-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:34:52.895-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:34:57.203-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:34:57.203-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:34:57.203-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:34:57.292-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:34:57.292-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:34:57.292-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:35:00.141-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:35:00.141-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:35:00.141-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:35:00.230-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:35:00.230-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:35:00.230-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:39.017-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:39.017-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:39.017-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:39.017-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:39.017-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:39.017-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:39.678-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:39.678-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:39.678-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:39.678-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:39.678-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:39.678-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:39.678-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:39.678-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:39.678-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:39.678-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:39.678-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:39.678-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:39.678-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:39.678-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:39.678-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:39.745-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:39.745-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:39.745-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:40.788-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:40.788-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:40.788-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:40.789-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:40.789-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:40.789-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:40.792-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:40.792-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:40.792-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:40.793-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:40.793-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:40.793-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:40.803-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:40.803-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:40.803-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:40.812-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:40.812-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:40.812-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:41.840-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:41.840-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:41.840-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:41.840-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:41.840-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:41.840-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:41.840-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:41.840-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:41.840-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:41.840-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:41.840-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:41.840-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:41.865-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:41.865-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:41.865-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:41.868-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:41.868-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:41.868-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:46.863-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:46.863-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:46.863-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:46.864-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:46.864-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:46.864-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:46.869-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:46.869-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:46.869-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:46.884-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:46.884-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:46.884-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:46.884-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:46.884-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:46.884-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:47.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:47.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:47.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:47.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:47.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:47.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:47.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:47.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:47.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:47.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:47.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:47.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:52.952-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:52.952-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:52.952-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:52.952-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:52.952-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:52.952-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:52.952-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:52.952-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:52.952-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)
2025-01-22T16:36:52.952-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 7)
2025-01-22T16:36:52.952-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 7)
2025-01-22T16:36:52.952-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 7)
2025-01-22T16:36:57.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 5)
2025-01-22T16:36:57.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 5)
2025-01-22T16:36:57.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 5)
2025-01-22T16:36:57.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 8)
2025-01-22T16:36:57.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 8)
2025-01-22T16:36:57.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 8)
2025-01-22T16:36:57.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 4)
2025-01-22T16:36:57.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 4)
2025-01-22T16:36:57.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 4)
2025-01-22T16:36:57.888-0600 INFO | SSL Session internal session cache capacity set to: 20480 (Thread 6)
2025-01-22T16:36:57.888-0600 ERROR| The value for the wallet resource locator was not specified. (Thread 6)
2025-01-22T16:36:57.888-0600 ERROR| Handling FncIdNew - context initialization failed (Thread 6)

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Jan 23 2025
3 comments
148 views