• 触发器引起的ADG备库同步错误


    数据库alert日志报错ORA-16000,查看对应的trc文件,大致如下报错:

    *** 2020-10-27 14:09:03.340
    *** SESSION ID:(3340.75) 2020-10-27 14:09:03.340
    *** CLIENT ID:() 2020-10-27 14:09:03.340
    *** SERVICE NAME:(SYS$USERS) 2020-10-27 14:09:03.340
    *** MODULE NAME:(rman@jkadg (TNS V1-V3)) 2020-10-27 14:09:03.340
    *** ACTION NAME:() 2020-10-27 14:09:03.340

    Error in executing triggers on connect internal
    *** 2020-10-27 14:09:03.340
    dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
    ----- Error Stack Dump -----
    ORA-00604: error occurred at recursive SQL level 1
    ORA-16000: database open for read-only access
    ORA-06512: at line 2

    或者:

    *** 2020-10-27 14:17:36.669
    *** SESSION ID:(3196.279) 2020-10-27 14:17:36.669
    *** CLIENT ID:() 2020-10-27 14:17:36.669
    *** SERVICE NAME:() 2020-10-27 14:17:36.669
    *** MODULE NAME:(plsqldev.exe) 2020-10-27 14:17:36.669
    *** ACTION NAME:() 2020-10-27 14:17:36.669

    Skipped error 604 during the execution of RMW_INSPUR_ZONGZI.LOGON_TRIGGER

    *** 2020-10-27 14:17:36.669
    dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
    ----- Error Stack Dump -----
    ORA-00604: µÝ¹é SQL ¼¶±ð 1 ³öÏÖ´íÎó
    ORA-16000: ´ò¿ªÊý¾Ý¿âÒÔ½øÐÐÖ»¶Á·ÃÎÊ
    ORA-06512: ÔÚ line 2

    可见最终的错误线索均指向了备库连接或登录触发器,将主库的登录或连接触发器关闭,再次打开备库同步成功。

  • 相关阅读:
    ios 动态监听键盘输入法和高度
    [置顶] Android常用UI控件之PopupWindow
    Subsets II
    采用移位方法获取汉字编码
    wxPython利用pytesser模块实现图片文字识别
    Ubuntu下搭建Java开发环境
    贴心设计:打造高可用性的移动产品
    java 静态方法和实例方法的区别
    sql 2005 update语句
    ios状态栏操作
  • 原文地址:https://www.cnblogs.com/likingzi/p/13884989.html
Copyright © 2020-2023  润新知