1, the use of Oracle user login, connect the database
[Oracle@wuzj ~]$ Sqlplus/nolog
Sql*plus:release 10.2.0.1.0-production on Thu Feb 26 12:06:29 2009
Copyright (c) 1982, +, Oracle. All rights reserved.
Sql> Conn/as SYSDBA
Connected.
View 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
------------------------------ ------------------------------
Wmsys 7c9ba362f8314299
Ctxsys 71e687f036ad56e5
ANONYMOUS ANONYMOUS
XDB 88D8364765FCE6AF
Ordplugins 88a2b2c183431f00
Si_informtn_schema 84b8cbca4d477fa3
Olapsys 3fb8ef9db538647c
SCOTT f894844c34402b67
Tsmsys 3df26a8b17d0f29f
BI fa1d2b85b70213f3
PM 72e382a52e89575a
USERNAME PASSWORD
------------------------------ ------------------------------
Mddata df02a496267dee66
IX 2be6f80744e08feb
SH 9793B3777CD3BD1A
DIP ce4a36b8e06ca59c
OE 9c30855e7e0cb02d
HR 6399f3b38edf3288
Rows selected.
Modify user password format ALTER user username identified by new password;
sql> alter user system identified by manager;
User altered.
See again, compare to find password has been replaced
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
------------------------------ ------------------------------
Wmsys 7c9ba362f8314299
Ctxsys 71e687f036ad56e5
ANONYMOUS ANONYMOUS
XDB 88D8364765FCE6AF
Ordplugins 88a2b2c183431f00
Si_informtn_schema 84b8cbca4d477fa3
Olapsys 3fb8ef9db538647c
SCOTT f894844c34402b67
Tsmsys 3df26a8b17d0f29f
BI fa1d2b85b70213f3
PM 72e382a52e89575a
USERNAME PASSWORD
------------------------------ ------------------------------
Mddata df02a496267dee66
IX 2be6f80744e08feb
SH 9793B3777CD3BD1A
DIP ce4a36b8e06ca59c
OE 9c30855e7e0cb02d
HR 6399f3b38edf3288
Rows selected.
Sql>
You can now use this password link to do the operation
Sql> Connect System/manager
is connected.
==========================
Another way to modify a value
sql> alter user system identified by values ' 2D594E86F93B17A1 ';
The user has changed.
Trying this code.
Sql> Connect system/oracle
is connected.
This code doesn't work.
Sql> Connect System/manager
ERROR:
Ora-01017:invalid Username/password logon denied