$ 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平台有效。