Oracle Database - How to change the password for the account SYS/SYSTEM ?
1 - With SqlPlus
You must connect with the SYSDBA privilege. If you don't remember the sys password, you can perform a OS authentication. Check this article for more information : Oracle Database - How to connect SYS as SYSDBA without password
C:\Documents AND Settings\gerardnico>sqlplus / AS sysdba SQL*Plus: RELEASE 10.2.0.4.0 - Production ON Wed Jun 10 11:11:51 2009 Copyright (c) 1982, 2007, Oracle. ALL Rights Reserved. Connected TO: Oracle Database 10g Enterprise Edition RELEASE 10.2.0.4.0 - Production WITH the Partitioning, OLAP, Data Mining AND REAL Application Testing options SQL> show USER USER IS "SYS" SQL> CONNECT sys/QS2007 AS sysdba Connected. SQL> passw sys Changing password FOR sys Old password: NEW password: Retype NEW password: Password changed SQL>
2 - Articles Related
3 - Support
If you don't give the SYS password before to change it, you may have the error ORA-28008.
SQL> CONNECT / AS sysdba Connected. SQL> passw sys Changing password FOR sys OLD password: NEW password: Retype NEW password: ERROR: ORA-28008: invalid OLD password Password unchanged