OraFAQ Forum: Security » SYS & SYSTEM password lost!

Home » RDBMS Server » Security » SYS & SYSTEM password lost!

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

SYS & SYSTEM password lost! [message #45073]

Tue, 10 February 2004 22:38

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi,

A partner lost both: the SYS and the SYSTEM passwords!! He asked us if it was possible to "recover" or to find out again which are these passwords?

They are using Oracle 9i!

Have anyone experienced such problems or have a solution? Thank you for your help!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45074 is a reply to message #45073]

Wed, 11 February 2004 01:35

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Login locally (at the server console) to the Oracle server as "/ @yourdb as sysdba" and change the sys password by "alter user sys identified by some_password".

MHE

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45075 is a reply to message #45074]

Wed, 11 February 2004 02:11

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

OK! Great! Like this:

Connected locally as oracle user to the UNIX machine where Oracle Server is installed:

UNIX_prompt>connect / @my_db as sysdba

?? Is that right ??

Thank you so much for your answer!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45077 is a reply to message #45075]

Wed, 11 February 2004 02:42

Maaher
Messages: 7065
Registered: December 2001

Senior Member

No connect locally at the server console into SQLPLUS (sorry, forgot to mention that):
$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 11 13:47:06 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: / @your_db as sysdba

MHE

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45080 is a reply to message #45077]

Wed, 11 February 2004 03:45

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

So great!! Thanks!! Very helpfull!!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45081 is a reply to message #45077]

Wed, 11 February 2004 03:53

Patrick Tahiri
Messages: 119
Registered: January 2004

Senior Member

Hi Maaher,

I receive this ERROR: ORA-01031: insufficient privileges!! Do you know why? Is it because I'm using the password file?
-----------------------------------------------
dbadmin:~/sms>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 11 08:51:56 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: / @sms.syracuse.no as sysdba
ERROR:
ORA-01031: insufficient privileges

Enter user-name: dbadmin:~/sms>
-----------------------------------------------

Thank you again!

Regards,

Patrick Tahiri.

Report message to a moderator

Re: SYS & SYSTEM password lost! [message #45101 is a reply to message #45081]

Wed, 11 February 2004 13:26

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Only trusted OS users can connect without supplying a password.

Can you connect to the database server as the oracle OS account, and then enter:

sqlplus "/ as sysdba"

Report message to a moderator

Previous Topic:	How to create a user account with some right?
Next Topic:	administrator account and security !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 09:19:53 CST 2025