Members   Search   Help    Register    Login   Home
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: 25
Registered: March 2009
Location: Karachi
Junior Member
Hi,

I have lost both sys and system passwords. How can I recover / reset both of them. I m using Oracle 10g...
Report message to a moderator
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: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
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: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
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
Report message to a moderator
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: 29436
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Still clear as mud, maybe we should stop there as it is useless for OP.

Regards
Michel
Report message to a moderator
Previous Topic:Identify users connecting database
Next Topic:create user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 1 10:26:08 CST 2009

Total time taken to generate the page: 0.17016 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.