Oracle RAC 11gR2 ORA-15055 ORA-27140 ORA-27300 ORA-27301 ORA-27302 ORA-27303

ORA-205 signalled during: ALTER DATABASE   MOUNT...

從METALINK上搜尋，找到如下的文章：
Startup Instance Failed with ORA-27140 ORA-27300 ORA-27301 ORA-27302 and ORA-27303 on skgpwinit6 [ID 1274030.1]
修改時間:2011-10-25型別:PROBLEM狀態:PUBLISHED優先順序:3

In this Document
  
  
  

---

Applies to:

Oracle Server - Standard Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

On : 11.2.0.1 version, Real Application Cluster

When attempting to start database as oracle user, the following errors are seen in alert log.

ERROR
-----------------------



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Cause

The issue is caused by wrong permission of the GI_HOME/bin/oracle executable.

In one case, customer changed the file permission of GI_HOME/bin/oracle from "-rwsr-s--x" to "-rwxrwxr-x".
The correct permission should be "-rwsr-s--x".

Solution

1. Stop the CRS.
2. Change the file permission of GI_HOME/bin/oracle to "-rwsr-s--x":


3.Start the /CRS.

4.Test if you can startup the rdbms database using oracle user.

        文章地址：

參考這篇文章執行了一下的操作：

1).在問題節點執行crsctl stop has停止HAS的執行。

2).修改GRID_HOME/bin/oracle檔案許可權。
        請注意GRID_HOME/bin/oracle檔案許可權修改前後的變化。

3).在問題節點執行crsctl start has啟動HAS。

        資料庫例項順利啟動。

        下面是在一個正常執行的節點收集了/dev/rhdisk*，$GRID_HOME/bin/oracle，$ORACLE_HOME/bin/oracle許可權關係，特此保留以備查驗：


        相關文章：
        《11gR2 for AIX使用dbca建立資料庫遇到ORA-03113錯誤的案例》http://space.itpub.net/23135684/viewspace-743093，文章重點討論的是$GRID_HOME/bin/oracle和$ORACLE_HOME/bin/oracle兩個檔案的所有者、組和/dev/rhdisk*的對應關係；而這篇文章重點討論的是$GRID_HOME/bin/oracle和$ORACLE_HOME/bin/oracle兩個檔案的許可權和/dev/rhdisk*的對應關係。

        《11gR2 RAC dbca無法發現ASM磁碟組》：http://space.itpub.net/?uid-23135684-action-viewspace-itemid-676632