This discussion is archived
1 Reply Latest reply: Mar 13, 2012 11:53 PM by 887455 RSS

DB crashes on surviving node while crashed node started database.

887455 Newbie
Currently Being Moderated
Dear Experts

My Configuration :-

1. Solaris 10
2. VCS 5.0
3. Oracle 9i RAC

Two Node Cluster

Node - 1 panic'ed due to a Hardware fault. After reset, VCS started Database on Node - 1 using specified pfile in VCS configuration. Due to manual mistake, specified pfile was altered by someone and cluster_database parameter was set to false. So, Node -1 started database instance in non clustered mode while Node - 2 was already running with clustered option. While DB was starting on Node-1, it crashed DB on Node-2 and also on itself. So both Databases crashed. We started Databases on both nodes manually with correct spfiles and no issues after that.

Queries :-

1. I am assuming DB on node-2 (and node-1 too) crashed due to parameter cluster_database=false (which should have been true). Am I correct on this? Mean is this expected to crash DB on Node - 2. Ideally, it should have crashed DB only on Node-1 and Node-2 Database should not have been crashed....

Any thoughts on this....

Kind Rgds
Rajendra

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points