OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later (Doc ID 2304095.1)
作者: 郑全 时间: 2018-10-6 12:55
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle GoldenGate - Version 11.2.0.0.0 and later
Information in this document applies to any platform.
Symptoms
OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later
Cause
Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later
Solution
There will be a script "prvtlmpg.plb" under gg home directory
[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 run this script
You will see a message "Installing Workarround"
Once this completes start your extract作者: 郑全 时间: 2018-10-6 12:57 本帖最后由 郑全 于 2018-10-6 12:59 编辑
SQL> conn / as sysdba
Connected.
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: ogg
Installing workaround...
No errors.
No errors.
No errors.
Installation completed.
SQL>