Re: oracle 10g release 2 on windows, forget password(B

From: Jack van Zanen(B <jack_at_vanzanen.com>
Date: Wed, 25 Feb 2009 15:06:31 +1100
Message-ID: <77a615a70902242006ge5a3196x65327e1af2e84f17_at_mail.gmail.com>

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

Brgds

Jack

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
> baojiejie_at_gmail.com
>
>
>

-- 
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-l

Received on Tue Feb 24 2009 - 22:06:31 CST