背景介绍:
这是一套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