非oracle用户无法登陆数据库 ora 12547

开发人员反映数据库服务器上非oracle用户无法登陆数据库

         报错信息：ORA-12547:TNS:lost contact以及

[sale@rac1 ~]$ sqlplus sale/sale

 

SQL*Plus: Release 11.2.0.4.0 Production onTue May 5 11:37:14 2015

 

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

 

ERROR:

ORA-27140: attach to post/wait facilityfailed

ORA-27300: OS system dependentoperation:invalid_egid failed with status: 1

ORA-27301: OS failure message: Operationnot permitted

ORA-27302: failure occurred at: skgpwinit6

ORA-27303: additional information: startupegid = 1200 (asmadmin), current egid

= 1000 (oinstall)

         根据以往经验，判断为$ORACLE_HOME/bin目录下的oracle权限问题，

         查看，发现该权限没有s

Chmod 755 oracle  

Chmod +s oracle

总结：ora12547 可能由多重原因导致，监听log过大适用于已经长期使用的数据库，oracle权限则适用于新建立的数据库