oracle 执行txt,[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个执行用户管理组配置的过程,如果与前面不同,就会出现问题.