oracle 用户解锁与更改登录密码

1.先用sysdba进入系统

SQL>sqlplus / as sysdba

2.修改testname登录用户名

SQL>alter user testname account nulock;

      User altered.

3.提交

SQL>commit;

      commit complete.

4.测试解锁用户

SQL>conn testname/password;

 

更改testname密码为123456

1.进入sysdba

connect sys/oracle as sysdba

2.修改用户密码

SQL>alter user testname identified by 123456;