Re: oracle 10g release 2 on windows, forget password(B
Date: Wed, 25 Feb 2009 15:06:31 +1100
make sure your user account is in the ora_dba group and you should be able to set the oracle_sid and connect / as sysdba
you could also try with the new password file
connect sys/<newpwd> as sysdba
2009/2/25 bao jiejie <baojiejie_at_gmail.com>
> Dear all,
> I get an old db from someone who left the company.
> It is Oracle 10g R2 , but i do not have sys or system password, i have
> administrator privilege to that windows 2003 server where oracle locates.
> I can not do like Solaris
> export ORACLE_SID=XXX
> sqlplus / as sysdba to change sys or system password
> What can I do on a Windows platform?
> I tried
> ORAPWD file=XXX.dat password=manage
> but seems can not work
> Any one can help me ??
> Thanks a lot.
> '7_ 7 ) '_. ( ).'-.__.')
> (_Y_.) ._ ) '._ '. ''-..-'
> _.'--'_..-_/ /--'_.' ,'
> (il),-'' (li),' ((!.-'
> Best regards$B!$(B
> Yours sincerely House
-- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 24 2009 - 22:06:31 CST