8/28/11

ORA-00210,ORA--00202,ORA-17503,ORA-5001,ORA-27140,ORA-27300-3 while Installing RAC database


After Successfully installed GI, I try to install RAC database but I got the following Error message:

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)


The eeror message is little bit confusing because it complaints about "ASM" but infact ASM is working fine, but the problem is permission of "oracle" executables.

Cause
The issue is caused by wrong permissions 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. 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

No comments:

Post a Comment