今天突然发生的案例:数据库实例突然自己终止,造成业务中断

SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProdPL/SQL Release 10.2.0.1.0 - ProductionCORE    10.2.0.1.0     &...显示全部

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

PL/SQL Release 10.2.0.1.0 - Production

CORE    10.2.0.1.0      Production

TNS for 32-bit Windows: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

32位oracle 10g运行在64为winServer2003 企业版

===============================================================================

今天突然出现业务不能访问数据库的现象!

登录服务器查看:1、数据库服务都正常运行,磁盘可用空间很多

2、用PL/SQL连接不上

3、命令行运行sqlplus 用管理员重启数据库才恢复正常

查看服务器应用程序日志:

出现警告:Instance XXXXXXX    has been terminated.

再无其他日志可查,

分析数据库日志:

===========================================================================

Thread 1 advanced to log sequence 12262

  Current log# 3 seq# 12262 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\YFTM\REDO03.LOG

  Current log# 3 seq# 12262 mem# 1: D:\REDO_FILE\REDO03_1.LOG

Wed Mar 15 11:43:28 2017

Thread 1 advanced to log sequence 12263

  Current log# 1 seq# 12263 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\YFTM\REDO01.LOG

  Current log# 1 seq# 12263 mem# 1: D:\REDO_FILE\REDO01_1.LOG

Wed Mar 15 12:54:55 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_j000_2752.trc:

ORA-00600: 内部错误代码, 参数: [kssrmf_numa2], [48], [0xCF981E58], [0xD0EB8D74], [0xD0EB8D74], [], [], []

Wed Mar 15 12:54:56 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_j000_2752.trc:

ORA-00600: 内部错误代码, 参数: [kssrmf_numa2], [48], [0xCF981E58], [0xD0EB8D74], [0xD0EB8D74], [], [], []

Wed Mar 15 12:54:57 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_j000_2752.trc:

ORA-00603: ORACLE server session terminated by fatal error

ORA-00600: internal error code, arguments: [kssrmf_numa2], [48], [0xCF981E58], [0xD0EB8D74], [0xD0EB8D74], [], [], []

Wed Mar 15 12:55:21 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_pmon_3080.trc:

ORA-00600: internal error code, arguments: [kssrmf_numa2], [48], [0xCF981E58], [0xD0EB8D74], [0xD0EB8D74], [], [], []

Wed Mar 15 12:55:21 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_pmon_3080.trc:

ORA-00600: internal error code, arguments: [kssrmf_numa2], [48], [0xCF981E58], [0xD0EB8D74], [0xD0EB8D74], [], [], []

Wed Mar 15 12:55:21 2017

PMON: terminating instance due to error 472

Wed Mar 15 12:55:21 2017

Errors in file d:\oracle\product\10.2.0\admin\SSSSS\bdump\XXX_dbw0_4804.trc:

ORA-00472: PMON  process terminated with error

===============================================================================

XXX_j000_2752.trc日志不会分析,如有需要我会另贴出来,也不知道贴那部分,文件较大。

数据库实例莫名突然终止!  请大神帮忙分析分析!万分感谢

收起
参与23

查看其它 4 个回答sunxiaopeng10的回答

sunxiaopeng10sunxiaopeng10CTO东营方圆铜业

请关注下,相关时间段的告警日志

轻工业 · 2017-03-15
浏览3420

回答者

sunxiaopeng10
CTO东营方圆铜业
擅长领域: 服务器数据库系统运维

sunxiaopeng10 最近回答过的问题

回答状态

  • 发布时间:2017-03-15
  • 关注会员:6 人
  • 回答浏览:3420
  • X社区推广