Symptoms:
[oracle@gop-node2 bin]$ srvctl start instance -d huy -n gop-node2
PRCR-1013 : Failed to start resource ora.huy.db
PRCR-1064 : Failed to start resource ora.huy.db on node gop-node2
CRS-5017: The resource action "ora.huy.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/huy/spfilehuy.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/huy/spfilehuy.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 = 1000 (oinstall), current egid = 1200 (dba)
. For details refer to "(:CLSN00107:)" in "/u01/app/11.2.0/grid/log/gop-node2/agent/crsd/oraagent_oracle/oraagent_oracle.log".
CRS-2674: Start of 'ora.huy.db' on 'gop-node2' failed
This error is caused by permission misconfiguration with oracle excutable for both ORACLE_HOME and GI_HOME (Grid Home)For both $ORACLE_HOME/bin/oracle and $GI_HOME/bin/oracle executables required permission is:
[oracle@gop-node1 bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 203972171 Sep 6 2013 oracle
In order to set correct permission values use:
# chmod 6751 oracle
As result:
[oracle@gop-node2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/bin
[oracle@gop-node2 bin]$ ls -l oracle
-rwxr-x--x 1 oracle dba 203972171 Sep 6 2013 oracle
[oracle@gop-node2 bin]$ chmod 6751 oracle
-rwsr-s--x 1 oracle dba 203972171 Sep 6 2013 oracle
[oracle@gop-node2 ~]$ cd /u01/app/11.2.0/grid/bin/
[oracle@gop-node2 bin]$ ls -l oracle
-rwxr-x--x 1 oracle oinstall 203972171 Sep 6 2013 oracle
[oracle@gop-node2 bin]$ chmod 6751 oracle
[oracle@gop-node2 bin]$ ls -l oracle
-rwsr-s--x 1 oracle oinstall 203972171 Sep 6 2013 oracle
[oracle@gop-node2 bin]$ srvctl start instance -d huy -n gop-node2
-- Successull
Additional resources:
http://myorastuff.blogspot.com/2016/10/ora-27303-additional-information.html
https://www.hhutzler.de/blog/ora-27303-during-startup-of-a-rac-database/
Hiç yorum yok:
Yorum Gönder