備庫open read only報錯,經查是有一個trigger在open後觸發

wenzai169發表於2013-09-21

Errors in file /oracle/admin/hc0/udump/hc01_ora_25891.trc:
ORA-07445: exception encountered: core dump [opiexe()+20504] [SIGSEGV] [Address not mapped to object] [0x0000001D4] [] []
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
Sat Sep 21 12:09:50 2013
Trace dumping is performing id=[cdmp_20130921120950]


** 2013-09-21 12:09:48.649
*** SERVICE NAME:(SYS$USERS) 2013-09-21 12:09:48.649
*** SESSION ID:(1086.3) 2013-09-21 12:09:48.649
kswsupdsvc: unexpected exception err=604, err2=16000
kswsupdsvc: unexpected exception err=604, err2=16000
kswsvalthr : db is either standby mount or readonly
kswssetupaq : db is either standby mount or readonly
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x1d4, PC: [0x23b7d90, opiexe()+20504]
*** 2013-09-21 12:09:49.051
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [opiexe()+20504] [SIGSEGV] [Address not mapped to object] [0x0000001D4] [] []
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
Current SQL statement for this session:

雖然報錯,但資料庫確實是open起來了,且可以用普通使用者登陸,之前一直排查記憶體不夠方面的問題,沒有找對方向

後面檢查資料庫級別的trigger終於有所發現,可以disable掉trigger,也可能忽略此錯誤

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/181228/viewspace-1060931/,如需轉載,請註明出處,否則將追究法律責任。

相關文章