OGG OCI Error ORA-01031: insufficient privileges (status = 1031) 这个问题一般是ogguser权限不够造成的 grantsysdbatoogguser; grantselect,insert,update,deleteonmaptabletoOGGUSER; 反正就是ogguser缺少权限 CREATESESSION,ALTERSESSIONALTERSYSTEM RESOURCE CONNECTSELECTANYDICTIONARY FLASHBACKANYTABLESELECTANYTABLESELE...
pump进程异常abend,err log报错日志如下: 2020-04-23 11:40:00 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/ogg/ggs12...
简介:OGG REPA进程 Error ORA-01031报错处理 1.查询报错日志 GGSCI (target) 3> view report repa 2.处理过程 根据报错提示,排查原因为OGG用户没有对HR用户表的操作权限导致 2.1 登陆目标库确认是否有权限 SYS@PROD> conn ogg/oracleOGG@PROD> insert into hr.t1 (object_id,object_name) values (76838,'og...
前言 近日在一套新搭建的OGG库上,启动REPA应用进程后,Error ORA-01031: insufficient privileges ,本文详细记录了报错的处理方法 1.查询报错日志 GGSCI (target)3> 1. 2.处理过程 根据报错提示,排查原因为OGG用户没有对HR用户表的操作权限导致 1. 2.1 登陆目标库确认是否有权限 SYS@PROD> conn ogg/oracle OGG@...
ERROR OGG-01031 pump进程异常abend,err log报错日志如下: 2020-04-23 11:40:00 ERROR OGG-01031 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open ...
ERROR OGG-01031 Oracle GoldenGate Capture for Oracle, extpump.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/<>/dirdat/pt001245"...
pump进程异常abend,err log报错日志如下: 2020-04-23 11:40:00ERROR OGG-01031There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/ogg/ggs12/....
ggserr.log日志提示如下 ERROR OGG-02028Failedtoattachtologmining server OGG$ABCD error26927-ORA-26927: altering an outbound serverwitha remote captureisnotallowed 经查询Mos得知,该问题是logminer潜在错误,为进程释放PGA内存时出现问题,导致进程失败
[oracle@oel-01 ogg]$ ./ggsci ./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory [oracle@oel-01 ogg]$ ldd ggsci linux-gate.so.1 => (0xb7845000) libdl.so.2 => /lib/libdl.so.2 (0x49cfa000) ...
ggserr.log日志提示如下 ERROR OGG-02028Failedtoattachtologmining server OGG$ABCD error26927-ORA-26927: altering an outbound serverwitha remote captureisnotallowed 经查询Mos得知,该问题是logminer潜在错误,为进程释放PGA内存时出现问题,导致进程失败