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

all method works fine.

either sqlplus sys as sysdba or sqlplus "/ as sysdba" works fine.

Thanks a lot.

On Wed, Feb 25, 2009 at 9:59 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> You will need to leave the sqlnet.authentication_services=(nts) line
> in the sqlnet profile to use os authentication.
>
> On 2/25/09, bao jiejie <baojiejie_at_gmail.com> wrote:
> > 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_at_inter.net.il>
> 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_at_gmail.com
> >>
> >>
> >>
> >
> >
> > --
> >
> > ("'-''-/").___..--''"'-._
> > '7_ 7 ) '_. ( ).'-.__.')
> > (_Y_.) ._ ) '._ '. ''-..-'
> > _.'--'_..-_/ /--'_.' ,'
> > (il),-'' (li),' ((!.-'
> >
> > Best regards，
> > Yours sincerely House
> > baojiejie_at_gmail.com
> >
>
> --
> Sent from Google Mail for mobile | mobile.google.com
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 

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

Best regards，
Yours sincerely House
baojiejie_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l