ERROR OGG-00222 及查看是否开启DDL
来源:互联网 发布:网络神曲 编辑:程序博客网 时间:2024/06/10 20:30
ERROR OGG-01489
%s/TB201301_/TB201304_/g
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.
%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 sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 31 20:40:04 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Data Miningand Real Application Testing optionsSQL> @ddl_status.sqlPlease enter the name of a schema for the GoldenGate database objects:goldengateSetting schema name to GOLDENGATEDDLORA_GETTABLESPACESIZE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsCLEAR_TRACE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsCREATE_TRACE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsTRACE_PUT_LINE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsINITIAL_SETUP STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLVERSIONSPECIFIC PACKAGE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLREPLICATION PACKAGE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLREPLICATION PACKAGE BODY STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDL HISTORY TABLE-----------------------------------OKDDL HISTORY TABLE(1)-----------------------------------OKDDL DUMP TABLES-----------------------------------OKDDL DUMP COLUMNS-----------------------------------OKDDL DUMP LOG GROUPS-----------------------------------OKDDL DUMP PARTITIONS-----------------------------------OKDDL DUMP PRIMARY KEYS-----------------------------------OKDDL SEQUENCE-----------------------------------OKGGS_TEMP_COLS-----------------------------------OKGGS_TEMP_UK-----------------------------------OKDDL TRIGGER CODE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDL TRIGGER INSTALL STATUS-----------------------------------OKDDL TRIGGER RUNNING STATUS----------------------------------------------------------------------DISABLEDSTAYMETADATA IN TRIGGER----------------------------------------------------------------------OFFDDL TRIGGER SQL TRACING----------------------------------------------------------------------0DDL TRIGGER TRACE LEVEL----------------------------------------------------------------------0LOCATION OF DDL TRACE FILE--------------------------------------------------------------------------------/u01/app/diag/rdbms/sgerp5/sgerp5/trace/ggs_ddl_trace.logAnalyzing installation status...STATUS OF DDL REPLICATION--------------------------------------------------------------------------------WARNING: DDL Trigger is NOT enabled. SUCCESSFUL installation of DDL Replicationsoftware componentsSQL> SQL> !ls *.sqlchkpt_ora_create.sql ddl_ora9.sql ddl_trace_off.sql demo_ora_pk_befores_insert.sqlddl_cleartrace.sql ddl_pin.sql ddl_trace_on.sql demo_ora_pk_befores_updates.sqlddl_ddl2file.sql ddl_purgeRecyclebin.sql ddl_tracelevel.sql marker_remove.sqlddl_disable.sql ddl_remove.sql demo_more_ora_create.sql marker_setup.sqlddl_enable.sql ddl_session.sql demo_more_ora_insert.sql marker_status.sqlddl_filter.sql ddl_session1.sql demo_ora_create.sql params.sqlddl_nopurgeRecyclebin.sql ddl_setup.sql demo_ora_insert.sql remove_seq.sqlddl_ora10.sql ddl_status.sql demo_ora_lob_create.sql role_setup.sqlddl_ora10upCommon.sql ddl_staymetadata_off.sql demo_ora_misc.sql sequence.sqlddl_ora11.sql ddl_staymetadata_on.sql demo_ora_pk_befores_create.sqlSQL> @ddl_enable.sqlTrigger altered.SQL> @ddl_status.sqlPlease enter the name of a schema for the GoldenGate database objects:goldengateSetting schema name to GOLDENGATEDDLORA_GETTABLESPACESIZE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsCLEAR_TRACE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsCREATE_TRACE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsTRACE_PUT_LINE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsINITIAL_SETUP STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLVERSIONSPECIFIC PACKAGE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLREPLICATION PACKAGE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDLREPLICATION PACKAGE BODY STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDL HISTORY TABLE-----------------------------------OKDDL HISTORY TABLE(1)-----------------------------------OKDDL DUMP TABLES-----------------------------------OKDDL DUMP COLUMNS-----------------------------------OKDDL DUMP LOG GROUPS-----------------------------------OKDDL DUMP PARTITIONS-----------------------------------OKDDL DUMP PRIMARY KEYS-----------------------------------OKDDL SEQUENCE-----------------------------------OKGGS_TEMP_COLS-----------------------------------OKGGS_TEMP_UK-----------------------------------OKDDL TRIGGER CODE STATUS:Line/pos--------------------Error-----------------------------------------------------------------No errorsNo errorsDDL TRIGGER INSTALL STATUS-----------------------------------OKDDL TRIGGER RUNNING STATUS----------------------------------------------------------------------ENABLEDSTAYMETADATA IN TRIGGER----------------------------------------------------------------------OFFDDL TRIGGER SQL TRACING----------------------------------------------------------------------0DDL TRIGGER TRACE LEVEL----------------------------------------------------------------------0LOCATION OF DDL TRACE FILE--------------------------------------------------------------------------------/u01/app/diag/rdbms/sgerp5/sgerp5/trace/ggs_ddl_trace.logAnalyzing installation status...STATUS OF DDL REPLICATION--------------------------------------------------------------------------------SUCCESSFUL installation of DDL Replication software componentsSQL> SQL> SQL>
- ERROR OGG-00222 及查看是否开启DDL
- 查看端口是否开启
- ERROR OGG-00524 DDL trace log file [\ggs_ddl_trace.log], error code -20782 error message ORA-207
- OGG DDL 双向同步
- ogg单向DDL复制
- OGG DDL 操作详解
- sqlserver ogg 手动ddl
- ogg之ddl配置
- OGG Configuring DDL Support
- linux 查看防火墙是否开启
- OGG oracle DDL双向复制
- OGG单向复制(支持DDL)
- CENTOS6.5一步一步安装OGG实现DML DDL SEQUENCE序列单向复制及服务器故障恢复
- mysql binlog开启及查看
- Ubuntu查看ssh服务是否开启
- android中查看服务是否开启
- DOS下查看某服务是否开启
- linux 如何查看防火墙是否开启
- DirectX 3D_基础之光照 材质 顶点法线 光源 纹理映射 纹理坐标 多级纹理 纹理过滤
- asp.net实验二:连接sql server 2008数据库
- 《学习OpenCV》练习题第二章第四题
- C++学习笔记之函数返回值
- 又是指针
- ERROR OGG-00222 及查看是否开启DDL
- Win7 X32MyEclipse10.1破解
- 大话存储系列19——数据备份与恢复 下
- 计算机经典书籍
- 网站开发人员应该知道的61件事
- Hadoop中Mapper和Reducer是单独进程还是线程
- 错误纠正(Error Correction)
- Android常见错误解决
- c++多线程编程