Use it with caution when changing the Oracle user password _

This method can be used when you forget the password of a user in the Oracle database.

Please use it with caution !!! To avoid unnecessary losses.

Sqlplus/nolog
Connect sys/youroracle as sysdba
Alter user system identified by newpwd;
Connect system/newpwd

 

The current user grants the oracledba permission.

==============================================

SQL> connect sys/Oracle AS sysdba

Connected.

SQL> select username, password from dba_users;
Username Password
------------------------------------------------------------
Sys 8a8f025737a9097a
System 2d594e86f93b17a1
Dbsnmp e066d214d5421ccc
Toad a1ba01cf0dd82695
Outln 4a3ba55e08595c81
Wmsys 7c9ba362f8314299

You have selected 6 rows.

SQL> connect system/Oracle

Connected.

SQL> connect sys/Oracle AS sysdba

Connected.

Change User System Password to Manager

SQL> alter user system identified by manager;

The user has changed.

SQL> select username, password from dba_users;
Username Password
------------------------------------------------------------
Sys 8a8f025737a9097a
System d4df7931ab130e37
Dbsnmp e066d214d5421ccc
Toad a1ba01cf0dd82695
Outln 4a3ba55e08595c81
Wmsys 7c9ba362f8314299

You have selected 6 rows.

SQL> connect system/Manager

Connected.

Then, you can perform any operations you want.

SQL> connect sys/Oracle AS sysdba

Connected.

Change the user's system password to a previous value.

SQL> alter user system identified by values '2d594e86f93b17a1 ';

The user has changed.

SQL> connect system/Oracle

Connected.

SQL> connect sys/Oracle AS sysdba

Connected.

SQL> connect system/Manager