数据库环境：RAC 11.2.0.3.0

操作系统：Red Hat Enterprise Linux Server release 5.8 (Tikanga)

归档路径：闪回区

OGG版本：Version 11.2.1.0.33

报错日志：

2019-08-05 14:37:06 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, pukafka.prm: EXTRACT PUKAFKA started.

2019-08-05 14:37:06 INFO OGG-06569 Oracle GoldenGate Capture for Oracle, pukafka.prm: Remote Collector/Server version 12.3 receiving data is a different version than this Extract 11.2 sending data.

2019-08-05 14:37:07 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, extkafka.prm: No valid default archive log destination directory found for thread 1.

2019-08-05 14:37:08 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

2019-08-05 14:37:08 WARNING OGG-01423 Oracle GoldenGate Capture for Oracle, extkafka.prm: No valid default archive log destination directory found for thread 2.

2019-08-05 14:37:08 INFO OGG-00546 Oracle GoldenGate Capture for Oracle, extkafka.prm: Default thread stack size: 33554432.

2019-08-05 14:37:09 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, extkafka.prm: The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT <group name>, TRANLOG, THREADS 2, BEGIN...).

2019-08-05 14:37:09 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extkafka.prm: PROCESS ABENDING.

解决方式一：（Oracle 11g R1版本）

extract 的参数文件中加一行 TRANLOGOPTIONS ASMUSER <user>@<ASM_INSTANCE TNS>,ASMPASSWORD <ASM密码>

注释：

user必须sys用户

ASM_INSTANCE TNS配置ASM实例TNSNAME如下：

ASM =

  (DESCRIPTION =

      (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 172.30.27.10)(PORT = 1521))

)

            (CONNECT_DATA =

                 (SERVICE_NAME =+ASM) (INSTANCE_NAME =+ASM1) (UR=A)

                  (SERVER = DEDICATED)

)

)

ASM密码 是SYS用户密码

解决方式二：（Oracle 10.2.0.5及更高版本10g R2版本以及Oracle 11.2.0.2及更高版本11g R2版本，现在可以使用新的AMS API）

Oracle GoldenGate的Extract使用以下方式访问ASM：

TRANLOGOPTIONS DBLOGREADER

从Oracle Database 11.2.0.5.0及Oracle Database 11.2.0.2.0起，Oracle GoldenGate可以通过Database新的API访问ASM中的Redo Log File及Archived Redo Log File，无需在GoldenGate的Extract配置文件中指定ASM的连接方式，也无需配置ASM的监听。

Oracle Database使用以下Archive Log Dest参数：

log_archive_dest_1 归档独立出来切勿放在闪回区。

设置enable_goldengate_replication为true

alter system set enable_goldengate_replication=true sid='*' scope=both;

完毕！

ITPub博客

OGG-01423

最新文章