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:
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
- enter
“User altered.”
Now you can login with your new password.