Oracle user password Modification

1. log on to the database using an oracle user

[Oracle @ wuzj ~] $ Sqlplus/nolog

SQL * Plus: Release 10.2.0.1.0-production on Thu Feb 26 12:06:29 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

SQL> Conn/As sysdba
Connected.

// View the user
SQL> select username, password from dba_users;

Username Password
------------------------------------------------------------
User1 bbe7786a584f9103
Mgmt_view 4f538df5f344f348
Sys 8a8f025737a9097a
System 970baa5b81930a40
Dbsnmp fff45bb2c0c327ec
Sysman 2ca614501f09fccc
Outln 4a3ba55e08595c81
MDSYS 72979a94bad2af80
Ordsys 7efa02ec7ea6b86f
EXFSYS 66f4ef5650c20355
Dmsys bfba5a553fd9e28a

Username Password
commandid
wmsys restart
ctxsys restart
anonymous
XDB 88d8364765fce6af
ordplugins restart
si_informtn_schema restart
olapsys 3fb8ef9db542547c
Scott f894844c34402b67
tsmsys restart
Bi fa1d2b85b701_f3
PM 72e382a52e89575a

Username Password
------------------------------------------------------------
Mddata df02a496267dee66
IX 2be6f80744e08feb
Sh 9793b3777cd3bd1a
Dip ce4a36b8e06ca59c
OE 9c30855e7e0cb02d
HR 6399f3b38edf3288

28 rows selected.

// Modify the User Password format alter User Username identified by new password;

SQL> alter user system identified by manager;

User altered.

// Check again and check that the password has been changed

SQL> select username, password from dba_users;

Username Password
------------------------------------------------------------
User1 bbe7786a584f9103
Mgmt_view 4f538df5f344f348
Sys 8a8f025737a9097a
System d4df7931ab130e37
Dbsnmp fff45bb2c0c327ec
Sysman 2ca614501f09fccc
Outln 4a3ba55e08595c81
MDSYS 72979a94bad2af80
Ordsys 7efa02ec7ea6b86f
EXFSYS 66f4ef5650c20355
Dmsys bfba5a553fd9e28a

Username Password
commandid
wmsys restart
ctxsys restart
anonymous
XDB 88d8364765fce6af
ordplugins restart
si_informtn_schema restart
olapsys 3fb8ef9db542547c
Scott f894844c34402b67
tsmsys restart
Bi fa1d2b85b701_f3
PM 72e382a52e89575a

Username Password
------------------------------------------------------------
Mddata df02a496267dee66
IX 2be6f80744e08feb
Sh 9793b3777cd3bd1a
Dip ce4a36b8e06ca59c
OE 9c30855e7e0cb02d
HR 6399f3b38edf3288

28 rows selected.

SQL>

// Now you can use this password link for operations

SQL> connect system/Manager

Connected.

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

Another method for modifying values

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

The user has changed.

// Try this password

SQL> connect system/Oracle

Connected.

// This password does not work.

 

SQL> connect system/Manager

Error:

ORA-01017: invalid username/password; logon denied