数据库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.340Error 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
可见最终的错误线索均指向了备库连接时或登录触发器动作时，将主库的登录或连接触发器关闭，再次打开备库同步成功。
文章评论