A small trick to modify the Oracle user password
Database version:
9.2.0
.5
Sometimes we may not know a user's password, but you need to do some operations with this user, and you can't modify the password of this user. At this time, you can use some tips to complete the operation.
The specific procedure is as follows:
SQL * Plus: Release
9.2.0
.5.0 - Production on Sunday November 21 13:32:34 2004
CopyRight (C) 1982, 2002, Oracle Corporation. All Rights Reserved.
SQL> Connect Sys / Oracle As Sysdba
connected.
SQL> SELECT Username, Password from DBA_USERS;
Username Password
------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------
SYS
8A
8f
025737A
9097A
SYSTEM 2D594E
86F
93B
17A
1
DBSNMP E066D214D5421CCC
Toad a1ba01cf0dd82695
Outln
4A
3BA55E
08595C
81
WMSYS
7C
9ba
362F
8314299
6 lines have been selected.
SQL> Connect System / Oracle
connected.
SQL> Connect Sys / Oracle As Sysdba
connected.
Modify user system password for Manager
SQL> ALTER User System Identified by Manager;
The user has changed.
SQL> SELECT Username, Password from DBA_USERS;
Username Password
------------------------------------------------------------------------------------------------------------------------------------------------------------------ ------------
SYS
8A
8f
025737A
9097A
SYSTEM D4DF7931AB130E37
DBSNMP E066D214D5421CCC
Toad a1ba01cf0dd82695
Outln
4A
3BA55E
08595C
81
WMSYS
7C
9ba
362F
8314299
6 lines have been selected.
SQL> Connect System / Manager
connected.
Then you can do anything you want to do.
SQL> Connect Sys / Oracle As Sysdba
connected.
Modify the user's SYSTEM password for the previous value
SQL> ALTER User System Identified by VALUES '2D594E
86F
93B
17A
1';
The user has changed.
SQL> Connect System / Oracle
connected.
SQL> Connect Sys / Oracle As Sysdba
connected.
SQL> Connect System / Manager
Error:
ORA-01017: Invalid Username / Password; Logon Denied
Warning: You are no longer connected to Oracle.
