Question: I have list my SYS password in
Oracle and I need to recover the SYS password, or at least restore
the password. How can I recover my lost SYS password?
Answer: While Oracle passwords cannot be
decrypted, you can
have a SYS password and use the encrypted password to recover
SYS if necessary. There are several methods for re-setting a
lost SYS password.
- Use a SYSDBA user
- Use orapwd
- Connect externally
- Contact Oracle Support
- Rebuild the schema in a new database
1: You can start by finding another user with SYSDBA
privileges. That user will be able to re-set the SYS password.
2: The orapwd utility may help in re-setting a lost SYS
password, see here:
using orapwd to re-set a password
3: If your ID's
are
identified externally
you can sign-on to Oracle without a password and then change the
SYS password. Users whose ID's are "identified externally" and
participate in the OS DBA group can sign-on to SQL*Plus without a
password:
sqlplus /nolog
connect / as sysdba
ALTER USER sys IDENTIFIED BY "new_password";
4. If
neither of these cases apply, you need to contact Oracle technical
support. They have a special way to fix this, but they need proof
that you have a valid license and right to do so!
5. Worst case, you can create a whole new database with a
known SYS password and then export/import the data (or use
transportable tablespaces if enabled).
Also see these tips for recovering a lost password:
- How To Recover From Lost SYS Password MOSC Note:
805084.1
- Checklist for Resolving Connect AS SYSDBA Issues MOSC Note:
69642.1
- How to Set up the Oracle Password File MOSC Note: 1029539.6
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|