Showing posts with label How to reset change SYS user password in Oracle Database. Show all posts
Showing posts with label How to reset change SYS user password in Oracle Database. Show all posts

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



How to Extend Swap space on LVM Disk Linux

How to Extend Swap space on LVM Disk Linux   Applies to:             Oracle Database 12.2             Oracle Linux 7 Description: ...