[20180211]關於oracle執行檔案許可權問題.txt

[20180211]關於oracle執行檔案許可權問題.txt

--//如果oracle使用者一般建立2個使用者組.一般oinstall,dba組.預設指定組oinstall
--//如果資料庫在執行時修改oracle執行檔案許可權,會到處一些程式出現問題.測試如下:

1.環境:
$ id
uid=502(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)

--//修改許可權
$ ls -l $ORACLE_HOME/bin/oracle
-rwsr-s--- 1 oracle oinstall 239627073 2015-08-17 15:58:55 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle

$ chgrp dba $ORACLE_HOME/bin/oracle

$ ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--- 1 oracle dba 239627073 2015-08-17 15:58:55 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle

$chmod 6750 $ORACLE_HOME/bin/oracle

2.檢查alert.log
--//alert*.log,後臺出現大量錯誤.
Process m000 died, see its trace file
Process m000 died, see its trace file

Errors in file /u01/app/oracle/diag/rdbms/book/book/trace/book_j000_30595.trc:
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 = 502 (oinstall), current egid = 503 (dba)
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/book/book/trace/book_cjq0_24828.trc:
Process W000 died, see its trace file
Sun Feb 11 10:45:07 2018
Errors in file /u01/app/oracle/diag/rdbms/book/book/trace/book_j000_30603.trc:
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 = 502 (oinstall), current egid = 503 (dba)

--//跟蹤檔案:
Trace file /u01/app/oracle/diag/rdbms/book/book/trace/book_m000_25910.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1
System name:    Linux
Node name:  gxqyydg4
Release:    2.6.39-300.26.1.el5uek
Version:    #1 SMP Thu Jan 3 18:31:38 PST 2013
Machine:    x86_64
Instance name: book
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 25910, image: oracle@gxqyydg4 (M000)

*** 2018-02-11 10:15:44.400
Died during process startup with error 27140 (seq=58)
OPIRIP: Uncaught error 27140. Error stack:
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 = 502 (oinstall), current egid = 503 (dba)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--//注意下劃線提示,修改回來:

$ chgrp oinstall $ORACLE_HOME/bin/oracle
$ ls -l $ORACLE_HOME/bin/oracle
-rwxr-x--- 1 oracle oinstall 239627073 2015-08-17 15:58:55 /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/oracle
$ chmod 6750 $ORACLE_HOME/bin/oracle

--//問題消失.
--//單機環境一般不會出現,如果在rac環境,建立多個例項透過dbca配置,要有1個執行使用者管理組配置的過程,如果與前面不同,就會出現問題.