備庫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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章