Posted by & filed under reference.

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:

  1. 11gR2 for Windows Release
  2. Cisco VPN Client x64 for Windows 7
  3. Config Oracle 10g VIP on Unix
  4. Cross-Platform Migration Using Transportable Database/Tablespace in 10g or later
  5. Oracle数据库产品发布计划