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日志不会分析,如有需要我会另贴出来,也不知道贴那部分,文件较大。
数据库实例莫名突然终止! 请大神帮忙分析分析!万分感谢