forgot all dba password :(

From: Dan Yusuph <oradba_at_mail.kz>
Date: Sun, 11 May 2003 13:19:29 +0600
Message-ID: <b9kqpf$k9to6$1@ID-175901.news.dfncis.de>

aK <res1e24o_at_verizon.net>
wrote in message news:zblva.5848$TM6.3868_at_nwrddc02.gnilink.net...

aK> hi, i'm running 9i on redhat 7.3 and have used orapwd util to reset password
aK> for sys to "admin".
aK> For some reason, it is not working and i can't seem to get into sql prompt.
aK> i also tried sys/change_on_install, system/manager, sysman/oem_temp, but no
aK> success. Do i have to re-install whole thing? or is there anyway to re-set
aK> the password to the default value?

su - oracle
sqlplus /nolog
connect / as sysdba
alter user sys identified by anything;

Dan Received on Sun May 11 2003 - 02:19:29 CDT