SQLNET.AUTHENTICATION_SERVICES值在不同操作系统下的含义

来源：互联网发布：美图秀秀 mac版编辑：程序博客网时间：2024/05/17 00:15

环境：

oracle11g
SQL> show parameter remote_login_passwordfile

NAME TYPE VALUE
------------------------------------ ----------- -----------
remote_login_passwordfile string EXCLUSIVE

win7系统：
当SQLNET.AUTHENTICATION_SERVICES= (NTS)，登录成功
C:\Users\thinkpad>sqlplus " / as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on 星期日 4月 15 21:44:35 2012

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

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER 为 "SYS"

当SQLNET.AUTHENTICATION_SERVICES= (NONE)，登录提示权限不足
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开

C:\Users\thinkpad>sqlplus " / as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on 星期日 4月 15 21:51:23 2012

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

ERROR:
ORA-01031: insufficient privileges

当SQLNET.AUTHENTICATION_SERVICES= (ALL)，提示验证服务无法初始化
C:\Users\thinkpad>sqlplus " / as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on 星期日 4月 15 21:52:21 2012

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

ERROR:
ORA-12641: 验证服务无法初始化

当SQLNET.AUTHENTICATION_SERVICES这行注释后，提示权限不足
C:\Users\thinkpad>sqlplus " / as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on 星期日 4月 15 21:53:24 2012

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

ERROR:
ORA-01031: insufficient privileges

linux系统(cemtos5.3)
当SQLNET.AUTHENTICATION_SERVICES= (NTS)或SQLNET.AUTHENTICATION_SERVICES= (NONE)，登录提示权限不足
[oracle@localhost ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 22:08:12 2012

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

ERROR:
ORA-01031: insufficient privileges

当SQLNET.AUTHENTICATION_SERVICES= (NTS)注释或SQLNET.AUTHENTICATION_SERVICES= (ALL)，登录成功

[oracle@localhost ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Sun Apr 15 22:08:39 2012

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

说明：
1.在http://hi.baidu.com/%EE%D1%D7%D300544/blog/item/a546e0ee1c4eb4ecb3fb9569.html该文章中说在windows系统中，设为ALL时是可以认证，但是我的实验了几次都不行，设为ALL后都提示“验证服务无法初始化”，不知道是不是因为oracle版本问题还是我的是win7问题。

2.NTS看来只是对xp系统的认证可行

3.NTS:操作系统认证
NONE:口令文件认证