转://ORA-00603,ORA-27501,ORA-27300,ORA-27301,ORA-27302故障案例一则

最新推荐文章于 2022-06-06 17:38:56 发布

weixin_33978044

最新推荐文章于 2022-06-06 17:38:56 发布

阅读量194

点赞数

CC 4.0 BY-SA版权

文章标签：数据库操作系统

原文链接：http://www.cnblogs.com/zfox2017/p/8584461.html

本文记录了一次在Windows RAC系统中遇到的ORA-00474错误及一系列相关错误的详细日志信息。通过分析alert日志中的关键内容，可以了解SMON进程终止的原因及其对数据库的影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

背景介绍：

这是一套windows的rac系统。数据库后台日志报ORA-00474:SMON process terminated with error。接着报ORA-00603,ORA-27501,ORA-27300,ORA-27301,ORA-27302等错误。

问题分析：

1.数据库alert日志

Fri Feb 28 04:12:09 2014
Reconfiguration started (old inc 32, new inc 34)
List of nodes:

 Global Resource Directory frozen
 * dead instance detected - domain 0 invalid = TRUE 
 Communication channels reestablished
 Master broadcasted resource hash value bitmaps
 Non-local Process blocks cleaned out
Fri Feb 28 04:12:09 2014
 LMS 2: 0 GCS shadows cancelled, 0 closed
Fri Feb 28 04:12:10 2014
 LMS 1: 0 GCS shadows cancelled, 0 closed
Fri Feb 28 04:12:11 2014
 LMS 3: 0 GCS shadows cancelled, 0 closed
Fri Feb 28 04:12:12 2014
 LMS 0: 2 GCS shadows cancelled, 2 closed
 Set master node info 
 Submitted all remote-enqueue requests
 Dwn-cvts replayed, VALBLKs dubious
 All grantable enqueues granted
 Post SMON to start 1st pass IR
Fri Feb 28 04:12:12 2014
Instance recovery: looking for dead threads
Fri Feb 28 04:12:12 2014
 LMS 3: 10102 GCS shadows traversed, 0 replayed
Fri Feb 28 04:12:12 2014
 LMS 1: 10083 GCS shadows traversed, 0 replayed
Fri Feb 28 04:12