ogg不能实施初始化数据加载_OCI Error ORA-01031: insufficient privileges (status = 1031)

来源：互联网发布：淘宝收货时间最迟编辑：程序博客网时间：2024/06/11 16:08

ogg 实施初始化数据加载时，查看目标库，数据未能加载成功，

使用view report load1 , 或查看ggserr.log日志文件，出现下面的错误：

012-04-14 23:07:51  ERROR   OGG-01203  Oracle GoldenGate Capture for Oracle, load1.prm:  EXTRACT abending.2012-04-14 23:07:51  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, load1.prm:  PROCESS ABENDING.2012-04-14 23:12:52  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params load1.2012-04-14 23:23:45  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start extract load1.2012-04-14 23:23:45  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host 127.0.0.1 (START EXTRACT LOAD1 ).2012-04-14 23:23:45  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT LOAD1 starting.2012-04-14 23:23:45  INFO    OGG-01017  Oracle GoldenGate Capture for Oracle, load1.prm:  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.2012-04-14 23:23:45  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, load1.prm:  EXTRACT LOAD1 starting.2012-04-14 23:23:46  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, load1.prm:  EXTRACT LOAD1 started.2012-04-14 23:24:05  WARNING OGG-01194  Oracle GoldenGate Capture for Oracle, load1.prm:  EXTRACT task LOAD2 abended : OCI Error ORA-01031: insufficient privileges (status = 1031), SQL <INSERT INTO "SCOTT"."DEPT0" ("DEPTNO","DNAME","LOC") VALUES (:a0,:a1,:a2)>.

登录目标库，使用ogg用户对要同步的表进行insert操作:

SQL> conn ggs_owner/ggs_owner@raugh2Connected.SQL> insert into scott.dept0 values('1','hello','world');insert into scott.dept0 values('1','hello','world')                  *ERROR at line 1:ORA-01031: insufficient privileges

很明显，ogg用户没有对目标表进行dml操作的权限;对ogg用户赋于dml操作权限，重新启动 extract 进程，则初始化数据加载成功。

SQL> conn / as sysdbaConnected.SQL> grant select ,insert ,update,delete on scott.dept0 to ggs_owner;Grant succeeded.