现象:
[oracle@gauntlet ~]$ sqlplus /'as sysdba'
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 8 15:34:55 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 8 15:34:55 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
1.查看sqlnet.ora文件
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
SQLNET.AUTHENTICATION_SERVICES= (NTS)
2.uname -a
Linux
x86_64 x86_64 x86_64 GNU/Linux
x86_64 x86_64 x86_64 GNU/Linux
3.SQLNET.AUTHENTICATION_SERVICES= (NTS) 注释掉(nts是win上面特有的)
4.[oracle@gauntlet admin]$ sqlplus /'as sysdba'
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 8 15:39:25 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
SQL>
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 8 15:39:25 2012
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
SQL>
5.正常登录