linux下修改oracle数据库密码

 

[oracle@test ~]$ sqlplus /nolog    进入oracle控制台

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 11:23:10 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba;  以DBA角色进入
Connected.
SQL> select username from dba_users;     查看用户名

USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
MISA
tms
sandtms
CBF
SANDTMS
MISA_TEST

 

SQL>   alter user MISA_TEST identified by 123456;     讲misa_test用户密码修改为123456

User altered.

SQL>   conn MISA_TEST/123456;  连接misa_test
Connected.