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 sysdbaThis 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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments