ERROR OGG-00222 及查看是否开启DDL

于 2013-03-31 22:19:06 发布
阅读量2.6k 收藏
点赞数
分类专栏： ogg
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/rgb_rgb/article/details/8744447
版权
ERROR   OGG-01489
%s/TB201301_/TB201304_/g


ERROR   OGG-00222


2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa06.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa06.prm:  PROCESS ABENDING.
2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa04.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa04.prm:  PROCESS ABENDING.
2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa05.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa05.prm:  PROCESS ABENDING.
2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa01.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa03.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa01.prm:  PROCESS ABENDING.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa03.prm:  PROCESS ABENDING.
2013-03-31 21:30:24  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa02.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_C contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:30:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa02.prm:  PROCESS ABENDING.


2013-03-31 21:54:06  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa06.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:06  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa06.prm:  PROCESS ABENDING.
2013-03-31 21:54:06  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa04.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:06  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa04.prm:  PROCESS ABENDING.
2013-03-31 21:54:07  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa05.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa05.prm:  PROCESS ABENDING.
2013-03-31 21:54:07  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa01.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa01.prm:  PROCESS ABENDING.
2013-03-31 21:54:07  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa02.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa02.prm:  PROCESS ABENDING.
2013-03-31 21:54:07  ERROR   OGG-00222  Oracle GoldenGate Delivery for Oracle, repa03.prm:  The column(s) used for the @RANGE filter for table 000.TB201304_S contain only NULL value(s) : There must be at least one non-NULL value present.
2013-03-31 21:54:07  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa03.prm:  PROCESS ABENDING.
2013-03-31 21:55:22  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): edit params repa01.


是否开启DDL

PC03:/orabak/ggs$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 31 20:40:04 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> @ddl_status.sql
Please enter the name of a schema for the GoldenGate database objects:
goldengate
Setting schema name to GOLDENGATE

DDLORA_GETTABLESPACESIZE STATUS:

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


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 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
----------------------------------------------------------------------
DISABLED

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

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

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

LOCATION OF DDL TRACE FILE
--------------------------------------------------------------------------------
/u01/app/diag/rdbms/sgerp5/sgerp5/trace/ggs_ddl_trace.log

Analyzing installation status...


STATUS OF DDL REPLICATION
--------------------------------------------------------------------------------
WARNING: DDL Trigger is NOT enabled. SUCCESSFUL installation of DDL Replication
software components

SQL> 
SQL> !ls *.sql
chkpt_ora_create.sql             ddl_ora9.sql                     ddl_trace_off.sql                demo_ora_pk_befores_insert.sql
ddl_cleartrace.sql               ddl_pin.sql                      ddl_trace_on.sql                 demo_ora_pk_befores_updates.sql
ddl_ddl2file.sql                 ddl_purgeRecyclebin.sql          ddl_tracelevel.sql               marker_remove.sql
ddl_disable.sql                  ddl_remove.sql                   demo_more_ora_create.sql         marker_setup.sql
ddl_enable.sql                   ddl_session.sql                  demo_more_ora_insert.sql         marker_status.sql
ddl_filter.sql                   ddl_session1.sql                 demo_ora_create.sql              params.sql
ddl_nopurgeRecyclebin.sql        ddl_setup.sql                    demo_ora_insert.sql              remove_seq.sql
ddl_ora10.sql                    ddl_status.sql                   demo_ora_lob_create.sql          role_setup.sql
ddl_ora10upCommon.sql            ddl_staymetadata_off.sql         demo_ora_misc.sql                sequence.sql
ddl_ora11.sql                    ddl_staymetadata_on.sql          demo_ora_pk_befores_create.sql

SQL> @ddl_enable.sql

Trigger altered.

SQL> @ddl_status.sql
Please enter the name of a schema for the GoldenGate database objects:
goldengate
Setting schema name to GOLDENGATE

DDLORA_GETTABLESPACESIZE STATUS:

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


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 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/diag/rdbms/sgerp5/sgerp5/trace/ggs_ddl_trace.log

Analyzing installation status...


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

 
rgb_rgb
关注
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值