1、使用oracle用户登录，连接数据库 [oracle@wuzj ~]$ sqlplus /nolog sql*plus: release 10.2.0.1.0 - production on thu feb 26 12:06:29 2009 copyright (c) 1982, 2005, oracle. all rights reserved. sql conn /as sysdba connected. //查看用户 sql se
1、使用oracle用户登录，，连接数据库
[oracle@wuzj ~]$ sqlplus /nolog
sql*plus: release 10.2.0.1.0 - production on thu feb 26 12:06:29 2009
copyright (c) 1982, 2005, oracle. all rights reserved.
sql> conn /as sysdba
connected.
//查看用户
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
28 rows selected.
//修改用户口令 格式 alter user 用户名 identified by 新密码;
sql> alter user system identified by manager;
user altered.
//再次查看，对比发现密码已经更换
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
28 rows selected.
sql>
//现在就可以用此密码链接进行操作了
sql> connect system/manager
已连接。
==========================
另一种修改值的办法
sql> alter user system identified by values '2d594e86f93b17a1';
用户已更改。
//在试试这个密码
sql> connect system/oracle
已连接。
//这个密码就不灵了
sql> connect system/manager
error:
ora-01017: invalid username/password; logon denied
.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！