12.02
If you’re anything like you, you’re eventually going to royally screw the pooch and either forget your Oracle database SYSTEM password or just mangle it some other way, requiring a password reset. Fear not! If this is the case, life can indeed go on as normal. I’m going to tell you how to easily change the SYSTEM account password right from the Windows desktop.
Yeah I know… Windows… not quite my normal deal, but in most enterprise setups, this ancient, wobbling desktop OS sadly still a reality.
Log into the Windows server that is running Oracle as Administrator, or someone with administrative rights.
Start SQL*Plus (either using the GUI/Desktop version or the command line version. If you’re using the command line, you can start SQL*Plus by using the following command (and then skipping to step 4 below):
sqlplus / as sysdba
In the login window, enter the following into the username text box (including the forward slash):
/as sysdba
Click the OK button (or, if you’re at the console as mentioned earlier, press ENTER). You are now connected to the server with full god mode access.
To change the SYSTEM user’s password, enter the following query:
alter user system identified by YourNewPasswordHere;
The password can be whatever you like. Hopefully it’s obvious in the example above where you need to put the new password. If not, close your browser and go bang your head against the nearest brick (or cement. That’s an acceptable substitute).
Press ENTER and the query will execute. You will be made aware of the successful change when you see the following text on the screen:
User altered
That’s all there is to it. Amazingly simple huh? Ok, now go enjoy your day, you geek :)
