Reset the Oracle administrator password in WINXP

Reset the Oracle administrator password in WINXP

To modify the Oracle administrator password in windows, follow these steps. This step is successfully performed under winxp5.1 and oracle92. After the change, you must restart your computer and instance to make the change take effect.

Background: WINXP version 5.1 (internal version 2600. xpsp_sp2_dgr.070227-2254: Service Pack 2), oracle92 (9.2.0.1.0), Database Sid is defonds, System User's original password: p11111111, to be modified to: p12345678.

Log on to WINXP as administrator and run the following command in DOS:

Set oracle_sid = defonds

Sqlplus/nolog

Conn/As sysdba

Alter user system identified by p12345678;