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-12154 TNS Could Not Resolve Connect Identifier – Complete Step-by-Step Fix

ORA-12154: TNS Could Not Resolve Connect Identifier – Complete Solution The ORA-12154: TNS could not resolve the connect identifier specif...

Contact / Feedback Form

Name

Email *

Message *