ORA-01078 CRS-2674 ORA-01034

Oracle 11g RAC升级失败，直接删除升级目录，重启数据库，居然报错：

[oracle@rac01 ~]$ srvctl start database -d racdb

PRCR-1079 : Failed to start resource ora.racdb.db

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Process ID: 0

Session ID: 0 Serial number: 0

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Process ID: 0

Session ID: 0 Serial number: 0

ORA-01078: failure in processing system parameters

ORA-01078: failure in processing system parameters

CRS-2674: Start of 'ora.racdb.db' on 'rac01' failed

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Process ID: 0

Session ID: 0 Serial number: 0

CRS-2674: Start of 'ora.racdb.db' on 'rac02' failed

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

Process ID: 0

Session ID: 0 Serial number: 0

CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy

如是，尝试通过sqlplus方式单独启动实例

[oracle@rac01 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 22 15:19:25 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATA/racdb/spfileracdb.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATA/racdb/spfileracdb.ora

ORA-12547: TNS:lost contact

还是报错，貌似由于ASM上的配置文件不能读取导致。

SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS

---------------- ------------

+ASM1            STARTED

可以证明ASM实例是启动的。

通过asmcmd也可以在ASM下可以浏览文件，也可以创建文件，证明目录也是可以访问和使用的。

如是，找到 官方解释：

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 and later

Information in this document applies to any platform.

Symptoms

RAC Instance can be started using sqlplus but fails when using srvctl:

Case I:

$ srvctl start database -d cad

PRCR-1079 : Failed to start resource ora.cad.db

CRS-5017: The resource action "ora.cad.db start" encountered the following error:

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+RAC/cad/spfilecad.ora'

ORA-17503: ksfdopn:2 Failed to open file +RAC/cad/spfilecad.ora

ORA-27140: attach to post/wait facility failed

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

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid = 1002 (oinstall), current egid = 1001 (dba)

CRS-2674: Start of 'ora.cad.db' on 'racnode2' failed

CRS-2632: There are no more servers to try to place resource 'ora.cad.db' on that would satisfy its placement policy

Case II

$ srvctl start database -d nar

PRCR-1079 : Failed to start resource ora.nar.db

CRS-5017: The resource action "ora.nar.db start" encountered the following error:

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+NAR_DG/nar/spfilenar.ora'

ORA-17503: ksfdopn:2 Failed to open file +NAR_DG/nar/spfilenar.ora

ORA-27140: attach to post/wait facility failed

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

ORA-27301: OS failure message: Operation not permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid = 59800 (oinstall), current egid = 59802 (asmadmin)

. For details refer to "(:CLSN00107:)" in "/oracle/GRID/11203/log/dog1104/agent/crsd/oraagent_oracle/oraagent_oracle.log".

CRS-2674: Start of 'ora.nar.db' on 'racnode1' failed

Cause

For Case I, the issue is caused wrong group (dba) is chosen for "ASM Database Administrator","ASM Instance Administration Operator" and "ASM Instance Administrator"

group during installing grid infrastructure, while the ASM disks are owned by oinstall group.

This same issue is documented in

Bug 9786198- SRVCTL START DATABASE ORA-0178 FAILURE IN PROCESSING SYSTEM PARAMETERS

For Case II, the issue is caused by setuid and setgid bit missing for oracle binary under GRID_HOME, eg:

$ ls -l $GRID_HOME/bin/oracle

-rwxr-x--x oracle oinstall 166648778 Dec 7 15:26 oracle

The missing setuid and setgid bit causing oracle user access failure to ASM diskgroup even though the ASMADMIN group is set correctly.

Solution

For case I,

Either reinstall Grid Infrastructure, select correct group for ASM Instance Administrator - ASMADMIN (oinstall in this case which is the ASM disk owning group)

or

stop srvctl modify oracle binary group from oinstall to dba by renaming $GRID_HOME/bin/setasmgid to $GRID_HOME/bin/setasmgid.orig. Restore the group ownership of oracle binary to oinstall and startup instance using srvctl.

For case II,

Add setuid and setgid bit for oracle binary under $GRID_HOME/bin:

$ chmod 6751 $GRID_HOME/bin/oracle

The oracle binary for both GRID_HOME/bin and RDBMS ORACLE_HOME/bin should have 6751 permission, eg: -rwsr-s--x

根据上面的文档，找到这个文件

[root@rac01 ~]# cd /app/grid/11.2.0/bin/

[root@rac01 bin]# ls -la oracle

-rwxr-xr-x. 1 grid oinstall 184285581 Oct 12 17:44 oracle

按照上面文档给该文件授权

[root@rac01 bin]# chmod 6751 oracle

[root@rac01 bin]# ls -la oracle

-rwsr-s--x. 1 grid oinstall 184285581 Oct 12 17:44 oracle

尝试启动本地db，居然成功了。

[root@rac01 bin]# su - oracle

[oracle@rac01 ~]$ srvctl start instance -d racdb -i racdb1

[oracle@rac01 ~]$ 

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

转载于:http://blog.itpub.net/9399028/viewspace-774819/