Home » RDBMS Server » Security » SYS & SYSTEM password lost!
SYS & SYSTEM password lost! [message #45073] Tue, 10 February 2004 22:38 Go to next message
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.
Re: SYS & SYSTEM password lost! [message #45074 is a reply to message #45073] Wed, 11 February 2004 01:35 Go to previous messageGo to next message
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
Re: SYS & SYSTEM password lost! [message #45075 is a reply to message #45074] Wed, 11 February 2004 02:11 Go to previous messageGo to next message
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.
Re: SYS & SYSTEM password lost! [message #45077 is a reply to message #45075] Wed, 11 February 2004 02:42 Go to previous messageGo to next message
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
Re: SYS & SYSTEM password lost! [message #45080 is a reply to message #45077] Wed, 11 February 2004 03:45 Go to previous messageGo to next message
Patrick Tahiri
Messages: 119
Registered: January 2004
Senior Member
So great!! Thanks!! Very helpfull!!

Regards,

Patrick Tahiri.
Re: SYS & SYSTEM password lost! [message #45081 is a reply to message #45077] Wed, 11 February 2004 03:53 Go to previous messageGo to next message
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.
Re: SYS & SYSTEM password lost! [message #45101 is a reply to message #45081] Wed, 11 February 2004 13:26 Go to previous message
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"
Previous Topic: How to create a user account with some right?
Next Topic: administrator account and security !
Goto Forum:
  


Current Time: Thu Mar 28 16:21:52 CDT 2024