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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 22:57:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.