GoldenGate 执行ddl_setup.sql出错 ORA-00942: table or view does not exist

最新推荐文章于 2024-05-15 17:12:26 发布
最新推荐文章于 2024-05-15 17:12:26 发布
阅读量505 收藏
点赞数 1
文章标签： 数据库

在部署GoldenGate DDL选项时，执行ddl_setup.sql脚本报错。虽然OGG用户已经拥有了DBA权限，仍然需要显示的赋予create table和create sequence才能通过。

1. 执行ddl_setup.sql脚本
SYS@PROD1 > @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:oggadmin

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

Check complete.

Using OGGADMIN as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGADMIN

CLEAR_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

CREATE_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

TRACE_PUT_LINE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

INITIAL_SETUP STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
1453/9                                   PL/SQL: SQL Statement ignored
1455/28                                  PL/SQL: ORA-00942: table or view does not exist
1464/9                                   PL/SQL: SQL Statement ignored
1466/28                                  PL/SQL: ORA-00942: table or view does not exist
1478/9                                   PL/SQL: SQL Statement ignored
1480/28                                  PL/SQL: ORA-00942: table or view does not exist
1485/9                                   PL/SQL: SQL Statement ignored
1487/28                                  PL/SQL: ORA-00942: table or view does not exist
1492/9                                   PL/SQL: SQL Statement ignored
1494/28                                  PL/SQL: ORA-00942: table or view does not exist
1499/9                                   PL/SQL: SQL Statement ignored

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
1501/28                                  PL/SQL: ORA-00942: table or view does not exist
1581/4                                   PL/SQL: SQL Statement ignored
1582/23                                  PL/SQL: ORA-00942: table or view does not exist
1584/4                                   PL/SQL: SQL Statement ignored
1585/23                                  PL/SQL: ORA-00942: table or view does not exist
1600/30                                  PL/SQL: ORA-00942: table or view does not exist
1600/4                                   PL/SQL: SQL Statement ignored
1602/30                                  PL/SQL: ORA-00942: table or view does not exist
1602/4                                   PL/SQL: SQL Statement ignored

DDL IGNORE TABLE
-----------------------------------
FAILED: Table does not exist

DDL IGNORE LOG TABLE
-----------------------------------
FAILED: Table does not exist

DDLAUX  PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
0/0                                      PL/SQL: Compilation unit analysis terminated
1/26                                     PLS-00304: cannot compile body of 'DDLAUX' without its
                                         specification

1/26                                     PLS-00905: object OGGADMIN.DDLAUX is invalid

SYS.DDLCTXINFO  PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

SYS.DDLCTXINFO  PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL HISTORY TABLE
-----------------------------------
FAILED: Table does not exist

DDL HISTORY TABLE(1)
-----------------------------------
FAILED: Table does not exist

DDL DUMP TABLES
-----------------------------------
FAILED: Table does not exist

DDL DUMP COLUMNS
-----------------------------------
FAILED: Table does not exist

DDL DUMP LOG GROUPS
-----------------------------------
FAILED: Table does not exist

DDL DUMP PARTITIONS
-----------------------------------
FAILED: Table does not exist

DDL DUMP PRIMARY KEYS
-----------------------------------
FAILED: Table does not exist

DDL SEQUENCE
-----------------------------------
FAILED: Sequence does not exist

GGS_TEMP_COLS
-----------------------------------
FAILED: Table does not exist

GGS_TEMP_UK
-----------------------------------
FAILED: Table does not exist

DDL TRIGGER CODE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
126/9                                    PL/SQL: SQL Statement ignored
128/28                                   PL/SQL: ORA-00942: table or view does not exist
133/26                                   PL/SQL: ORA-02289: sequence does not exist
133/5                                    PL/SQL: SQL Statement ignored
657/19                                   PLS-00905: object OGGADMIN.DDLAUX is invalid
657/5                                    PL/SQL: Statement ignored
919/30                                   PL/SQL: ORA-00942: table or view does not exist
919/4                                    PL/SQL: SQL Statement ignored

DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED
FROM "OGGADMIN" ."GGS_SETUP"
                 *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGGADMIN" ."GGS_SETUP"
                 *
ERROR at line 2:
ORA-00942: table or view does not exist

FROM "OGGADMIN" ."GGS_SETUP"
                 *
ERROR at line 2:
ORA-00942: table or view does not exist

LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/PROD1/trace/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
ERRORS detected in installation of DDL Replication software components (6)

Script complete.

2.执行一次禁用DDL脚本
@ddl_disable.sql


3. 查看OGG用户的角色，已经赋予了DBA角色
SYS@PROD1 > conn oggadmin/oggadmin
Connected.
OGGADMIN@PROD1 > select * from user_role_privs;

USERNAME                       GRANTED_ROLE                   ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
OGGADMIN                       CONNECT                        NO  YES NO
OGGADMIN                       DBA                            NO  YES NO
OGGADMIN                       RESOURCE                       NO  YES NO

4.显示添加权限，虽然该用户已经是DBA权限了
SYS@PROD1 > grant create table,create sequence to oggadmin;

5.再次执行@ddl_setup.sql,顺利通过
SYS@PROD1 > @ddl_setup.sql

Oracle GoldenGate DDL Replication setup script

Verifying that current user has privileges to install DDL Replication...

You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Oracle 10g source, the system recycle bin must be disabled. For Oracle 11g and later, it can be enabled.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.

Enter Oracle GoldenGate schema name:oggadmin

Working, please wait ...
Spooling to file ddl_setup_spool.txt

Checking for sessions that are holding locks on Oracle Golden Gate metadata tables ...

Check complete.

Using OGGADMIN as a Oracle GoldenGate schema name.

Working, please wait ...

DDL replication setup script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGGADMIN

CLEAR_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

CREATE_TRACE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

TRACE_PUT_LINE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

INITIAL_SETUP STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLVERSIONSPECIFIC PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLREPLICATION PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL IGNORE TABLE
-----------------------------------
OK

DDL IGNORE LOG TABLE
-----------------------------------
OK

DDLAUX  PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDLAUX PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

SYS.DDLCTXINFO  PACKAGE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

SYS.DDLCTXINFO  PACKAGE BODY STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL HISTORY TABLE
-----------------------------------
OK

DDL HISTORY TABLE(1)
-----------------------------------
OK

DDL DUMP TABLES
-----------------------------------
OK

DDL DUMP COLUMNS
-----------------------------------
OK

DDL DUMP LOG GROUPS
-----------------------------------
OK

DDL DUMP PARTITIONS
-----------------------------------
OK

DDL DUMP PRIMARY KEYS
-----------------------------------
OK

DDL SEQUENCE
-----------------------------------
OK

GGS_TEMP_COLS
-----------------------------------
OK

GGS_TEMP_UK
-----------------------------------
OK

DDL TRIGGER CODE STATUS:

Line/pos                                 Error
---------------------------------------- -----------------------------------------------------------------
No errors                                No errors

DDL TRIGGER INSTALL STATUS
-----------------------------------
OK

DDL TRIGGER RUNNING STATUS
------------------------------------------------------------------------------------------------------------------------
ENABLED

STAYMETADATA IN TRIGGER
------------------------------------------------------------------------------------------------------------------------
OFF

DDL TRIGGER SQL TRACING
------------------------------------------------------------------------------------------------------------------------
0

DDL TRIGGER TRACE LEVEL
------------------------------------------------------------------------------------------------------------------------
0

LOCATION OF DDL TRACE FILE
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/prod/PROD1/trace/ggs_ddl_trace.log

Analyzing installation status...

STATUS OF DDL REPLICATION
------------------------------------------------------------------------------------------------------------------------
SUCCESSFUL installation of DDL Replication software components

Script complete.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29047826/viewspace-1342395/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29047826/viewspace-1342395/

cuibaodun6837
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Oracle_GoldenGate_11.2.1.0.3 for Oracle_11g_linux_x64
01-30
Oracle GoldenGate是一款强大的数据复制软件，它允许实时的数据同步，为用户提供近实时的数据集成解决方案。在本案例中，我们关注的是Oracle GoldenGate的11.2.1.0.3版本，专为Oracle 11g数据库在Linux x64操作系统...
Oracle_GoldenGate_11.2.1.0.3 for Oracle_11g_windows_x64
01-30
Oracle GoldenGate 是一款高效的数据复制解决方案，主要用于实时数据同步和数据迁移。在Oracle数据库环境中，它提供了低延迟、高可用性的数据复制功能。本压缩包"Oracle_GoldenGate_11.2.1.0.3 for Oracle_11g_...
goldengate开启DDL配置@ddl_setup.sql执行报错
11-09 1477
开启DDL配置： 1、关闭数据库回收站： SQL>alter system set recyclebin=off scope=both; 2、编辑globals参数文件,标明支持DDL的GG对象存放在哪个schema下： GGSCI>view param ./globals GGSCHEMA ogg 如果由于某些特殊的需求自定义DDL相关对象的名称的话，可以通过重定义位于Gol...
OGG-奇葩的问题--ERRORS detected in installation of DDL Replication……
ciwang0891的博客
12-26 348
ogg开启ddl同步执行脚本@ddl_setup.sql 部分报错节选： 点击(此处)折叠或打开 * ...
OGG 两个故障案例处理
最新发布
shlei5580的专栏
05-15 416
在测试OGG双向同步时，在目标端配置了应用进程，在启动应用进程时发现有报错，打算删除该应用进程，在执行delete REPLICAT rtb删除时报如下错误，导致无法删除。
配置ogg ddl 运行 ddl_setup 报错处理方法
cucanqi9387的博客
12-04 375
c:\gg_11.2.1.3>sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on 星期六 11月 23 22:42:30 2013...
运行GoldenGate ddl_setup.sql脚本时报错*** Please move GOLDENGATE to its own tablespace
msdnchina的专栏@JiNan,ShanDong
12-19 5201
运行GoldenGate ddl_setup.sql脚本时报错*** Please move GOLDENGATE to its own tablespace
ogg在DDL语句同步时出现[Error code [942], ORA-00942的分析
还不算晕的专栏
01-28 2085
近期遇到一个配置了DDL同步的OGG环境，在同步时，在备库上出现同步异常，报错Fatal error executing DDL replication: error [Error code [942], ORA-00942:通过分析OGG的错误日志ggserr.log，可以发现在正常的DDL同步时，有个设置当前SCHEMA的操作，在同步出错时，OGG软件没有设置当前SCHEMA操作；此时使用O...
Oracle GoldenGate 12.2.0.2.2 for Oracle on Linux x86-64.zip
04-25
Oracle GoldenGate是一款强大的数据复制和实时数据集成工具，主要用于实现数据库间的实时同步和数据迁移。在Oracle GoldenGate 12.2.0.2.2版本中，它为Linux x86-64架构提供了全面的支持，确保在64位Linux环境中高效...
Drop goldengate用户时报ORA-00604 ORA-20782 ORA-06512问题解决
09-27
### 解决Drop Goldengate 用户时报ORA-00604 ORA-20782 ORA-06512问题 #### 一、问题背景与现象 在进行Oracle数据库管理过程中，经常会遇到需要删除用户的场景。当尝试执行`drop user goldengate cascade;`命令时，...
OGG_123014_fbo_ggs_Linux_x64_services_shiphome.zip
07-03
Oracle GoldenGate是Oracle公司推出的一款高效、实时的数据复制与集成工具，主要用于实现数据库之间的数据同步。在本案例中，我们讨论的是Oracle GoldenGate (OGG) 的12.3.0.1.4版本，这是一个适用于Linux x64平台的...
goldengate ddl_setup执行失败处理
cuidai4743的博客
09-06 352
ddl_setup执行失败处理 环境信息： ORACLE 11.2.0.4 RAC x64 OGG 11.2.1.0.1 报错提示： SQL> @ddl_setup.sql 提示表不存在...
rep进程删不掉-OCI Error ORA-00942: table or view does not exist (status = 942
huoshuyinhua的专栏
04-06 1568
昨天，搭一套ogg,配rep进程时由于复制的原来的语句，但实际上没有先加checkpointtable，结果rep进程abend，rep进程删不掉 GGSCI > info all Program     Status      Group       Lag at Chkpt  Time Since Chkpt MANAGER     STOPPED
ORA-04098: trigger 'SYS.GGS_DDL_TRIGGER_BEFORE' is invalid and failed re-validation
leo__1990的博客
06-18 5099
运行OGG DDL@ddl_setup.sql 时报错，提示以下信息： DDL TRIGGER RUNNING STATUS ---------------------------------------------------------------------- ENABLED FROM "OGG" ."GGS_SETUP" * ERROR at line 2: ...
【故障-ORACLE】GGS_STICK出来大量锁的问题
csdn0622的博客
05-04 684
SID SERIAL# USERNAME Term Resource Type TAB OWNER ID1 ID2 Lock Held Lock R...
GOLDENGATE RAC-RAC双向DDL同步
cizp35655的博客
09-25 158
1. 环境说明， 续上章RAC单向DDL同步。 2. 确认源库处于归档模式。SQL> archive log list;Database log mode Archive ModeAutomat...
(三)OGG单向DDL复制操作
翔之天空的专栏
07-29 2774
实验目的：在两台虚机模拟实现简单的单向的DDL复制(接上一篇《(二)OGG双向复制(DML操作)》)。 说明：因《(二)OGG双向复制(DML操作)》中已配置过双向的dml操作，所以本次配置内容在前一篇的基础之上(本次只添加单向的DDL复制操作内容)。 实验环境：64位系统 操作系统：rhel6.6-x86_64 数据库：oracle_11.2-x86-64 ...
oracle GoldenGate系列：（三）DDL的同步
cuiji5713的博客
10-25 295
GoldenGate的DDL复制概述 GoldenGate目前只支持oracle和teradata的ddl复制。 有两种配置方法 1.基于trigger的DDL 2.Native DLL ps：Native DLL方式...
OGG(oracle goldengate)实现oracle到oracle数据DDL同步
weixin_41229271的博客
09-23 1322
注：本篇文章是在已经配置过DML同步或者源端数据库已经开启归档、添加了附加日志等基础上记录的，如未设置，请参考另外一篇：https://blog.csdn.net/weixin_41229271/article/details/101196319 然后再进行下面的步骤。 源端在ogg安装目录下登陆数据库 SQL> @marker_setup.sql Marker setup scr...
ora-20783: oracle goldengate ddl replication setup
05-19
ORA-20783 is an error code that occurs when setting up Oracle GoldenGate DDL replication. This error is usually caused by an incorrect configuration of the DDL synchronization or by a permission issue...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值