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
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.