作者:IT邦德
中国DBA联盟(ACDU)成员,目前从事DBA及程序编程
(Web\java\Python)工作,主要服务于生产制造
现拥有 Oracle 11g OCP/OCM、
Mysql、Oceanbase(OBCA)认证
分布式TBase\TDSQL数据库、国产达梦数据库以及红帽子认证
从业8年DBA工作,在数据库领域有丰富的经验
B站主播Oracle、Mysql、PG实战课程,请搜索:jeames007
擅长Oracle数据库运维开发,备份恢复,安装迁移,性能优化、故障应急处理等。
前言
近日在一套新搭建的OGG库上,启动REPA应用进程后,Error ORA-01031: insufficient privileges ,本文详细记录了报错的处理方法1.查询报错日志
GGSCI (target) 3> view report repa
2.处理过程
根据报错提示,排查原因为OGG用户没有对HR用户表的操作权限导致
2.1 登陆目标库确认是否有权限
SYS@PROD> conn ogg/oracle
OGG@PROD> insert into hr.t1 (object_id,object_name) values (76838,'ogg_test');
2.2 源库及目标库授权
SYS@PROD> show user
USER is "SYS"
SYS@PROD> select TABLE_NAME from dba_tables where OWNER='HR';
select 'grant insert,update,delete on hr.'||TABLE_NAME||' to ogg;'
from dba_tables where OWNER='HR';
3.启动repa进程
GGSCI (target) 4> info all
GGSCI (target) 5> start repa
GGSCI (target) 6> info all
GGSCI (target) 7> view report repa
4.验证数据的同步性
##源库查询
[oracle@source ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 4 17:23:20 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@PROD> select count(*) from hr.t1;
COUNT(*)
----------
1
-----------------------------------------------------------------------------------
目标库查询
[oracle@target ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 4 17:23:44 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SYS@PROD> select count(*) from hr.t1;
COUNT(*)
----------
1
如果觉得文章对你有帮助,点赞、收藏、关注、评论,一键四连支持
您的批评指正是我写作的最大动力!
❤️ 技术交流可以 关注公众号:IT邦德 ❤️