1. log on to the database using an oracle user [oracle @ wuzj ~] $ SqlplusnologSQL * Plus: Release10.2.0.1.0
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's SQL se
1. log on to and connect 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
------------------------------------------------------------
WMSYS 7C9BA362F8314299
CTXSYS 71E687F036AD56E5
ANONYMOUS anonymous
XDB 88D8364765FCE6AF
ORDPLUGINS 88A2B2C183431F00
SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3
OLAPSYS 3fb8ef9db536947c
SCOTT F894844C34402B67
TSMSYS 3DF26A8B17D0F29F
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
------------------------------------------------------------
WMSYS 7C9BA362F8314299
CTXSYS 71E687F036AD56E5
ANONYMOUS anonymous
XDB 88D8364765FCE6AF
ORDPLUGINS 88A2B2C183431F00
SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3
OLAPSYS 3fb8ef9db536947c
SCOTT F894844C34402B67
TSMSYS 3DF26A8B17D0F29F
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