无法启动ogg配置好的抓取以及投递进程

问题描述:无法启动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显示正常.