Home » RDBMS Server » Server Administration » sys password lost on Windows (9.2.0.6 / Windows 2003)
sys password lost on Windows [message #404194] Wed, 20 May 2009 14:16 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

No one seems to remember the password for the sys or system user password for one of the databases.

Can you please let me know if there is any way to reset the password without touching the password file?

TIA
KV
Re: sys password lost on Windows [message #404195 is a reply to message #404194] Wed, 20 May 2009 14:22 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Forgot to mention that I am not able to login to the database as of now.

I have all the required privileges. Still when I try to login as ' / as sysdba' i get the error 'insufficient privileges

KV
Re: sys password lost on Windows [message #404196 is a reply to message #404195] Wed, 20 May 2009 14:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is ORACLE_SID set in your environment?
Do you have access to any other DBA account?

[Updated on: Wed, 20 May 2009 14:37]

Report message to a moderator

Re: sys password lost on Windows [message #404197 is a reply to message #404196] Wed, 20 May 2009 15:05 Go to previous message
kudur_kv
Messages: 75
Registered: February 2005
Member
figured it out with the help of an old entry in ORAFAQ.

Needed to simply put in NTS in the sqlnet.ora instead of NONE.

Thank you for your help!

KV
Previous Topic: Windows' ora_<SID>_dba group equivalant in UNIX
Next Topic: How to include database name in dbca
Goto Forum:
  


Current Time: Thu Dec 08 02:08:15 CST 2016

Total time taken to generate the page: 0.05572 seconds