Monday, October 29, 2018

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



No comments:

Post a Comment

ORA-00001: Unique Constraint Violated – Complete Guide

ORA-00001: Unique Constraint Violated in Oracle – Complete Fix Guide (Step-by-Step) The ORA-00001: unique constraint violated error is one...

Contact / Feedback Form

Name

Email *

Message *