Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Resetting the SYS password

user629987Apr 4 2012 — edited Apr 5 2012

Hi,

I have forgotten the SYS and SYSTEM passwords for a database (11gR1 on Windows 2008 64-bit), so how would I go about resetting the SYS password?
I can't log in with "connect / as sysdba" since the Oracle Windows service is using a domain account and not the local administrator account.
Is it possible to change the password with orapwd without having to recreate the password file (remote_login_passwordfile='EXCLUSIVE') or bouncing the database?
Also, I read the following on a site and am wondering if it's safe to change a password with orapwd....

Do not remove or modify the password file if you have a database or instance mounted using REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE or SHARED. If you do, you will be unable to reconnect remotely using the password file. Even if you replace it, you cannot use the new password file, because the timestamps and checksums will be wrong.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2012

Added on Apr 4 2012

#general-database-discussions

9 comments

485 views