sqlplus /nolog connect / as sysdbaOnce connected, you can change the SYS password to something you know:
ALTER USER sys IDENTIFIED BY new_password;My question is, if you have multiple databases and you could not remember the SYS password for one of the databases, how could you set the new password? I tried a combination of your answer above, but was not successful. Your help would be greatly appreciated.
- Sign on to the database server as a member of the Administrator's group or a member of the ORA_DBA group.
- In a DOS window, issue the following:
set ORACLE_HOME=c:\oracle\.... set ORACLE_SID=orcl
- Start SQL*Plus.
- Connect as SYSDBA.
connect / as sysdba
- Change the SYS password.
alter user sys identified by new_password;
- Exit SQL*Plus and repeat Steps 2-5 for each instance as necessary.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. 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.