Oracle Goldengate : start replicat ATCSN or AFTERCSN ?

There is a following question on the web with different answers:

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

A. Use the command option AFTERCSN.
B. Use the command option ATCSN.
C. Use the command option UNTIL CANCEL.
D. Use the command option RESUME.

There are more than one correct answer, i think.

A is correct, if datapump has been used to instantiate the target database. expdp performed consistency as of FLASHBACK_SCN included.

B is correct, if RMAN has been used to instantiate the target database. Oracle RMAN restore or recovery using UNTIL SCN which specifies an SCN as an upper limit  but not including the specified SCN.

For Oracle GoldenGate 12.2 and above, neither AFTERCSN nor ATCSN is required anymore, if “DBOPTIONS ENABLE_INSTANTIATION_FILTERING” is enabled in replicat parameter file.

Reference : Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
Version 12c
Document ID 1276058.1

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.