ORA : Reset Password "Connect Internal" di Oracle DB 8.i

ini masalahnya yang buat 4 jam standby di server yang bersuhu 15 derajat C :

Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Password: ******
ORA-01017: invalid username/password; logon denied

SVRMGR> connect internal
Password:**********
ORA-01031: insufficient privileges

SVRMGR> connect internal
Password:&*^*^%%*&
ORA-01031: insufficient privileges

SVRMGR> exit

Server Manager complete.

---------- ke toilet dulu akh... mungkin aja di toilet akan ada informasi tentang passwordnya!!
.... tapi cuma dalam mimpi kali..!!! ngak ada inspirasi.
pertanyaan : gimana cara reset password secara passwordnya dibuat sejak 2003 hmm

ini jawabannya , pakai Oracle 8i... kalau 9i,10g etc, kemungkinan sama..... coba aja:

C:\>orapwd file=c:\oracle\ora81\database\pwdherru.ora password=herrudonk entries=5
C:\>set oracle_sid=herru
C:\>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Password:*****
Connected.

SVRMGR> startup nomount

alhamdulillah...........

lalu cek-and ricek :

SVRMGR> select tablespace_name, status from dba_data_files;
SVRMGR> select tablespace_name, status from dba_tablespaces;
SVRMGR> select group#,status,member from V$logfile;

-- tidur nyenyak!!