ORA-01031: insufficient privileges重新配置sys登入密碼

A)ORA-01031: insufficient privileges

B)客戶端用PL/SQL sys/pwd@*** as sysdba登入時出現同樣的報錯

C)伺服器端remote_login_passwordfile設定

D)ORAPWD重新設定密碼

[@more@]

################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)