问题描述：无法启动ogg配置好的抓取以及投递进程.

环境：源端oracle 11.2.0.4 目标端：oracle 19.16

ogg软件：191004_fbo_ggs_Linux_x64_shiphome.zip

1、问题重现

GGSCI (leo-11g-ogg as ogg@orcl) 6> start dp1

 

Sending START request to MANAGER ...

EXTRACT DP1 starting

GGSCI (leo-11g-ogg as ogg@orcl) 7> start exta

 

Sending START request to MANAGER ...

EXTRACT EXTA starting

 

 

GGSCI (leo-11g-ogg as ogg@orcl) 8> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     STOPPED     DP1         00:00:00      00:25:21   

EXTRACT     STOPPED     EXTA        00:00:00      00:29:49   

2、问题分析

告警信息：

[oracle@leo-11g-ogg dirrpt]$ pwd

/u01/app/ogg/dirrpt

[oracle@leo-11g-ogg dirrpt]$ cat DP10.rpt

……

2022-12-01 13:04:06  ERROR   OGG-00303  Unable to connect to database using user ogg. Ensure that the necessary privileges are granted to the user.

Operation not supported because enable_goldengate_replication is not set to true.

 

2022-12-01 13:04:06  ERROR   OGG-01668  PROCESS ABENDING.

[oracle@leo-11g-ogg dirrpt]$ cat EXTA.rpt

……

2022-12-01 13:05:58  ERROR   OGG-10151  (exta.prm) line 3: Parsing error, parameter [setenv] has unrecognized keyword or extra value "(AMERICAN_AMERICA.AL32UTF8)".

……

2022-12-01 13:05:58  ERROR   OGG-10151  (exta.prm) line 3: Parsing error, parameter [setenv] has unrecognized keyword or extra value "=".

 

2022-12-01 13:05:58  ERROR   OGG-01668  PROCESS ABENDING.

3、解决过程

3.1、修改enable_goldengate_replication

sys@ORCL 2022-12-01 13:26:12> show parameter enable_goldengate_replication

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

enable_goldengate_replication        boolean     FALSE

sys@ORCL 2022-12-01 13:26:36> alter system set enable_goldengate_replication=true;

 

System altered.

 

sys@ORCL 2022-12-01 13:27:00> show parameter enable_goldengate

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

enable_goldengate_replication        boolean     TRUE

 

3.2、修改EXTA

将以下设置

setenv NLS_LANG = (AMERICAN_AMERICA.AL32UTF8)

修改为

setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

注意：等号两边不要空格.

3.3、重启EXTA、DP1

GGSCI (leo-11g-ogg) 1> dblogin userid ogg,password ogg

Successfully logged into database.

GGSCI (leo-11g-ogg) 2> start dp1

 

Sending START request to MANAGER ...

EXTRACT DP1 starting

GGSCI (leo-11g-ogg) 2> start EXTA

 

Sending START request to MANAGER ...

EXTRACT DP1 starting

 

GGSCI (leo-11g-ogg as ogg@orcl) 8> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     ABENDED     DP1         00:00:00      00:48:38   

EXTRACT     RUNNING     EXTA        00:00:00      00:00:07   

说明：如上所示，DP1处于ABENDED异常状态.

3.4、解决dp1 abended异常

3.4.1、查dp1告警日志

[oracle@leo-11g-ogg dirrpt]$ cat DP1.rpt

……

2022-12-01 13:28:07  ERROR   OGG-01224  TCP/IP error 111 (Connection refused), endpoint: 192.168.133.109:7809.

 

2022-12-01 13:28:07  ERROR   OGG-01668  PROCESS ABENDING.

3.4.2、目标端加端口

此时在目标端添加mgr端口.

GGSCI (leo-19c-ogg) 2> create subdirs

 

Creating subdirectories under current directory /u01/app/ogg

 

Parameter file                 /u01/app/ogg/dirprm: created.

Report file                    /u01/app/ogg/dirrpt: created.

Checkpoint file                /u01/app/ogg/dirchk: created.

Process status files           /u01/app/ogg/dirpcs: created.

SQL script files               /u01/app/ogg/dirsql: created.

Database definitions files     /u01/app/ogg/dirdef: created.

Extract data files             /u01/app/ogg/dirdat: created.

Temporary files                /u01/app/ogg/dirtmp: created.

Credential store files         /u01/app/ogg/dircrd: created.

Masterkey wallet files         /u01/app/ogg/dirwlt: created.

Dump files                     /u01/app/ogg/dirdmp: created.

 

GGSCI (leo-19c-ogg) 3> edit param mgr

添加以下：

port 7809

 

GGSCI (leo-19c-ogg) 4> start mgr

Manager started.

 

 

GGSCI (leo-19c-ogg) 5> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                        

 

3.4.3、源端启动dp1

GGSCI (leo-11g-ogg) 2> start dp1

 

Sending START request to MANAGER ...

EXTRACT DP1 starting

 

 

GGSCI (leo-11g-ogg) 3> info all

 

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

 

MANAGER     RUNNING                                          

EXTRACT     RUNNING     DP1         00:00:00      00:55:39   

EXTRACT     RUNNING     EXTA        00:00:00      00:00:00   

 

说明：此时源端dp1、exta显示正常.