TXF-SPAC:/home/txfspac>sqlplus pacdbuser/pac123
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 28 01:28:54 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 28 01:28:54 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:
ERROR:
ORA-12547: TNS:lost contact
其他用户登录报错,必须@orcl 才能登录
检查$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:/oracle/app/oracle/product/11.02/db_1/bin >ls -al oracle
-rwsr-sr-x 1 oracle oinstall 294663505 May 20 03:48 oracle
再登录问题解决