Windows XP环境下安装的数据库,使用sys登录时报ora-1031错误。
sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 – Production on M Mar 8 17:22:36 2010
Copyright (c) 1982, 2003, Oracle. All Rights Reserved.
ERROR:
ORA-1031: Insufficient privileges.
检查sqlnet.ora文件的配置:
SQLNET.AUTHENTICATION_SERVICES=(NTS)
重新修改配置如下:
SQLNET.AUTHENTICATION_SERVICES=(nts)
关于AUTHENTICATION_SERVICES参数有如下的常规设置:
none for no authentication methods, including Microsoft Windows native operating system authentication. When SQLNET.AUTHENTICATION_SERVICES is set to none, a valid user name and password can be used to access the database.
all for all authentication methods.
nts for Microsoft Windows native operating system authentication.
Related posts:

