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

        客户的Oracle 11.2.0.2 RAC for AIX其中一个节点已经有好几个月没有运行了，在MOUNT数据库的时候告警日志收到如下的报错信息：

ORA-00210: cannot open the specified control file

ORA-00202: control file: '+DATA1/smdb/controlfile/current.256.760106407'

ORA-17503: ksfdopn:2 Failed to open file +DATA1/smdb/controlfile/current.256.760106407

ORA-15001: diskgroup "DATA1" does not exist or is not mounted

ORA-15055: unable to connect to ASM instance

ORA-27140: attach to post/wait facility failed

ORA-27300: OS system dependent operation:invalid_euid failed with status: 1

ORA-27301: OS failure message: Not owner

ORA-27302: failure occurred at: skgpwinit5

ORA-27303: additional information: startup euid = 1000 (grid), current euid = 1001 (oracle)

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
  Symptoms
  Cause
  Solution

---

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
-----------------------

ORA-00210: cannot open control file
ORA-00202: error in writing''+RECODG/utsdb/controlfile/current.256.732754521''
ORA-17503: ksfdopn: 2 Failed to open file +RECODG/utsdb/controlfile/current.256.732754521
ORA-15001: diskgroup "RECODG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_euid failed with status: 1
ORA-27301: OS failure message: Not owner
ORA-27302: failure occurred at: skgpwinit5
ORA-27303: additional information: startup euid = 100 (grid), current euid = 101 (oracle)

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

$ sqlplus "/as sysdba"
SQL> startup

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":

$su - grid
$cd GI_HOME/bin
$chmod 6751 oracle
$ls -l oracle

3.Start the /CRS.

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

        文章地址：https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=804383329222295&_afrWindowMode=0&_adf.ctrl-state=10nvbyasjb_4

参考这篇文章执行了一下的操作：

1).在问题节点执行crsctl stop has停止HAS的运行。

2).修改GRID_HOME/bin/oracle文件权限。

smdb2@grid[/home/grid]cd $ORACLE_HOME/bin

smdb2@grid[/oracle/product/grid/bin]ls -al oracle

-rwxr-x--x    1 grid     oinstall  258657170 Aug 24 2011  oracle

smdb2@grid[/oracle/product/grid/bin]chmod 6751 oracle

smdb2@grid[/oracle/product/grid/bin]ls -al oracle

-rwsr-s--x    1 grid     oinstall  258657170 Aug 24 2011  oracle

        请注意GRID_HOME/bin/oracle文件权限修改前后的变化。

3).在问题节点执行crsctl start has启动HAS。

        数据库实例顺利启动。

        下面是在一个正常运行的节点收集了/dev/rhdisk*，$GRID_HOME/bin/oracle，$ORACLE_HOME/bin/oracle权限关系，特此保留以备查验：

smdb1@grid[/oracle/product/grid/bin]cd /dev/

smdb1@grid[/dev]ls -al rhdisk*

crw-------    2 root     system       21,  0 Jul 27 2011  rhdisk0

crw-------    1 root     system       21,  1 Aug 19 2011  rhdisk1

crw-rw----    1 grid     asmadmin     21, 10 Dec 31 19:40 rhdisk10

crw-rw----    1 grid     asmadmin     21, 12 Dec 31 19:01 rhdisk11

crw-rw----    1 grid     asmadmin     21,  9 Dec 31 19:40 rhdisk12

crw-rw----    1 grid     asmadmin     21,  8 Dec 31 17:01 rhdisk13

crw-rw----    1 grid     asmadmin     21, 14 Dec 31 19:00 rhdisk14

crw-rw----    1 grid     asmadmin     21,  2 Dec 31 19:40 rhdisk2

crw-rw----    1 grid     asmadmin     21,  3 Dec 31 19:40 rhdisk3

crw-rw----    1 grid     asmadmin     21,  4 Dec 31 19:40 rhdisk4

crw-rw----    1 grid     asmadmin     21,  5 Dec 31 19:40 rhdisk5

crw-rw----    1 grid     asmadmin     21, 11 Dec 31 19:40 rhdisk6

crw-rw----    1 grid     asmadmin     21, 13 Dec 31 18:55 rhdisk7

crw-rw----    1 grid     asmadmin     21,  7 Dec 31 19:18 rhdisk8

crw-rw----    1 grid     asmadmin     21,  6 Dec 31 19:14 rhdisk9

smdb1@grid[/dev]cd $ORACLE_HOME/bin/

smdb1@grid[/oracle/product/grid/bin]ls -al oracle

-rwsr-s--x    1 grid     oinstall  258657170 Aug 24 2011  oracle

smdb1@grid[/oracle/product/grid/bin]exit

# su - oracle

smdb1@oracle[/home/oracle]cd $ORACLE_HOME/bin

smdb1@oracle[/oracle/product/11.2.0/dbhome_1/bin]ls -al oracle

-rwsr-s--x    1 oracle   asmadmin  294657430 Aug 24 2011  oracle

        注意：oracle用户必须属于asmdba组（另外还属于dba和oper组），grid用户属于asmadmin,asmdba,asmoper组。

        相关文章：
        《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

        《 11gR2集群件任务角色分离（Job Role Separation）简介 》： https://blogs.oracle.com/Database4CN/entry/%E4%BB%BB%E5%8A%A1%E8%A7%92%E8%89%B2%E5%88%86%E7%A6%BB_job_role_separation_%E7%AE%80%E4%BB%8B

--end--

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23135684/viewspace-751960/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-751960/