A)ORA-01031: insufficient privileges

B)客户端用PL/SQL sys/pwd@*** as sysdba登录时出现同样的报错

C)服务器端remote_login_passwordfile设置

D)ORAPWD重新设置密码

################Errors###################

C:>sqlplus as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 3月 14 10:58:32 2008

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

ERROR:
ORA-01031: insufficient privileges

客户端用PL/SQL sys/pwd@*** as sysdba登录时出现同样的报错

################客户端配置################

客户端用户用sqlplus行程登录到服务器时报出ORA-01031: insufficient privileges

客户端sqlnet.ora设置
C:>type D:oracleproduct10.2.0db_1networkadminsqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

# NAMES.DIRECTORY_PATH= (TNSNAMES)

##############服务器端配置###################
$ oslevel
5.3.0.0
$ uname -a
AIX Db02 3 5 00028057D600

$ more sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT = 0

服务器端remote_login_passwordfile设置
SQL> show parameter remote_login_passwordfile

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

##################ORAPWD重新设置密码####################

C:>D:oracleproduct10.2.0db_1binorapwd.exe -help
Usage: orapwd file= password= entries= force=

where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA and force - whether to overwrit
e existing file (opt),
OPERs (opt),
There are no spaces around the equal-to (=) character.

C:>D:oracleproduct10.2.0db_1binorapwd.exe file=D:oracleproduct10.2.0db_1databasepwdorcl.ora password=sys force=y

orapwd命令中entries参数的作用 (http://blog.chinaunix.net/u/7667/showart_93939.html)