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>

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
db/oracle/change_pwd_sys_system.txt ยท Last modified: 2017/09/06 19:30 by gerardnico