ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.
There are some recommended patches which are needed to be applied to the database to use the Integrated Capture / Extract in Oracle GoldenGate. Even though after applying the recommended patch to the database, when starting the Integrated Extract process, the process abended with the below error,
2016-09-20 11:58:36 ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later. 2016-09-20 11:58:36 ERROR OGG-01668 PROCESS ABENDING. GGSCI (OGGR2-1.localdomain as ggadmin@GGDB1) 2> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED INEXT 00:00:00 00:13:08
There is a work around available to overcome this issue. A script included known “prvtlmpg.plb” and this script will be under the Oracle GoldenGate installation directory.
Check tbe below, my OGG_HOME is /ogg,
[oracle@OGGR2-1 ogg]$ ls -lrt prvtlmpg.plb -rw-r----- 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb [oracle@OGGR2-1 ogg]$ pwd /ogg [oracle@OGGR2-1 ogg]$
Login to the database and just run this script,
[oracle@OGGR2-1 ogg]$ sqlplus / as sysdba SQL*Plus: Release 188.8.131.52.0 Production on Tue Sep 20 12:00:42 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @prvtlmpg.plb Oracle GoldenGate Workaround prvtlmpg This script provides a temporary workaround for bug 17030189. It is strongly recommended that you apply the official Oracle Patch for bug 17030189 from My Oracle Support instead of using this workaround. This script must be executed in the mining database of Integrated Capture. You will be prompted for the username of the mining user. Use a double quoted identifier if the username is case sensitive or contains special characters. In a CDB environment, this script must be executed from the CDB$ROOT container and the mining user must be a common user. =========================== WARNING ========================== You MUST stop all Integrated Captures that belong to this mining user before proceeding! ================================================================ Enter Integrated Capture mining user: ggadmin Installing workaround... No errors. No errors. No errors. Installation completed. SQL> SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
You can see the message above that the “Installing workaround”. Once this is completed, you can start the Integated Extract process,
GGSCI (OGGR2-1.localdomain) 1> dblogin userid ggadmin, password oracle Successfully logged into database. GGSCI (OGGR2-1.localdomain as ggadmin@GGDB1) 5> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING INEXT 00:14:06 00:00:05
The Integrated Extract process INEXT has started.
Report File of the INEXT
2016-09-20 12:10:24 INFO OGG-02089 Source redo compatibility version is: 18.104.22.168.0. 2016-09-20 12:10:24 INFO OGG-02086 Integrated Dictionary will be used. 2016-09-20 12:10:24 WARNING OGG-02901 Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead. 2016-09-20 12:10:25 INFO OGG-01052 No recovery is required for target file /vol3/ogg/dirdat/lt000000000, at RBA 0 (file not opened). 2016-09-20 12:10:25 INFO OGG-01478 Output file /vol3/ogg/dirdat/lt is using format RELEASE 12.2.