oracle@prd:/home/oracle$sqlplus /nolog

SQL> conn scott/tiger

ERROR:

ORA-28000: the account is locked

SQL> exit

oracle@prd:/home/oracle$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 20:28:21 2022

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

SQL> conn / as sysdba  //用超级管理账户登录

Connected.

SQL> alter user scott account unlock;   //解锁

User altered.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

//重新登录sqlplus软件，/nolog表示没有任何用户登录

oracle@prd:/home/oracle$sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 20:28:53 2022

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

SQL> conn scott/tiger  //提示密码已过期，重新设置

ERROR:

ORA-28001: the password has expired

Changing password for scott

New password:

Retype new password:

Password changed

Connected.

SQL> show user;
  USER is "SCOTT"

SQL>alter user scott identified by tiger;  

User altered.