OGG-00303 OGG-10124 Caused by DYNAMICPORTLIST Parameter When Starting GoldenGate Manager

The following errors occur when starting GoldenGate Manager:

2022-08-19T21:21:04.281+1000  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2022-08-19T21:21:04.325+1000  ERROR   OGG-00303  Oracle GoldenGate Manager for Oracle, mgr.prm:  Unrecognized parameter (DYNAMICPORTLIST        15100).
2022-08-19T21:21:04.325+1000  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.
2022-08-19T21:38:26.148+1000  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start manager.
2022-08-19T21:38:26.207+1000  ERROR   OGG-10124  Oracle GoldenGate Manager for Oracle, mgr.prm:  (mgr.prm) line 3: Parsing error, value "15100 - 15150" is not one of the legal values ((0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4})))([-](0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4}))))?)([, ]+(0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4})))([-](0*((6553[0-5])|(655[0-2][0-9])|(65[0-4][0-9][0-9])|(6[0-4][0-9][0-9][0-9])|([0-5][0-9][0-9][0-9][0-9])|([0-9]{1,4}))))?)* for [dynamicportlist].
2022-08-19T21:38:26.207+1000  ERROR   OGG-01668  Oracle GoldenGate Manager for Oracle, mgr.prm:  PROCESS ABENDING.

SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

While running ‘ggsci’, the following error occures:

$ cd GG_HOME
$./ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory

Solution

Set up correct env variable $LD_LIBRARY_PATH by :

$ . oraenv
ORACLE_SID = [oracle] ? amer
The Oracle base has been set to /u01/app/oracle
$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
...
..
.

Oracle GoldenGate Version and Supported Oracle Database Version

We are always asked by clients what version of GoldenGate supports what version of Oracle databases ? or whether certain Oracle database version is supported by certain version of GoldenGate ?

The easy way is going to Oracle Support website -> Certifications.

Use GoldenGate Oracle GoldenGate 12.2.0.1.0 as an example, it supports Oracle database version back to 11.2.0.1.

For GoldenGate 19.1.0.0.0, it supports the following Oracle database versions: 19c,18c,12.2.0.1,12.1.0.2, 12.1.0.1 and 11.2.0.4.

For GoldenGate 21.3.0.0.0, it only supports Oracle database 21c, 19c, 12.1.0.2 and 11.2.0.4.

For GoldenGate 21.3.0.0.1, it only supports Oracle database 19c and 21c.

How to Install Oracle GoldenGate 12C (12.1.2.1)

Great software to sync Oracle database, schemas, tables and all kinds of transactions in rear time.

1) Download Oracle GoldenGate 12c (12.1.2.1) binaary “121210_fbo_ggs_Linux_x64_shiphome.zip”, and unzip it. One  directory and two files created as below:

$unzip 121210_fbo_ggs_Linux_x64_shiphome.zip
$ ls -ltr
drwxrwx—. 1 root vboxsf 0 Aug 8 2014 fbo_ggs_Linux_x64_shiphome
-rwxrwx—. 1 root vboxsf 1540 Aug 11 2014 OGG-12.1.2.1.0-README.txt
-rwxrwx—. 1 root vboxsf 246718 Aug 11 2014 OGG-12.1.2.1.0-ReleaseNotes.pdf

2)Run runInstaller:

$ cd fbo_ggs_Linux_x64_shiphome
$ cd Disk1
$ ./runInstaller

Capture_1

3) Select the option for Oracle GoldenGate for Oracle Database 12c.
If you select the option for Database 11g, the installation will be valid but will not start against an 11g database due to shared libraries needed (libnnz12.so ).  Support version for Integrated Replicat is Oracle 11g (11.2.0.4).

Capture2

4)Review the Summary screen:

Capture3

5) Start to install with processing details:

Capture4

6)The installation is complete:

Capture5

7) Unlike previous version of Oracle GoldenGate, for 12c OGG installation, the oraInventory is updated accordingly as below:

[oracle@racnode1 ContentsXML]$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
 <SAVED_WITH>11.2.0.3.0</SAVED_WITH>
 <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="1"/>
<HOME NAME="OraHome1" LOC="/u01/app/oracle/product/12.1.2/oggcore_1" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

8) Check Manager process has been stated:

$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@racnode1 oggcore_1]$ cd /u01/app/oracle/product/12.1.2/oggcore_1

$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Aug 7 2014 10:21:34
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.
GGSCI (racnode1) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (racnode1) 3>

9) Check parameter  file:

$ cd dirprm
$ ls -ltr
total 8
-rwxr-x---. 1 oracle oinstall 103 Aug 7 2014 jagent.prm
-rw-r--r--. 1 oracle oinstall 9 Mar 29 22:48 mgr.prm
$ cat mgr.prm
PORT 7809

10) The 12c installation is simple and straight away,  there is no need to run “CREATE SUBDIRS”, because the OUI does all. It is pretty good.

11) Uninstall Oracle GoldenGate Installation.

cd $OGG_HOME
cd deinstall
./deinstall.sh

Check oraInventory and confirm $OGG_HOME has been removed  from inventory.

$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
 <SAVED_WITH>11.2.0.3.0</SAVED_WITH>
 <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraDB12Home1" LOC="/u01/app/oracle/product/12.1.0/dbhome_1" TYPE="O" IDX="1"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>