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