OGG-01820 Could not enable workspace

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