数据库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
可见最终的错误线索均指向了备库连接或登录触发器,将主库的登录或连接触发器关闭,再次打开备库同步成功。