think

$ cat sqlnet.ora
TCP.nodelay=yes
TCP.validnode_checking=yes
TCP.invited_nodes=(192.168.100.11,192.168.100.12)
sqlnet.authentication_services=(none)
$ sqlplus

SQL*Plus: Release 9.2.0.8.0 – Production on Tue Jul 28 10:09:32 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 – 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 – Production

SQL>  show parameter remote_login    

NAME                                 TYPE        VALUE
———————————— ———– ——————————
remote_login_passwordfile            string      EXCLUSIVE

$ sqlplus “/ as sysdba”

SQL*Plus: Release 9.2.0.8.0 – Production on Tue Jul 28 10:10:52 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges
Enter user-name:

说明：
在sqlnet.ora文件加上sqlnet.authentication_services=(none)就限制了os论证。
注释这一行后，就可以使用os论证了。
特别指出，针对unix平台有效。

This entry was posted on Monday, July 27th, 2009 at 7:13 pm and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.