Oracle Database - How to change the password for the account SYS/SYSTEM ?

Card Puncher Data Processing

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>

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





Discover More
Card Puncher Data Processing
Oracle Database - Privileges

A user can connect with different levels of privileges: namely for the database: SYSDBA (the root or administrator of the database) and SYSOPER. SYSOPER allows a user to perform basic operational...



Share this page:
Follow us:
Task Runner