Oracle sys and system passwords

5 pts.
Tags:
Oracle
Oracle administration
I have a database that was created by a person who is no longer with the company. They changed the sys and system passwords but told no one. Is there a way to change (find) the sys and system passwords.

Answer Wiki

Thanks. We'll let you know when a new response is added.

In general, there’s no way to find out a user’s password; all you can do is change it.
Any user with the ALTER USER system privilege can change another user’s password, like this:

ALTER USER system IDENTIFIED BY new_password;

To find out which users and roles have the ALTER USER privilege:

SELECT grantee FROM dba_sus_privs WHERE privilege = ‘ALTER USER';

If that doesn’t solve the problem, you may be able to connect, without a password, as SYS (also called INTERNAL on some versions) directly on the database server. You may have to be logged in to the server as the administrator, or using the OS account that installed Oracle. If it asks for a password, just press <ENTER>. The details are version- and OS-dependent.
Oracle support can give you a much better answer.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Hilldee
    The view identified in the article should be.. SELECT grantee FROM dba_SYS_privs WHERE privilege = 'ALTER USER';
    10 pointsBadges:
    report
  • Eldon
    And what's more, here's an example of the command lines you'd use on Linux (and probably any Unix), while logged in as the user who installed the database (usually oracle):
    $ . oraenv    # You will be asked to supply a value for ORACLE_SID - see /etc/oratab
    $ sqlplus / as sysdba
    60 pointsBadges:
    report
  • Graham R
    The way I always took over an Oracle database, on Windows at least, was 1) whilst logged on to the database server itself, stop the Oracle service to free the lock on the password file. 2) create a new password file with the password you want to use as sys e.g. orapwd FILE=PWD.ora PASSWORD= ENTRIES = 3) Now start everything back up and you can log on as sys with your the new sys password specified There are consequences of this of course, as you have just basically wiped the password file clean and will need to regrant any other users that have sysdba and sysoper privileges ... so I would recommend you find out who they are before hand by running select * from v$pwfile_users; Once logged on as sys you can reset the system password
    70 pointsBadges:
    report
  • Graham R
    The text editor stripped out my diamond brackets last time, the example should have said e.g. orapwd FILE=PWD>>.ora PASSWORD=>> ENTRIES = >>
    70 pointsBadges:
    report
  • Graham R
    e.g. orapwd FILE=PWDsid.ora PASSWORD=new password ENTRIES = max_users
    70 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following