重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 4017|回复: 2
打印 上一主题 下一主题

[补丁] ogg 12.3上启动抽取进程报错:OGG-02912 Patch 17030189 is required

[复制链接]
跳转到指定楼层
楼主
发表于 2018-10-6 12:55:31 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
本帖最后由 郑全 于 2018-10-6 12:56 编辑

OGG-02912  Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later (Doc ID 2304095.1)





分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

板凳
 楼主| 发表于 2018-10-6 12:57:55 | 只看该作者
本帖最后由 郑全 于 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>

回复 支持 反对

使用道具 举报

沙发
 楼主| 发表于 2018-10-6 12:55:43 | 只看该作者
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
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-27 14:49 , Processed in 0.092052 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表