OraFAQ Forum: Security » lost sys and system passwords

Home » RDBMS Server » Security » lost sys and system passwords

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

lost sys and system passwords [message #421951]

Sat, 12 September 2009 02:47

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...

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:55:46 CST 2024