非oracle用户使用sqlplus登录错误ORA-12547: TNS:lost contact

olti

环境版本：AIX 6.1 oracle 11.2.02
正常安装完数据库，新建了ogg用户，所属组为dba和oinstall。
settledb01:/ #id ogg
uid=1003(ogg) gid=510(dba) groups=511(oinstall)
listener状态也是正常：
settledb01:/oracle >lsnrctl status listener_settle
LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production on 13-AUG-2012 10:58:02
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sett_svc1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias listener_settle
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
Start Date 13-AUG-2012 10:48:34
Uptime 0 days 0 hr. 9 min. 28 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracle/app/oracle/product/11.02/db_1/network/admin/listener.ora
Listener Log File /oracle/app/oracle/product/11.02/db_1/network/log/listener_settle.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=173.16.2.36)(PORT=1521)))
Services Summary...
Service "settledb" has 2 instance(s).
Instance "settledb", status UNKNOWN, has 1 handler(s) for this service...
Instance "settledb", status READY, has 1 handler(s) for this service...
Service "settledbXDB" has 1 instance(s).
Instance "settledb", status READY, has 1 handler(s) for this service...
The command completed successfully
使用oracle用户登录，一切正常：
settledb01:/oracle >sqlplus goldengate/goldengate
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:58:48 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
settledb01:/oracle >sqlplus goldengate/goldengate@settledb
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:58:58 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
但是使用新建的系统用户ogg登录，出现如下情况：
settledb01:/ogg/software >sqlplus goldengate/goldengate@settledb
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:59:41 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
settledb01:/ogg/software >sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:39:28 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn /as sysdba
ERROR:
ORA-12547: TNS:lost contact
SQL> exit
报出了ORA-12547: TNS:lost contact错误。
检查$ORACLE_HOME/bin/oracle权限
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >ls -al oracle
-rwxr-xr-x 1 oracle oinstall 294663505 May 20 03:48 oracle
发现没有s权限。
解决措施：
增加$ORACLE_HOME/bin/oracle文件的s权限
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >chmod +s oracle
settledb01:/oracle/app/oracle/product/11.02/db_1/bin >ls -al oracle
-rwsr-sr-x 1 oracle oinstall 294663505 May 20 03:48 oracle
测试:
settledb01:/ #su - ogg
settledb01:/ogg/software >sqlplus /nolog
SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 13 10:46:12 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
故障解决

wendu

精典之极就是精斑!!!

xq8995209

站的更高，尿的更远。

常青树

你让我四分五裂活得行尸走肉我就让你情火焚身死的干脆利落