Saturday, September 29, 2012

Reset the Oracle SYSTEM password

Scenario: Forgot the SYSTEM password for the ORACLE database installed in your computer.

Solution: You can reset it by logging in to Windows as Administrator and connecting to Oracle as sysdba.


Steps:

  • Log in to the Windows Server that is running Oracle as Administrator.
  • Start SQL*Plus

  • At the login prompt, in the user-name field, type ”/as sysdba”, and press enter

  • You are now connected as system with full DBA rights.

  • Reset the password of the SYSTEM  with below query
alter user system identified by NewPassword;
  • enter
“User altered.”
 
Now you can login with your new password.