ORACLE9密码审计带来的错误观点

WIN2000下不小心删除了密码文件,导致不能进入系统.很小的一个问题................

fact: MS Windows NT
fact: Oracle Server - Enterprise Edition 8.1.7
symptom: Connect as INTERNAL fails
symptom: Connect fails from SVRMGRL
symptom: ORA-01031: insufficient privileges
symptom: Oracle_sid is set correctly
symptom: REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in initSID.ora
cause: Password file has become corrupted

fix:

Recreate a new password file as follows:-

1) Stop the OracleService<sid> from control panel/services (or control
panel/administrative tools/services for Win2k)
2) Delete the existing password file in ORACLE_HOME/database directory
3) At dos, cd to the ORACLE_HOME/database directory
4) Re-create the password file using orapwd

eg.

c:orace81oracledatabase>orapwd file=pwdORCL.ora password=oracle entries=5

(where 'oracle' is the new password for the 'INTERNAL' account and ORCL is the
sid name).  If step 3 is not followed - then the full path and filename will
have to be specified eg. file=c:ora81oracledatabasepwdORCL.ora

4) Re-start the OracleService<sid>.
5) set oracle_sid at dos eg.:-

set oracle_sid=orcl

6) connect to the database

svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal/oracle