Q
Manage Learn to apply best practices and optimize your operations.

How to change forgotten password?

I'm trying to connect to the Enterprise Manager Console and seem to have forgotten my password to my database. I tried all combinations of SYS, SYSTEM w/MANAGER and everything else. How do I go about changing the password in order to connect?

I'm trying to connect to the Enterprise Manager Console and seem to have forgotten my password to my database. I tried all combinations of SYS, SYSTEM w/MANAGER and everything else. How do I go about changing the password in order to connect to my database? I'm using Oracle9i on WinXP. Thanks.

If you have forgotten your password for the SYS or SYSTEM user and wish to change it, log onto the server locally and navigate to the command prompt. Type the following:

set ORACLE_SID=<SID>
sqlplus /nolog
connect / as sysdba
This should allow you to log into the database to change passwords.

If you receive an error regarding insufficient privileges, or it prompts you for a password, modify the sqlnet.ora file (usually located in $ORACLE_HOMEnetworkadmin) by setting SQLNET.AUTHENTICATION_SERVICES=(NTS) and try again. Once you've logged into SQL*Plus successfully as SYS on the local server, change the password as follows:

alter user SYS identified by xxxxx;
and/or
alter user SYSTEM identified by xxxxx;
Exit SQL*Plus and change the sqlnet.ora file entry to its original value. Try logging into Enterprise Manager again.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close