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博客 ” ,链接:https://blog.itpub.net/181228/viewspace-1060931/ ,如需转载,请注明出处,否则将追究法律责任。