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

You have to set it in sqlnet.ora as you commented all entries in that file 
meaning it was set to NONE by default. 
 


Date: Thu, 26 Feb 2009 08:47:15 +0800
Subject: Re: oracle 10g release 2 on windows, forget password
From: baojiejie@xxxxxxxxx
To: niall.litchfield@xxxxxxxxx
CC: adar666@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx

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



_________________________________________________________________
Windows Live™ Hotmail®…more than just e-mail. 
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_howitworks_022009

Other related posts: