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] [] [] [] [] [] [] []
但是注册的时候却报错：
1 2 3 4 5 6 7 8 | OGG (http://127.0.0.1:9000 deploy213 as ora11@LHR11G) 9> register extract ext11 database 2021-12-03T09:45:40Z ERROR OGG-08221 Cannot register or unregister Extract group EXT11 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 ). |
解决：
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
打补丁需要停机：
1 2 3 4 | unzip p20448066_112040_Linux-x86-64.zip cd 20448066 $ORACLE_HOME/OPatch/opatch apply $ORACLE_HOME/OPatch/opatch lspatches |
打完补丁后，重新运行：
1 2 | OGG (http://127.0.0.1:9000 deploy213 as ora1101@LHR11G) 6> register extract ora11 , database 2021-12-03T14:58:46Z INFO OGG-02003 Extract group ORA11 successfully registered with database at SCN 1127122. |
但是，运行过程中仍然会出现一些patch的错误，例如“OGG-02912 Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later”
解决：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | [root@lhrogg213maoracle /]# find / -name prvtlmpg.plb /ogg213c/ogg_ma/lib/sql/legacy/prvtlmpg.plb [root@lhrogg213maoracle /]# sqlplus sys/lhr@172.17.0.2/lhr11g as sysdba SQL*Plus: Release 21.0.0.0.0 - Production on Mon Dec 6 09:05:50 2021 Version 21.4.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. 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 SQL> @/ogg213c/ogg_ma/lib/sql/legacy/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> |
还是报错“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
解决办法：
1 2 3 4 5 6 | find / -name prvtlmpg.plb sqlplus sys/lhr@172.72.7.14/lhr11g as sysdba SQL> @/ogg/prvtlmpg.plb Enter Integrated Capture mining user: OGG |
