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

  • From: bao jiejie <baojiejie@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Thu, 26 Feb 2009 08:47:15 +0800

yes, need set SQLNET.AUTHENTICATION_SERVICES = (NTS)

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

Other related posts:

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