Home » RDBMS Server » Security » lost sys and system passwords
lost sys and system passwords [message #421951] Sat, 12 September 2009 02:47 Go to next message
babar82
Messages: 108
Registered: March 2009
Location: Karachi
Senior Member
Hi,

I have lost both sys and system passwords. How can I recover / reset both of them. I m using Oracle 10g...
Re: lost sys and system passwords [message #421953 is a reply to message #421951] Sat, 12 September 2009 03:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Connect to the server as a user in the sysdba OS group (usely "dba" in Unix) and connect "/ as sysdba" then you can change the passwords.

Regards
Michel
Re: lost sys and system passwords [message #424451 is a reply to message #421951] Fri, 02 October 2009 07:59 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
There is no chance that we are lost the sys and system passwords.If not change the password also.There should be the default password.

Thanks,
Afroze

[Updated on: Fri, 02 October 2009 08:00]

Report message to a moderator

Re: lost sys and system passwords [message #424452 is a reply to message #424451] Fri, 02 October 2009 08:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
There is no chance that we are lost the sys and system passwords.

Why? Don't you never lose your passwords?

Quote:
If not change the password also.

What does this mean?

Regards
Michel
Re: lost sys and system passwords [message #424457 is a reply to message #424451] Fri, 02 October 2009 08:14 Go to previous messageGo to next message
mohd_dba
Messages: 19
Registered: October 2009
Junior Member
mohd_dba wrote on Fri, 02 October 2009 07:59
There is no chance that we are lost the sys and system passwords.If not change the password also.There should be the default password.

Sorry,It means that "If not change the password also" we are not changing the password for both sys and system schema.

Thanks,
Afroze

Re: lost sys and system passwords [message #424458 is a reply to message #424457] Fri, 02 October 2009 08:17 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still clear as mud, maybe we should stop there as it is useless for OP.

Regards
Michel
Previous Topic: Identify users connecting database
Next Topic: create user
Goto Forum:
  


Current Time: Thu Apr 18 06:50:43 CDT 2024