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

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Wed, 25 Feb 2009 13:22:01 +0200

In windows you open a command prompt by:
start=>run=>cmd
in the windows that opens do:
set oracle_sid=xxxxx
then
sqlplus "/ as sysdba"

and you are in.

Adar Yechiel
Rechovot, Israel



bao jiejie wrote:

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，
Yours sincerely House
baojiejie@xxxxxxxxx <mailto:baojiejie@xxxxxxxxx>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2009