1 发现OGG 进程异常终止

GGSCI (osxxb) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           

REPLICAT    ABENDED     REPZB       09:12:43      00:15:14    

2 查看OGG的报错信息

Source Context :

  SourceModule            : [er.repio]

  SourceID                : [/scratch/pradshar/view_storage/pradshar_pse_15852019/oggcore/OpenSys/src/app/er/repio.cpp]

  SourceFunction          : [replicate_io]

  SourceLine              : [1078]

  ThreadBacktrace         : [8] elements

                          : [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7fef0d99371e]]

                          : [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7fef0d98c6bc]]

                          : [/ogg/libgglog.so(_MSG_ERR_DB_WORKSPACE_COULD_NOT_ENABLE(CSourceContext*, CMessageFactory::MessageDisposition)+0x2c) [0x7fef

0d96c70c]]

                          : [/ogg/replicat(replicate_io(file_def*, __std_rec_hdr*, char*, extr_ptr_def*, int*, int)+0x2664) [0x53f0f4]]

                          : [/ogg/replicat(process_extract_loop()+0xfa1) [0x539931]]

                          : [/ogg/replicat(main+0x732) [0x54cbd2]]

                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x31b621ed1d]]

                          : [/ogg/replicat(__gxx_personality_v0+0x31a) [0x4c0c6a]]

2021-04-09 08:58:57  ERROR   OGG-01820  Could not enable workspace.

3 查看Oracle的官方文档

Golden Gate Replicat Process Abended. OGG-01820 Could Not Enable Workspace. (Doc ID 1587180.1)

CAUSE

This can be caused by 2 things:

1. GG enable replication parameter is not set in the DB

2. The OGG database user needs Oracle Streams adminstrator privileges.  This is required when using some REPLICAT DB options like SUPPRESSTRIGGERS.

SOLUTION

1.  Check if GG enable replication is set in the DB:

SQL> show parameters goldengate

NAME                                 TYPE        VALUE

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

enable_goldengate_replication        boolean     TRUE

If value is not TRUE, then enable this parameter by running:

 ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;

2. To correct, grant privileges to the Replicat Oracle DB user by running the dbms_goldengate_auth.grant_admin_privilege procedure.

ie:

exec dbms_goldengate_auth.grant_admin_privilege('gguser','*',TRUE);

On Windows hosts, you may also have to run:

exec dbms_goldengate_auth.grant_admin_privilege(' "NT AUTHORITY\SYSTEM"','*',TRUE);"

3 按照官方文档进行修改

查看数据库的参数

SQL> show parameter goldengate

NAME                                 TYPE        VALUE

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

enable_goldengate_replication        boolean     FALSE

修改数据库的参数

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

System altered.

SQL> exec dbms_goldengate_auth.grant_admin_privilege('OGG','*',TRUE);

PL/SQL procedure successfully completed.

4 启动OGG，查看进程状态，发现OGG已经恢复正常

GGSCI (osxxb) 26> !

info *

REPLICAT   REPZB     Last Started 2021-04-09 09:17   Status RUNNING

Checkpoint Lag       09:15:48 (updated 00:00:00 ago)

Log Read Checkpoint  File ./dirdat/zb019186

                     2021-04-09 00:01:35.000983  RBA 42186349