非oracle主机用户，加到dba组后报ORA-12547

feng1009

一个非oracle主机用户，加到dba组后
:~> uname -a
Linux DLS-DB1 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64 x86_64 x86_64 GNU/Linux

:~> sqlplus "/ as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Mar 12 10:38:32 2012
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:
:~> ls -lrt $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oracle dba 195892917 2010-01-22 19:22 /opt/oracle/app/product/11g/db/bin/oracle
--------------------------------------
查看metalink[ID 422173.1]
Cause
This could be due to
1. to kernel parameters settings
2. Incorrect permissions on the ORACLE executable
3. Insufficient ulimit setting for stack
4. $ORACLE_HOME/rdbms/lib/config.o is 0 bytes
5. Oracle binaries have not been linked correctly
6. A missing $ORACLE_HOME/dbs directory
7. Note that creating an empty dbs directory already solves this error and you can for instance shutdown the instance. However, you will obviously not be able to restart because of the missing parameter file. So, the dbs directory needs to be fully restored.

检查其他地方正常，判断应该为权限问题，执行如下操作

$ cd $ORACLE_HOME/bin

$ chmod 6751 oracle

在测试环境，数据库open的时候，直接修改权限后，没看到对数据库有啥影响。

因为生产环境有同样情况的数据库有几十套，没敢直接在生产上面修改。

现在想确认下，在生产环境，数据库open情况下，修改此权限100%没风险，thanks!

Maclean Liu(刘相兵

:~> ls -lrt $ORACLE_HOME/bin/oracle
-rwxr-x--x 1 oracle dba 195892917 2010-01-22 19:22 /opt/oracle/app/product/11g/db/bin/oracle

你这个oracle binary的属性确实不正常， 估计没有正常运行过 root.sh

[oracle@vrh8 ~]$ ls -l `which oracle`
-rwsr-s--x 1 oracle oinstall 108916389 Nov  7 03:44 /s01/oracle/product/10.2.0/db_1/bin/oracle

估计下面这个文件的权限也不正确

[oracle@vrh8 ~]$ ls -l `which oradism`
-r-sr-s--- 1 root oinstall 14931 Oct 20  2005 /s01/oracle/product/10.2.0/db_1/bin/oradism

不能保证100% 没有任何影响， 如果是生产环境及建议你 停机修改。