ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 22 13:42:40 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

[@more@]
SQL> exit


$ id
uid=203(oracle) gid=203(oinstall) groups=204(dba)


为何在sqlnet.ora中添加两行后
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

就无法用操作系统验证登陆呢？

经过实验发现的确如此

一旦设置 SQLNET.AUTHENTICATION_SERVICES= (NTS) 默认就取消了操作系统认证

但是新问题又来了

D:oracleoracleproduct10.2.0dbNETWORKADMIN>type sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)


D:oracleoracleproduct10.2.0dbNETWORKADMIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on 星期日 4月 22 15:29:35 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba
已连接。
SQL>

这是NT平台上的测试结果

由此猜测 SQLNET.AUTHENTICATION_SERVICES = (NTS) 参数是否仅仅针对NT平台呢？？

再来实验一次：
D:oracleoracleproduct10.2.0dbNETWORKADMIN>type sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NONE)


D:oracleoracleproduct10.2.0dbNETWORKADMIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on 星期日 4月 22 15:34:18 2007

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: 权限不足






看来真是如此SQLNET.AUTHENTICATION_SERVICES 效果在UNIX上和NT上截然不同！

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7437037/viewspace-911946/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7437037/viewspace-911946/