ORACLE可执行文件的默认的权限为：
-rwsr-sr-x 如下：
[oracle@db2server ~]$ ls -ltr /u01/app/oracle/product/db11.2.0.3/bin/oracle
-rwsr-sr-x 1 oracle oinstall 192363463 Mar 10 20:49 /u01/app/oracle/product/db11.2.0.3/bin/oracle
这个S位比较重要，如果去掉S位，将会影响到服务器上其他OS账号的本地连接过程。
oracle@db2server ~]$ chmod 755 /u01/app/oracle/product/db11.2.0.3/bin/oracle
[oracle@db2server ~]$ ls -ltr /u01/app/oracle/product/db11.2.0.3/bin/oracle
-rwxr-xr-x 1 oracle oinstall 192363463 Mar 10 20:49 /u01/app/oracle/product/db11.2.0.3/bin/oracle
[oracle@db2server ~]$ su - yansp
Password:
[yansp@db2server ~]$ sqlplus test/test
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 28 18:31:55 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[yansp@db2server ~]$ exit
logout
通过TNS连接不会存在这个问题。
[yansp@db2server ~]$ sqlplus test/test@192.168.0.5/huateng
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 28 18:36:34 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
[oracle@db2server ~]$ chmod 6755 /u01/app/oracle/product/db11.2.0.3/bin/oracle
[oracle@db2server ~]$ su - yansp
Password:
[yansp@db2server ~]$ sqlplus test/test
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 28 18:32:28 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
仅供参考。