Release Notes for Oracle GoldenGate for HP NonStop (Guardian)

This document contains the release notes for the 26ai releases of Oracle GoldenGate for HP NonStop on the Guardian platform. You can find additional information about the parameters and options described in these release notes in the Reference Guide for Oracle GoldenGate for HP NonStop (Guardian). This product is for the support of Enscribe and SQL/MP, it does not support SQL/MX.

Critical Security Updates

This chapter describes the Critical Security Fixes done in Oracle GoldenGate for HP NonStop (Guardian). Oracle updates the release notes periodically after the software release. This document is accurate at the time of publication.

Critical Security Updates 26ai (23.26.3.0.0) - August 2026

Oracle recommends upgrading to this patch as it has critical security bug fixes.

Critical Security Updates 26ai (23.26.2.1.0) - July 2026

Oracle recommends upgrading to this patch as it has critical security bug fixes.

New Release 23.4.0.0.0 - June 2024

This release contains several new features, some of which cause functional changes and possibly require parameter modification depending on the version you are currently using. Therefore, Oracle recommends that you investigate the enhancements noted here as well as the Reference Guide for Oracle GoldenGate for HP NonStop (Guardian) and the Fusion Middleware Administering Oracle GoldenGate for HP NonStop (Guardian), for more information. If you have questions, then you can also open a service request (SR) with Oracle support to resolve any issues that might affect your specific product usage.

This section outlines the new features that are being introduced in this release and includes the following:

New Parameters

This section lists the parameters that have been added for this release. Consult the reference manual for full details:

Parameter Changes

This section explains the parameter changes that are included in this release.

Release 23.26.2.1.0 - July 2026

GGSCI commands for INFO and STATUS on EXTTRAIL or RMTTRAIL can be filtered by wildcard or group.

INFO EXTTRAIL trail spec [,GROUP group spec]

INFO RMTTRAIL trail spec [,GROUP group spec]

STATUS EXTTRAIL trail spec [,GROUP group spec]

STATUS RMTTRAIL trail spec [,GROUP group spec]

Release 23.4.0.0.3 - June 2025

Deprecated Parameters and Programs

This section explains the deprecated parameters and programs in release.

TNS mode objects for Extract and Replicat have been deprecated and de-supported. If you have coded your own user exits, then you will be required to recompile them in Native mode.

For those using the Oracle® GoldenGate Application Adapters for BASE24, native mode objects are provided as part of that download found only on OTN.

Note: The T24 User Exit has been deprecated, see the Reference Guide for Oracle GoldenGate for HP NonStop (Guardian) for using @GETTLFTOKEN.

BlowFish for encryption over TCP/IP and encrypting passwords has been deprecated and de-supported. For encryption over TCP/IP, see the Encrypt option of RMTHOST in the Reference Guide for Oracle GoldenGate for HP NonStop (Guardian) as well as Using Encryption in the Administering Oracle GoldenGate for HP NonStop (Guardian Data Sources). For encrypted passwords used with the LOGON parameter, passwords must be regenerated from GGSCI, which will now automatically be AES.

ATCONFIG for TMF recovery has been deprecated and de-supported.

SizeRemoteFiles has been deprecated and removed.

The Extract feature of RMTBATCH has been deprecated.

Using Default as an option value for the encryption parameter KeyName/EncryptKey has been deprecated.

Release 23.26.1.0.0 - December 2025

Note: HPE has announced July 2025 as the end of support for Nonstop Itanium J06. In conjunction with this announcement, Oracle GoldenGate will provide only sustaining support for the Nonstop Itanium J06 platform as of July 2025.

Patches after this date can be obtained only by special requests to product management.

Program Changes

This section explains the general changes that are included in this release.

Added support for volume names up to 7 bytes. This allows for the product to be installed on a long-named volume as well as write trails. However this can only be done for Enscribe based usage, SQL/MP does not support this feature.

Release 23.4.0.0.3 - June 2025

When processing Enscribe files and using Dictionary and DEF to access column details for mapping, the use of EXPANDDDL could now be mandatory with options of EXPANDGROUPARRAYS or RESOLVEDUPGROUP, in addition to the possibility of adding a group level name to a map. This change is because of the correction for bug 37530173. Any need for these changes would be seen when a mapped column name is no longer found.

This is not expected to affect most installations.

Installation and Upgrades

The installation file downloaded from Oracle is a standard compressed file.

Upgrade Process

The instructions for installation and upgrading are documented by release version at https://docs.oracle.com/en/middleware/goldengate/non-stop/index.html

Installation Instructions Changes

Oracle recommends to perform installs or upgrades of any Oracle GoldenGate version to the target system before the source.

As a best practice before any install check the currently posted release notes for patch numbers and version information. Alternatively check My Oracle Support (MOS), Patches and Upgrades to see if any patches are available for the requested release.

If there are no available patches, the user is directed to https://edelivery.oracle.com.

Corrected Problems and Enhancements

For questions on specific bugs or ticket numbers, consult Oracle Customer Support. BugDB is the bug identification number. You can obtain Patches from the My Oracle Support site or you can contact support by opening an SR to obtain the current patch.

Release 23.26.3.0.0 - August 2026

Patch 39872182 NSK: Oracle GoldenGate NSK v23.26.3.0.0 ON HP NONSTOP

Bug 39931083 NSK: Fix memory overwrite related to ansinames Corrected a buffer overwrite while processing OpenSys ANSI names possibly causing an Error in COLMAP clause. Column name not found.

Bug 39883046 NSK: Duplicate Def in SourceDefs cause calc with ptrdiff_t() against files to give bad result Corrected a problem that can cause an Error -1 Retrieving attributes for Source file when a duplicate definition exists in a SourceDef.

Bug 39837315 NSK: Expose hidden _GETSQLPARTONLYPURGEDATAS Added parameter GETSQLPARTONLYPURGEDATAS to Extract without requiring the use of AUDSERVPARAM.

Bug 39661737 NSK: Cleanup Extract excludes of altfiles Corrected a problem that could cause ALTFILES to be Extracted or Extract to Abend if not using NOALTFILERESOLVE.

Bug 39825719 NSK: Replicat errors on long ANSI names from OpenSys mapped to SQL/MP Corrected bounds check on column names when source was OpenSys that was mapped to a SQL/MP target.

Bug 37950797 NSK: new ggsci commands for veriagt Added GGSCI commands to access Veridata reports.

Release 23.26.2.1.0 — July 2026

Patch 39563416 NSK: Oracle GoldenGate NSK v23.26.2.1.0 ON HP NONSTOP

Bug 38006346 NSK: Syncfile does not bounds check hh:mn:ss values. Corrected parsing of hours/minutes/seconds values for event time.

Bug 38044795 NSK: Initial data load error. Corrected Extract from receiving error “Unknown data type received [TI]” when configured for RMTTASK and no files are resolved from a wildcard.

Bug 38656224 NSK: Add Wildcard Filtering in GGSCI STATUS RMTTRAIL Command. Added the ability to filter results for GGSCI commands info and status against EXTTRAILs and RMTTRAILs.

Bug 38750501 NSK: GGSCI abends with a dup key error. Corrected a possible error 10 (duplicate) on the EXTCTXT file causing GGSCI to trap when having added an EXTTRAIL with the option “exists”.

Bug 38750589 NSK: Saved CSN gets truncated. Corrected the display in the Replicat report to show the full CSN.

Bug 38799138 NSK: GGSCI parsing bug in logparm. Corrected GGSCI from trapping if LOGPARM uses the option “PROCESS” without specifying a name.

Bug 39022033 NSK: Update MIRGRATE to handle second execution after failure, Alter Audit. Corrected the Migrate macro to correctly alter checkpoint files to Audited; when/if run more than once after recovering from a prior error.

Bug 39156522 NSK: Audserv needs to exempt REPCTXT from the security check. Added the REPCTXT file to the list of those excluded from security read checks when multiple installs exist on the same node have differing file permissions or ownership.

Bug 39173322 NSK: Bounds check the use of USEREXITNAMEMAP option along with the User Exit using SET_TARGET_FILENAME_EXTERNAL(). Added a clear error message for an unsupported combination of parameters and usage when SET_TARGET_FILENAME_EXTERNAL() is used from a User Exit to set an ANSI name.

Bug 39428097 NSK: RepError Exception with no exception map defaults to discard, not abend. Corrected Replicat from using a default RepError option of “Discard” when the option specified was “Exception”, but no ExceptionMap was provided.

Bug 39428291 NSK: Replicat primary key update. Corrected Replicat from attempting to format a primary key update causing the warning “no columns specified for update”. This will occur when a duplicate insert on a SQL/MP table is attempted where all columns are keys and Handle Collisions was in used.

Bug 39431236 NSK: Replicat traps when using SpecialRun and it expects to wait on a trail. Corrected Replicat from a possible trap when running a SpecialRun process and the expected trail seqno does not yet exist.

Bug 39472872 NSK: Server remove GGSKEY Changed to deprecate the “Default” KeyName for AES Encryption.

Bug 39522368 NSK: Fix Replicat abend on a repaired record. Corrected a Replicat abend while trying to interrogate the contents of a repaired record that should be ignored.

Bug 39541786 NSK:Audserv fix if tests dealing with getpartonlypurgedata. Corrected Audserv to test if DDL operations for getpartonlypurgedata and getsqlpartonlypurgedata should be captured.

Release 23.26.1.0.1 - March 2026

Patch 39066006 Oracle GoldenGate NSK 23.26.1.0.1 ON HP NonStop

Bug 39047674 NSK: CPU-bound loops due to unexpected I/O responses during process startup. Corrected a programming error in the Baselib/GGSLIB intercepts that caused the users program to loop.

Bug 38977508 NSK: Fix SSID in GGSEMS Corrected the SSID value for EMS on LO6 OS from Baselib.

Release 23.26.1.0.0 - January 2026

Patch 38727982 Oracle GoldenGate NSK 23.26.1.0.0 ON HP NonStop

Bug 38759696 NSK: Replicat abends with SQL error -4052 preparing statement Corrected key columns when a Replicat uses SourceDefs, but those are ignored for metadata in trail.

Bug 38759624 NSK: Correct dynamic allocation size of the files list Corrected Replicat from corrupting memory when over 500 files (source/target) are added with large DDL records and are not aged off over time.

Bug 37069878 NSK: LogDump fix SQL format display Corrected the display of SQL table metadata details in LogDump.

Bug 37857037 NSK: Fix TDR display issue Corrected Logdump displaying TDR formats greater than 2.

Bug 38641084 NSK: LogDump trap on REFTDR Corrected Logdump from trapping when reading a REFTDR record that referred to a prior TDR for the same table.

Bug 38313004 NSK: Fix truncated reply from GETARFILESTATS Corrected messages between Audserv and Extract when processing the GGSCI command GETARFILESTATS.

Bug 38327046 NSK: Fix keycols when extracting from a view Corrected Extracts key columns when extracting a view and the column count and or column order are different from the base table.

Bug 38495418 NSK: Correct filterview logic from requiring contiguous key columns Corrected Extract from writing no op (key only) updates to the trail when key columns are not contiguous.

Bug 38280361 NSK: Fix heap corruption in FormatXML Corrected the memory size allocation in Extract to perform output FomatXML.

Bug 38307226 NSK: Missing target file warning target not audited Corrected Replicat from displaying a premature warning message for “Audit Check” on a missing file before it’s actually a problem.

Bug 38528871 NSK: Correct baselib intercepts from trying to log #temp files Corrected Baselib from trying to intercept temporary #disk files, causing a runtime error 34 from FILENAME_FINDSTART_().

Bug 38043710 NSK:error 0 purging discard file Corrected the reporting of an error when attempting to purge the discard file.

Bug 38517275 NSK: Correct memory allocation on Enscribe DDL record, not file rec len Corrected Extract from abending with *** Run-time Error 002 ***, Illegal address reference. Changed to use the size allocation for default mapping to the larger of either a TargetDef or the File record length.

Bug 38567933 NSK: Remove use of Setmode 141 Removed the use of Setmode 141 when opening a target file for unstructured writes (BulkIO). This is no longer required and can cause issues when executing writes that do not start on 2K boundary.

Bug 38100794 NSK: Replicat prepare statement error Corrected Replicat to output a more detailed error message when target SQL/MP table expected columns do not exist.

Bug 38495593 NSK: Change the FILE_COMPLETExx functions Enhanced the Baselib intercept to handle the condition when the Users programs is calling the various FILE_COMPLETE and FILE_AWAITIO64 functions with -1 for the file number instead of their own openers.

Bug 38682036 NSK: Fix @GETNEV(“TLFKEY” for 64-bit Syskeys Corrected the @getenv() option TLFKEY to handle Format 2 files larger Syskey size.

Bug 38673089 NSK: Server detect and reject little endian trails Corrected the Server Collector to throw an error reply to OpenSys Extracts when sending trails in Little Endian format.

Release 23.4.0.0.4 - August 2025

Patch 38267939 NSK: Oracle GoldenGate NSK 23.4.0.0.4 ON HP NonStop

Bug 38294973 NSK: Replicat abends with CREATEUSINGTARGETUSERID clause was already specified Corrected Replicat, when using the option CREATEUSINGTARGETUSERID in two separate statements, causes the error already specified.

Bug 38253456 NSK: Handle OpenSys CSNs, current size too small Corrected a trap in Extract and Replicat with an EMS message of: Run time Error 034, Released space not allocated. This can occur when processing an OpenSys trail with large CSNs.

Bug 37990307 NSK: Fix dynamic port field overflow in remoteaddress Corrected memory corruption in manager caused by DNS hostnames over 64 bytes.

Bug 38212367 NSK: Syncfile abends with error 74 on $RECEIVE Corrected Syncfile to handle cancel requests from TACL or FUP.

Bug 38177171 NSK: Correct lost error message detail on bad @function() syntax Corrected Extract, Replicat from not reporting some error message details on bad syntax using function calls.

Release 23.4.0.0.3 - June 2025

Patch 37967883 - ORACLE GOLDENGATE NSK v23.4.0.0.3 ON HP NONSTOP

Bug 36105785 NSK: Allow Extract to output metadata based on output file not mapped when name changed by User Exit Added the option USEREXITNAMEMAP() to the parameter FILE. This is to allow for the accurate metadata and file name to be written to the trail when a User Exit changes the output name for a source Enscribe file.

Bug 36096576 NSK: Deprecate Extract/DEFGEN FORMAT RELEASE less than 12.1 (keeping DEFGEN 9.0) Deprecate Extracts ability to over write trails in favor of Rollover recovery. Deprecate DEFGEN FORMAT RELEASE to match that of Extract.

Using FORMAT RELEASE 9.0 with DEFGEN is only for use with the D24 User Exit.

Bug 37927350 NSK: Extract pump traps adding User Tokens after table attribute refresh Corrected an Extract pump from trapping on maps with user tokens after a table attribute refresh. This can be caused by alter table add column.

Bug 37509550 NSK: Fix large def with RMTTASK Corrected Extract from receiving an error when sending a large metadata TDR record to a RMTTASK Replicat.

Bug 37530173 NSK: Extract and DEFGEN output on elementary fields with occurs Corrected the value of level when a elementary item with an occurs is indexed, causing name expansion.

Bug 37598965 NSK: Fix trap in ENCRYPTC Corrected Extract and Replicat from trapping when the ENCKEYS file was missing along with using either ENCRYPTTRAIL or DECRYPTTRAIL.

Bug 37767902 NSK: Extract abends: ARLIB error get_audit_rec_image, Exceeded OPEN retry limit for audit file in dump location Corrected how Extract/AUDSERV look for the next seqno when this file exists on a TMF dump volume.

Bug 37822150 NSK: Replicat needs to warn about REPCTXT not audited Changed Replicat to add bounds check on status of the REPCTXT file when data corruption is possible.

Bug 37693266 NSK: Syncfile support for FUP QUALEXPR Add support for FUP QUALEXPR on DUP commands to allow for FUP level filtering.

Bug 36821615 NSK: Extract rollover recovery changes Corrected how Extract and Server Collector handle gaps in seqno’s during trail recovery.

Bug 37945103 NSK: Deprecate REFRESH MGR command from GGSCI Deprecated the refresh command in favor of stopping and restarting the Manager process for adding, changing, or removing Manager parameters.

Bug 37950675 NSK: Fix migrate bug. Corrected migrate from improper syntax error:

[#if [#fileinfo /opennow/ .$
Expecting a valid filename

Bug 37956798 NSK: Fix Manager not cleaning up old pump checkpoints Corrected the manager back worker process to clean up old checkpoints in REPCTXT for Extract pumps.

Release 23.4.0.0.2 - February 2025

Patch 37889311 Oracle GoldenGate Veridata 23.3.0.0.0 C Agent for HP NonStop

The release 23.4.0.0.2 was for the NSK C agent of Oracle GoldenGate Veridata for HP Nonstop.

Release 23.4.0.0.1 - February 2025

Patch 37458675 - ORACLE GOLDENGATE NSK v23.4.0.0.1 ON HP NONSTOP

Bug 32977962 NSK: GGSCI needs to filter out remotecheckpoints to the local node. Corrected GGSCI to not add local checkpoint records during ADD REMOTECHKPT command.

Bug 36515232 NSK: Deprecate [No]SizeRemoteFiles. Deprecated and removed the Extract param SizeRemoteFiles.

Bug 36569543 NSK: Handle ansinames where only a portion is quoted. Corrected the format for ansinames in a parameter file when quotes are required.

Bug 36730425 NSK: Trail with purgedata has no TDR from TMF Extract. Corrected Extract to write a TDR metadata record to OpenSys when source was TMF for PURGEDATA.

Bug 36820999 /34744267: EXTRACT NSK:propogate URI HISTORY in a pump. Changed Extract to update the fileheader URI History value with producer info.

Bug 36874975 NSK: Partonly Purgedata on non-partitioned files. Corrected AUDSERV to output record type PURGEDATA on non-partitioned Enscribe files when Extract is using GETPARTONLYPURGEDATAS.

Bug 36912483 NSK: need to send purgedata ops thru the userexit. Added a new User Exit callback GET_FILEOP_INFO() to obtain part only purgedata records. The new function will allow the use to track the partitions that have been purged as to maintain any target altfile purges that might need to take place.

Bug 36959101 NSK: GGSCI command Capture tabledefs fails. Corrected GGSCI to return results from the Capture tabledefs command.

Bug 36975073 NSK: replicat network checkpoint. Corrected Replicat from processing network checkpoints, if either the target repctxt or the files being replicated are not audited.

Bug 37069885 NSK: replicat error message is missing the error number. Corrected Replicat from printing a hardcoded 0 as the error number.

Bug 37101663 NSK: @GETTLFTOKEN() throws token count error on bad header eye catcher location. Corrected the error on a bad header token count. This occurred without first testing if parsing had found the token eye catcher on a valid header.

Bug 37389263 NSK:fix short used as an index in the file exclude code. Corrected an Extract problem that can occur when more than 32767 ALTFILE are automatically excluded.

Bug 37393615 NSK: Handle OpenSys rectype metadata fragment 171. Corrected a problem combining fragment TDR records type 171 from OpenSys.

This would cause an error, such as Bad metadata record found (Bad hdr token length x vs x).

Release 23.4.0.0.0 - June 2024

Bug 29044245: EXTRACT NSK: Enable user exits as shared objects in native mode. Enhanced Extract and Replicat to allow the use of a shared object DLL User Exit.

Bug 30777280: OTHER Support trail output from Logger or Extract to long named volume. Added support for volume names up to 7 bytes when only used for Enscribe.

Bug 32515895: EXTRACT NSK: set error text in colfnc parse_argument. Corrected lost error text on parsing details of @function() calls.

Bug 32690290: MANAGER NSK: Mgr missing audit reporting. Corrected the double reporting of missing audit.

Bug 32716663: EXTRACT NSK: report duplicate column names. Change formatting of warning messages for ambiguous referenced columns during mapping to give clearer indication of unintended name matches.

Bug 33060156: REPLICAT NSK:HandleCollisions should not be required for PKUPdates. Corrected the requirement for HandleCollisions to be used to skip the Delete portion of a missing target record of a PKUpdate.

Bug 33064538: REPLICAT NSK: Replicat update stats bucket for fileop and User Exit Ignore returned like DML. Corrected the file stat after a User Exit returned Ignore Record such as the Base24 Rename that occurs during a Refresh.

Bug 33150018: EXTRACT Add column function @SIZEOF (). Added a new column function to return the size of a column or Enscribe group level field.

Bug 33281294: REPLICAT NSK: init_targ_fields does not init pic 9(n) fields correctly. Corrected the default values of pic 9 fields to ASCII Zeros instead of binary zeros, which could cause an error -8405 when replicating data from OpenSys.

Bug 33402823: GGSCI NSK:System command fails. Corrected handling of procedure death message from TMFSERVE that caused the GGSCI system command to fail.

33749686 EXTRACT NSK:Fix the TCP/IP compression stats reported by extract. Corrected the display value of compression stats.

Bug 33817095: REPLICAT NSK:Detect and handle lock length less than key length. Corrected Replicat from not releasing file locks on Key Sequenced Enscribe when the lock length is not the same as the key length.

Bug 33821106: REPLICAT NSK: Add a CLOSEFILES option to eventAction. Added the option of CLOSEFILES to the eventActions clause of MAP.

Bug 33993578: OTHER NSK: Add check for running processes during product install. Change to ensure no existing processes are running if the product is reinstall to an existing location.

Bug 34009241: EXTRACT NSK: Marker history processing. Corrected marker history performance issues by changing read/write processing to do 56K I/O.

Bug 34028237: EXTRACT NSK:add configurable warning threshold for maxfiles reached. Allow the warning threshold default of 2 on MaxFiles to be changed.

Bug 34039862: MANAGER NSK: mgr needs to return additional info in some responses. Added full detailed display to the response a remote manager returns from GGSCI> GETMGRVERSION.

Bug 34242185: GGSLIB NSK: Purge op not captured from fup dup, purge in baselib. Added the capture of procedure call FS_FILEPURGE_, which executes during FUP PARTONLY DUP.

Bug 34510414: EXTRACT NSK: always output current read position. Added current read location and last completed CSN to both Extract and Replica reports after send report and Stop commands.

Bug 34645149: GGSCI NSK:fix altering the TMF read position by seqno, rba. Updated the timestamp associated with any configured AUX trails after an alter by Extseqno and Extrba.

Bug 34715923/35279460: AUDSERV NSK:Audserv needs to report SQL/MP error text from SQLCATOBUFFER(). Added SQL/MP error details on error getting partition details from the catalog.

Bug 34725132: REPLICAT NSK:Fix report file filling up. Changed the mode of testing if a report file was going to become full from a timer to a prewrite test.

Bug 34739855: EXTRACT NSK:Extract storing aborted transaction data. Changed Extract from holding terminated transaction data through the rollback unless GetRollBacks is in use.

Bug 34743352: EXTRACT NSK: FILENAME_TO_PATHNAME_ gets error 4202. Added a more meaningful message that the Open System Services File System is required.

Bug 34756203: REPLICAT NSK:replicat network checkpoints. Corrected the network checkpoint written to REPCTXT to only write actual record length, not size of record.

Bug 34816441: LOGDUMP NSK:Logdump infer datetime fraction precision Corrected the formatting of the fractional part of a Timestamp/Datetime datatype.

Bug 34846029: REPLICAT NSK: Implement DEFERAPPLYINTERVAL. Enhanced Replicat to wait a predetermined amount of time before applying data.

Bug 35007016: REPLICAT NSK: Correct handling of Unified PkUpdate from OpenSys. Corrected the handling of Unified PkUpdate from OpenSys when columns are compressed out and or missing from a source OpenSys DB.

Bug 35080490: EXTRACT NSK: Remove the old ATCONFIG code. Deprecated the antiquated ATCONFIG for TMF recovery in favor of TMF Tape and Dumps.

Bug 35111977: OTHER NSK: COMBLIB needs to verify the presence of entrylib. Corrected to ensure ENTRYLIB exists so a combined library will not be built without it.

Bug 35112835: REPLICAT NSK:Fix control record when we have not seen an open on the file. Corrected Replicat to handle a control that was intercepted without a prior open, caused by the intercept being built without ENTRYLIB.

Bug 35196789: EXTRACT NSK: Add MOM pid to Extract/Replicat banners. Added process details to the report banners.

Bug 35224161: EXTRACT NSK:Extract pump on nsk files with no node. Corrected handling of NSK formatted names coming from OpenSys where the node name was removed.

Bug 35241002: EXTRACT NSK: fix core dump when source & target are the same and using CONVERTALLFLOATS. Corrected a possible trap in an Extract pump when converting floats.

Bug 35270299: OTHER NSK: Deprecate TNS mode Extract and Replicat. Removed the TNS Extract and Replicat object from the distribution.

Bug 35315074: GGSLIB NSK: Non Audited capture needs to resolve defines in audconfig. Added the ability to use =Defines in LogParm for non audited capture.

Bug 35339156: EXTRACT NSK: Allow the result of an expression in SQLEXEC. Added the ability to reference an expression while doing a SqlExec in a map statement.

Bug 35351238: OTHER NSK: Clean up fupop to user exit from wildcard not resolved. Corrected the name passed to a User Exit when a Fileop was performed before a DML.

Bug 35364061: REPLICAT NSK:Remote checkpoint message. Clarified an error message when a remote host was not configured in globals.

Bug 35411505: GGSCI NSK: add maxfiles to the info logger display. Added the MaxLogfiles configured for a Logger process from the GGSCI info logger command.

Bug 35421610/35950674: EXTRACT NSK: Correct MRKRGGS counted to output trails. Corrected trail stats to match file buckets for marker records that had been previously hidden.

Bug 35422116: DEFGEN NSK: Correct part of key for Defgen. Corrected the Defgen output to remove group level Enscribe fields as part of key.

Bug 35485096: EXTRACT NSK: Open MGRPORT option for RMTHOSTALT. Added the ability to use RMTHOSTALT with MGRPORT and other supporting parameters.

Bug 35496620: GGSCI NSK: add PARAMS to the ggsci env output. Added the display of session params to the env command from GGSCI.

Bug 35554736: EXTRACT NSK:Extract/replciat need to validate source files. Added a bounds check on invalid NSK names with extra digits.

Bug 35623008: GGSCI NSK: Correct GGSCI command to start extract with NoFilterRestart. Corrected the ability to have Extract restart without skipping duplicate records.

Bug 35702992: EXTRACT NSK: Dont send auditcomp records to an Opensys target. Corrected and stopped Enscribe Auditcomp records from being sent to an OpenSys target.

Bug 35742874: EXTRACT NSK: Output more IP connection details. Added more details to the report display after Extract gets an IP connect to a remote process.

Bug 35747018: EXTRACT NSK: add sqlexec sanity check. Add missing bounds check to ensure one of either BeforeFilter or AfterFilter was provided.

Bug 35756813: OTHER NSK: Change bad install (altkeys) message to reinstall product. Clarified abend message for an incorrectly installed product.

Bug 35761645: GGSCI NSK: add direct read info to the info extract display Added to the display info on a DirectRead Extract group to show the type, such as, ACITLF, ENTRY, or ADVANTAGE.

Bug 36571170 - NSK: Encryption over IP does not account for enough to pad buffer overhead. Corrected the padded allotment to account for the AES initialization vector being appended to the message.

Bug 35778120/35788026: GGSCI NSK:Fix ggsci writing max length REPCTXT records. Corrected GGSCI from updating REPCTXT records to 4040 bytes when altering a group to use actual count.

Bug 35788026: REPLICAT NSK:allow opensys table names longer than 48 bytes. Removed the limitation of OpenSys ANSI table name longer than 48 bytes.

Bug 35928952: MANAGER NSK:MGR trapped when it received a long message on TCP/IP. Corrected manager from trapping by adding a bound check on incoming messages to manager when a process is sending messages larger than it can handle.

Bug 36014904: GGSCI NSK:Fix view report on very large report files. Corrected positioning into a report file when viewing the last or end of a very large report.

Bug 36096307: LOGGER NSK:Logger dangling opens on logtrails. Corrected dangling logfile opens due to SIGNALTIMEOUT failures.

Bug 36128271: GGSCI NSK:Fix incorrect check of errno after fgets. Corrected the error testing during reading of parameter files from view command.

Bug 36139507: EXTRACT NSK:Calculate rate on the RecordCount display. Added display of rate per interval when reporting ReportCount.

Bug 36192203: AUDSERV NSK:fix audserv parsing of ARLIBERROR. Corrected parsing of Extract parameter AUDSERVPARAM option ARLIBERROR <error>, <action> .

Bug 36421312: EXTRACT NSK: Fix abend when resolving MRKRGGS. Corrected a TMF Extract getting an error “Unable to add new file MRKRGGS” for a marker file from a different Oracle GoldenGate installation on the same node.

Bug 36504603: OTHER NSK: Remove Blowfish method from usage. Deprecated and removed the use of BlowFish encryption from the product. This affects the GGSCI command Encrypt Password, the Logon parameter to Extract and Replicat, as well as Extract encryption over IP. For more information, see Using Encryption in the Administering Oracle GoldenGate for HP NonStop (Guardian Data Sources)

Bug 36525748: EXTRACT NSK: Bounds check rmthost to OpenSys MA to not allow encryption over IP. Added RECEIVERPORT for Extract to send RMTTRAIL data to an OpenSys MicroServices remote and properly test valid parameters. This is to be used instead of either PORT or MGRPORT.

36626655 NSK: Extract does not write restart abend record after maxfiles abend and prior trail was already complete Corrected Extract to output a restart abend record on restarting after Extract reached the configured Maxfiles causing an abend.

Getting Help with Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

When you contact support, provide full and concise details. Use the PAK utility to provide all reports for each of a given process group of Extract (TMF and or PUMP) as well as Replicat for full source to target details. Use the same PAK utility to provide any relevant ZZSA files and matching object file.

Example of using PAK:

TACL> PAK Pakfile, <$vol>.<subvol>.<group name>*, Open

Known Issues

This chapter describes the known issues at the time of Oracle GoldenGate HP NonStop Release.

Release 23.4.0.0.0 - June 2024

Metadata Requirement as of Version GoldenGate for HP NonStop 19c

Extract may need access to source metadata to be able to write it to the output trails. This is subjective to your need and usage of column information downstream.

By default a metadata record (TDR) is written to the trail for each file or table before its first DML.

In the case of SQL/MP, the catalog is already accessible and nothing needs to be changed.

In the case of Enscribe files, if there is no DICTIONARY and DEF provided, Extract will fabricate metadata based solely on the details obtained from FILEINFO. While this is sufficient for the basic mapping of FILE A to FILE A, there would be no means to use ColMap, FILTER/WHERE, KEYCOLS, and others features or functions that would require column names and data type information. If this functionality is required, then you must use a DICTIONARY and provide a DEF for each FILE.

The metadata is required by an OpenSys target, and therefore the Extract writing remote trails to another OS is no longer allowed to send fabricated metadata for Enscribe files. You must provide a DICTIONARY and provide a DEF for each FILE. This eliminates the requirement of running DEFGEN to provide the OpenSys Replicat of SOURCEDEFS.

When Replicating from an OpenSys source to HP NonStop, as of HP NonStop v12.3, you no longer need to use DEFGEN to provide column information to the remote Extract on OpenSys. No mapping of filenames or columns is required. This can now all be accomplished in the NSK Replicat because of metadata in the trail.

For more information about trails, see Oracle GoldenGate Self-Describing Trail Files in the Fusion Middleware Administering Oracle GoldenGate for HP NonStop (Guardian).

Metadata Compatibility

Metadata in trails for SQL/MP and Enscribe DDL without redefines is compatible with any 12.2 or higher version.

Metadata in trails for Enscribe DDL that contains Redefines, can only be sent to OpenSys targets of versions of 12.2.0.1.7 or higher and NSK targets of 12.3.0.1.0 or higher.

Metadata in trails that was fabricated for Enscribe files when DDL was not provided can cause problems for Replicat using TARGETDEF on a Map statement. Consult the manuals to resolve this.

When Extracting from OpenSys, providing a Map from a ANSI name to an NSK name and not providing a TargetDef will result in an Error TDR invalid column metadata, mismatched. Remove the MAP statement and only send the ANSI name.

Trail Version Compatibility

Oracle recommends that both the source and target versions be of the same major release versions, but if this is not possible and the target version is older than the source, the output data trails must be created by Extract in the targets version formatting, use the appropriate FORMAT RELEASE <major.minor> option with the EXTTRAIL/RMTTRAIL parameter.

Open Issues

Note:

Related Information

Oracle GoldenGate Documentation

Oracle GoldenGate for Distributed Applications and Analytics

OCI GoldenGate

Oracle AI Database High Availability

Documentation Accessibility

For information about Oracle’s commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.