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

微服务架构

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] [] [] [] [] [] [] []

但是注册的时候却报错：

解决：

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

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。