一、官方文档说明
作用: Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
默认值 :None
一般可选值 :
NONE : no authentication methods. A valid username and password can be used to access the database.
ALL : all authentication methods .
NTS : Windows NT native authentication(An authentication method that enables a client single login access to a Windows NT server and a database running on the server) .
二、不同的操作系统中测试：
①Windows NT *.*
1 Microsoft Windows [版本 6.1.7601] 2 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 3 C:Windowssystem32>e: 4 E:>cd E:oracle11_2_0NETWORKADMIN 5 #sqlnet.ora文件不存在情况 6 E:oracle11_2_0NETWORKADMIN>dir sqlnet.ora 7 驱动器 E 中的卷没有标签。 8 卷的序列号是 38D0-2A35 9 E:oracle11_2_0NETWORKADMIN 的目录 10 找不到文件 11 E:oracle11_2_0NETWORKADMIN>sqlplus / as sysdba 12 SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 11 22:13:57 2011 13 Copyright (c) 1982, 2010, Oracle. All rights reserved. 14 ERROR: 15 ORA-01031: 权限不足 16 17 请输入用户名: 18 #NTS情况 19 E:oracle11_2_0NETWORKADMIN>more sqlnet.ora 20 SQLNET.AUTHENTICATION_SERVICES=(NTS) 21 E:oracle11_2_0NETWORKADMIN>sqlplus / as sysdba 22 SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 11 22:16:20 2011 23 Copyright (c) 1982, 2010, Oracle. All rights reserved. 24 25 连接到: 26 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production 27 With the Partitioning, Oracle Label Security, OLAP, Data Mining, 28 Oracle Database Vault and Real Application Testing options 29 #NONE情况 30 E:oracle11_2_0NETWORKADMIN>more sqlnet.ora 31 SQLNET.AUTHENTICATION_SERVICES=(NONE) 32 E:oracle11_2_0NETWORKADMIN>sqlplus / as sysdba 33 SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 11 22:17:18 2011 34 Copyright (c) 1982, 2010, Oracle. All rights reserved. 35 ERROR: 36 ORA-01031: 权限不足 37 38 请输入用户名: 39 #ALL情况 40 E:oracle11_2_0NETWORKADMIN>more sqlnet.ora 41 SQLNET.AUTHENTICATION_SERVICES=(ALL) 42 E:oracle11_2_0NETWORKADMIN>sqlplus / as sysdba 43 SQL*Plus: Release 11.2.0.1.0 Production on 星期五 11月 11 22:18:02 2011 44 Copyright (c) 1982, 2010, Oracle. All rights reserved. 45 ERROR: 46 ORA-12641: 验证服务无法初始化 47 48 请输入用户名:
②LINUX 系统
1 [oracle@report ~]$ cd /opt/oracle/product/10.2.0/db_1/network/admin/ 2 #NTS情况 3 [oracle@report admin]$ more sqlnet.ora 4 SQLNET.AUTHENTICATION_SERVICES = (NTS) 5 [oracle@report admin]$ sqlplus / as sysdba 6 SQL*Plus: Release 10.2.0.4.0 - Production on Fri Nov 11 22:03:51 2011 7 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 8 ERROR: 9 ORA-01031: insufficient privileges 10 11 Enter user-name: 12 #NONE情况 13 [oracle@report admin]$ more sqlnet.ora 14 SQLNET.AUTHENTICATION_SERVICES = (NONE) 15 [oracle@report admin]$ sqlplus / as sysdba 16 SQL*Plus: Release 10.2.0.4.0 - Production on Fri Nov 11 22:04:31 2011 17 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 18 ERROR: 19 ORA-01031: insufficient privileges 20 21 Enter user-name: 22 #ALL情况 23 [oracle@report admin]$ more sqlnet.ora 24 SQLNET.AUTHENTICATION_SERVICES = (ALL) 25 [oracle@report admin]$ sqlplus / as sysdba 26 SQL*Plus: Release 10.2.0.4.0 - Production on Fri Nov 11 22:05:07 2011 27 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 28 29 Connected to: 30 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production 31 With the Partitioning, OLAP, Data Mining and Real Application Testing options 32 #不存在sqlnet.ora文件情况 33 [oracle@report admin]$ ll sqlnet.ora 34 ls: sqlnet.ora: No such file or directory 35 [oracle@report admin]$ sqlplus / as sysdba 36 SQL*Plus: Release 10.2.0.4.0 - Production on Fri Nov 11 22:05:41 2011 37 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 38 39 Connected to: 40 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production 41 With the Partitioning, OLAP, Data Mining and Real Application Testing options