How to reset change SYS user password in Oracle Database

How to reset/change SYS user password in Oracle Database

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11g

Description:

            I want to reset/change SYS user password in Oracle Database 11gR2.

Solution:

            You can reset/change SYS password by following simple steps:

Open a terminal and type the command

Sqlplus /nolog

SQL> connect / as sysdba

Once connected to the Database you can reset/change the SYS user password:

SQL> alter user sys identified by <new_password>;

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

👉 Check our complete guide: Oracle Error Codes Guide

---

Author Box

About the Author

Rana Abdul Wahid is an experienced Oracle Database Administrator with expertise in Oracle Database Administration, Oracle Data Guard, RMAN Backup & Recovery, Oracle RAC, Oracle E-Business Suite, Performance Tuning, and High Availability Solutions.

Through this blog, he shares practical Oracle DBA solutions, troubleshooting guides, interview preparation resources, and production-tested best practices for database professionals worldwide.

---