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

  • From: bao jiejie <baojiejie@xxxxxxxxx>
  • To: adar666@xxxxxxxxxxxx
  • Date: Wed, 25 Feb 2009 20:10:03 +0800

Thanks my friend， now i can go through
by;
comment all lines in sqlnet.ora
set oracle_sid=XXXX
sqlplus  sys as sysdba
>input the sys password
then login

i will try sqlplus "/ as sysdba" tomorrow , need i restart the service from
service manager for it?

Thanks a lot!

On Wed, Feb 25, 2009 at 7:22 PM, Yechiel Adar <adar666@xxxxxxxxxxxx> wrote:

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


-- 

("'-''-/").___..--''"'-._
 '7_ 7  )   '_.  (     ).'-.__.')
 (_Y_.)   ._   )  '._ '. ''-..-'
_.'--'_..-_/  /--'_.' ,'
(il),-''  (li),'  ((!.-'

Best regards，
Yours sincerely House
baojiejie@xxxxxxxxx

Other related posts:

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