1，切换用户，连接oracle数据库
[root@dh-db-lsvwbF7y ~]# su - oracle [oracle@dh-db-lsvwbF7y ~]$ [oracle@dh-db-lsvwbF7y ~]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on 星期三 2月 16 17:32:28 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> conn /as sysdba; 已连接。
2，查看用户状态，并将用户状态解锁
SQL> select username,account_status from dba_users where username = 'DSSC'; USERNAME -------------------------------------------------------------------------------- ACCOUNT_STATUS -------------------------------------------------------------------------------- DSSC LOCKED SQL> alter user DSSC account unlock; 用户已更改。 SQL>