[20180211]关于oracle执行文件权限问题.txt-阿里云开发者社区

开发者社区> lfreeali> 正文

[20180211]关于oracle执行文件权限问题.txt

简介: [20180211]关于oracle执行文件权限问题.txt --//如果oracle用户一般建立2个用户组.一般oinstall,dba组.缺省指定组oinstall --//如果数据库在运行时修改oracle执行文件权限,会到处一些进程出现问题.
+关注继续查看

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

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
[20120104]稳定一条sql语句的执行计划.txt
[20120104]稳定一条sql语句的执行计划.txthttp://www.itpub.net/thread-1495845-1-1.htmlhttp://space.
441 0
[INS-30131] 执行安装程序验证所需的初始设置失败问题解决,windows下oracle安装步骤
[INS-30131] 执行安装程序验证所需的初始设置失败问题解决,windows下oracle安装步骤 配置: 系统:windows10 数据库:Oracle Database 12c 第 1 版 速览版: 1.0  问题:[INS-30131] 执行安装程序验证所需的初始设置失败,问题解决       问题原因及解决办法:       1.1因为用户文件中含
1981 0
Oracle学习笔记之与权限相关的视图
Oracle学习笔记之与权限相关的视图
106 0
oracle 执行计划
<p>1、设置计划</p> <p></p> <pre code_snippet_id="611012" snippet_file_name="blog_20150303_1_4592185" name="code" class="sql">explain plan for select * from ( select * from dun_search_view where 1=1
795 0
Xcode生成的可执行文件在哪里!
       很多iphone、ipad、xcode、mac os x初学者编了半天程序,结果找不到生成的可执行文件在哪里。实际上生成可发布的可执行程序需要进行一些设置。
883 0
+关注
lfreeali
熟悉oracle数据库性能优化,rman备份,数据库恢复技术.
2055
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
文娱运维技术
立即下载
《SaaS模式云原生数据仓库应用场景实践》
立即下载
《看见新力量:二》电子书
立即下载