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

尛樣兒發表於2012-12-31
Oracle

        客戶的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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章