$oracle bin,关于$ORACLE_HOME/bin/oracle文件属性

OS:AIX 7.1

DB:12.1.0.2.0 RAC

oracle@DB01:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on 5 17:54:59 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATADG/SGSOPEN/spfileSGSOPEN.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATADG/SGSOPEN/spfileSGSOPEN.ora

ORA-12547: TNS:lost contact

SQL> exit

--oracle 节点1异常

oracle@DB01:/home/oracle>ls -tl $ORACLE_HOME/bin/oracle

-rwxrwsrwx 1 oracle asmadmin 548483537 Jul 16 14:42 /oracle/app/oracle/product/12.1.0/db_1/bin/oracle

--grid 节点1异常

grid@DB01:/home/grid>ls -tl $ORACLE_HOME/bin/oracle

-rwxrwxrwx 1 grid oinstall 534880722 Jul 16 11:27 /oracle/app/12.1.0/grid/bin/oracle

--oracle 节点2正常

oracle@DB02:/home/oracle>ls -tl $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle asmadmin 548483537 Jul 16 14:46 /oracle/app/oracle/product/12.1.0/db_1/bin/oracle

--grid 节点2正常

grid@DB02:/home/grid>ls -tl $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 grid oinstall 534880722 Jul 16 11:32 /oracle/app/12.1.0/grid/bin/oracle

--分别设置oracle和grid用户的oracle文件权限为6751，如果属主不对记得修改属主

su - root

chmod 6751 /oracle/app/oracle/product/12.1.0/db_1/bin/oracle

chmod 6751 /oracle/app/12.1.0/grid/bin/oracle

chown oracle:asmadmin /oracle/app/oracle/product/12.1.0/db_1/bin/oracle

chown grid:oinstall /oracle/app/12.1.0/grid/bin/oracle

ls -ld /oracle/app/oracle/product/12.1.0/db_1/bin/oracle

ls -ld /oracle/app/12.1.0/grid/bin/oracle

Sun Jul 29 15:29:40 2018

Cluster communication is configured to use the following interface(s) for this instance

169.254.252.28

cluster interconnect IPC version: Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0

Starting background process PMON

Sun Jul 29 15:29:41 2018

Errors in file /oracle/app/oracle/diag/rdbms/sgsopen/WWJD2/trace/WWJD2_pmon_5899158.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: Not owner

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startup egid = 301 (oinstall), current egid = 309 (asmadmin)

Sun Jul 29 15:29:41 2018

USER (ospid: 5899158): terminating the instance due to error 27140

Sun Jul 29 15:29:42 2018

Instance terminated by USER, pid = 5899158

上面报错的原因是启动数据库的命令一直在sqlplus中的没有退出用户重新进入导致的

如果在修改oracle文件时数据库已经启动，那么再登陆数据库执行命令会提示如下：

SQL> shutdown immediate;

ERROR:

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 = 1100 (oinstall), current egid = 1201 (asmadmin)

这里修改回oracle:oinstall属组后可以正常关闭数据库

root@DB01:/>chmod -help

chmod: Not a recognized flag: e

Usage: chmod [-R] [-f] [-h] {u|g|o|a ...} {+|-|=} {r|w|x|X|s|t ...} File ...

chmod [-R] [-f] [-h] OctalNumber File ...

Changes the permission codes for files or directories.

u 表示该档案的拥有者

g 表示与该档案的拥有者属于同一个群体(group)者

o 表示其他以外的人

a 表示这三者皆是

r=4

w=2

x=1

+ 表示增加权限

- 表示取消权限

= 表示唯一设定权限