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

Sure it is up and running, but how you going to administer it without being able to get in with some decent privileges to get yourself a dba account

BTW It helps if you post the errors you are getting.

Jack

2009/2/25 harshan eppuram <harshan.eppuram_at_gmail.com>

> I am also new Windows. I believe you start services with
> You can still start it from service panel. Go to service panel, right click
> on OracleserviceSID and click on start.
>
> By this method you do not need sys or system password.
>
> Cheers
> Harshan
>
> On Wed, Feb 25, 2009 at 9:36 AM, Jack van Zanen <jack_at_vanzanen.com>wrote:
>
>> 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
>>
>
>
>
> --
> Harshan Eppurath
> 040-40214832
> 09392426435
>

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