ogg 12.3上启动抽取进程报错：OGG-02912 Patch 17030189 is required

最新推荐文章于 2024-04-15 20:37:29 发布

Hayden_yang

最新推荐文章于 2024-04-15 20:37:29 发布

阅读量2.2k

点赞数 1

分类专栏： oracle 文章标签： ogg

oracle 专栏收录该内容

35 篇文章

订阅专栏

http://www.sizhxy.com/newscenter/newsdetail-249.html

OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later (Doc ID 2304095.1)
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@ogg1 goldengate]$ pwd
/u01/goldengate
[oracle@ogg1 goldengate]$ ls -lrt prvtlmpg.plb
-rwxr-xr-x 1 oracle oinstall 9487 May 27 2015 prvtlmpg.plb
[oracle@ogg1 goldengate]$
[oracle@ogg1 goldengate]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 28 17:00:14 2018

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

SYS@orcl>@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.
SYS@orcl>

OGG版本12.3.0.1时遇到了ERROR OGG-00662 OCI Error OCI-22053: overflow error错误；换为12.2.0.1.1版本后，提示需要打patch，:
ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later
此时有两种选择：
1.打patch
2.在downstream库上执行OGG_HOME下的 prvtlmpg.plb文件

http://blog.sina.com.cn/s/blog_53d137da0102xl5f.html