反正就是ogguser缺少权限 CREATESESSION,ALTERSESSIONALTERSYSTEM RESOURCE CONNECTSELECTANYDICTIONARY FLASHBACKANYTABLESELECTANYTABLESELECTondba_clustersEXECUTEonDBMS_FLASHBACK package GGS_GGSUSER_ROLE GRANTCONNECT,RESOURCE,DBATOogguser;ALTERUSERogguser QUOTA UNLIMITEDON<Tablespace_name>;execdbms_streams_auth.grant_...
从业8年DBA工作,在数据库领域有丰富的经验 擅长Oracle数据库运维开发,备份恢复,安装迁移,性能优化、故障应急处理等。 1. 2. 3. 4. 5. 6. 7. 8. 前言 近日在一套新搭建的OGG库上,启动REPA应用进程后,Error ORA-01031: insufficient privileges ,本文详细记录了报错的处理方法 1.查询报错日志 GGSCI (target)...
源端PUMP进程全部挂起,且启动失败 GGSCI23 > info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT ABENDED PUMP_KF 02:07:00 00:49:33 错误描述 --- 源端: GGSCI 34> view report PUMP_KF 2022-08-31 12:24:27 ERROR OGG-01031 There is a problem in network comm...
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...
简介: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...
ERROR OGG-01031 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-01031 There is a problem in network communication 故障现象,无法打开目标端/oracle/ogg/dirdat/c1000194trail文件 2022-02-2410:19:51ERROR OGG-01031Thereisa probleminnetwork communication , a remotefileproblem ,encryption keysfortargetandsource donotmatch (ifusing...
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...
故障原因 --- 网络异常,导致DP进程异常中断 故障现象 --- 源端DP 进程全部挂起,且启动失败 GGSCI 34> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT ABENDED DP_XXXX1 00:00:00 00:49:33 EXTRACT ABENDED DP_XXXX2 00:00:00 00:49:40 EXTRACT...
1.6.13 OGG-01031 goldengate源端意外宕机,导致OGG-01031报错 示例9-21: 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 Expected 4 bytes, but got...