ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle RAC 11gR2 ORA-15055 ORA-27140 ORA-27300 ORA-27301 ORA-27302 ORA-27303

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

Linux操作系统 作者:zhangyudong1987 时间:2014-02-24 17:05:28 0 删除 编辑

        客户的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/21602877/viewspace-1087078/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-02-24

  • 博文量
    13
  • 访问量
    32556