OGG微服务报错“OGG-08238 This database does not have the required patch to support a SHARE clause. Remove the SHARE clause”

0    182    2

👉 本文共约1015个字,系统预计阅读时间或需4分钟。

微服务架构

Oracle 12.2.0.1同步到11.2.0.4可以,反过来不可以,即源端不能是11.2.0.4或12.1.0.2,但目标端可以是11.2.0.4,报错“OGG-08238 This database does not have the required patch to support a SHARE clause. Remove the SHARE clause.”或“OGG-02022 Logmining server does not exist on this Oracle database.”或“OGG-06608 Cannot obtain container list because the database does not support catalogs.”

OGG-08238 Error: This database does not have the required patch to support a SHARE clause. Remove the SHARE clause.

OGG-12029 The item type request with name '425988628' does not exist.
OGG-08221 | Cannot register or unregister Extract group EXTA because of the following SQL error: OCI Error ORA (status = 1031-ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 94 ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 93 ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 124 ORA-06512: at line 1 ).

ERROR OGG-00446 error 2 (No such file or directory) opening redo log /u01/app/oracle/oradata/LHR11G/redo03.log for sequence 30Not able to establish initial position for begin time 2022-06-21 17:40:02.000000.

OGG-00446 Opening file /u01/app/oracle/oradata/LHR11G/redo03.log in DBLOGREADER mode: (3114) ORA-03114: not connected to ORACLE
Not able to establish initial position for begin time 2022-06-21 17:40:02.000000.

ORA-03137: TTC protocol internal error : [1010] [] [] [] [] [] [] []

但是注册的时候却报错:

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

解决:

Insufficient Privileges While Setting Up Integrated Extract on OGG 12.3 Microservices Architecture (Doc ID 2348973.1)

需要打如下的补丁:Patch 20448066 : DBMS_XSTREAM_GG APIS SHOULD BE ALLOWED FOR SCA PROCESSES

打补丁需要停机:

打完补丁后,重新运行:

但是,运行过程中仍然会出现一些patch的错误,例如“OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later”

解决:

还是报错“OGG-08238 Error: This database does not have the required patch to support a SHARE clause. Remove the SHARE clause.”

MOS上暂未找到办法。

OGG MA使用12.3或18或19或21.3都没有办法!集成模式和传统经典模式都尝试了,都不行。

非微服务架构

对于非微服务架构而言,OGG 21.3可以远程捕获和投递Oracle 11.2.0.4的数据库。

不过会报错:
OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later

解决办法:

    头像

    小麦苗

    学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

    您可能还喜欢...

    发表评论

    您的电子邮箱地址不会被公开。

    13 − 6 =

     

    嘿,我是小麦,需要帮助随时找我哦
    • 18509239930
    • 个人微信

    • 麦老师QQ聊天
    • 个人邮箱
    • 点击加入QQ群
    • 个人微店

    • 回到顶部
    返回顶部