Oracle GoldenGate 12.2

ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.

By September 22, 2016 No Comments
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 11.2.0.4.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 11.2.0.4.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 11.2.0.4.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: 11.2.0.4.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.

Leave a Reply

© 2020 ORACLE-SCN. All Rights Reserved.

error: Content is protected !!