无法启动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显示正常.