- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:29:01
|
查看: 1764 |
回复: 0
生产库最近总是自动关闭, 看了日志 SMON进程遇到了致命错误 造成Oracle关闭,查不出什么原因
下面是alter 日志
/opt/app/oracle/admin/jqdb/bdump/jqdb_smon_3578.trc
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/app/oracle/product/9.2.0
System name: Linux
Node name: server1.localdomain
Release: 2.6.9-42.7AXsmp
Version: #1 SMP Wed Jan 10 11:12:02 EST 2007
Machine: i686
Instance name: jqdb
Sun May 13 21:33:06 2012
Errors in file /opt/app/oracle/admin/jqdb/bdump/jqdb_smon_3578.trc:
ORA-00600: internal error code, arguments: [4042], [8], [], [], [], [], [], []
Sun May 13 21:33:07 2012
Fatal internal error happened while SMON was doing reading of broadcast messages.
Sun May 13 21:33:07 2012
Errors in file /opt/app/oracle/admin/jqdb/bdump/jqdb_smon_3578.trc:
ORA-00600: internal error code, arguments: [4042], [8], [], [], [], [], [], []
SMON: terminating instance due to error 600
Instance terminated by SMON, pid = 3578
Mon May 14 10:30:25 2012
|
|