解锁被锁的Oracle用户

SQL> select username,account_status,lock_date from dba_users order by lock_date asc;

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
DIP
LOCKED                           17-APR-19

XS$NULL
EXPIRED & LOCKED                 17-APR-19

CTXSYS
EXPIRED & LOCKED                 17-APR-19

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
ANONYMOUS
EXPIRED & LOCKED                 17-APR-19

DBSNMP
LOCKED                           29-JUN-22

APPQOSSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
DBSFWUSER
LOCKED                           29-JUN-22

GGSYS
LOCKED                           29-JUN-22

SYS$UMF
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
OUTLN
LOCKED                           29-JUN-22

LBACSYS
LOCKED                           29-JUN-22

OJVMSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
OLAPSYS
LOCKED                           29-JUN-22

SYSDG
LOCKED                           29-JUN-22

DVSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
DVF
LOCKED                           29-JUN-22

GSMADMIN_INTERNAL
LOCKED                           29-JUN-22

MDSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
ORDSYS
LOCKED                           29-JUN-22

XDB
LOCKED                           29-JUN-22

WMSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
GSMCATUSER
LOCKED                           29-JUN-22

MDDATA
LOCKED                           29-JUN-22

SYSBACKUP
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
REMOTE_SCHEDULER_AGENT
LOCKED                           29-JUN-22

GSMUSER
LOCKED                           29-JUN-22

SYSRAC
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
GSMROOTUSER
LOCKED                           29-JUN-22

SI_INFORMTN_SCHEMA
LOCKED                           29-JUN-22

AUDSYS
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
ORDPLUGINS
LOCKED                           29-JUN-22

SYSKM
LOCKED                           29-JUN-22

ORDDATA
LOCKED                           29-JUN-22

USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS                   LOCK_DATE
-------------------------------- ------------------
ORACLE_OCM
LOCKED                           29-JUN-22

SYSTEM
LOCKED(TIMED)                    24-SEP-22

SYS
OPEN

36 rows selected.

SQL> 

SQL> alter user system account unlock;

User altered.

SQL> 

SQL> select LOCK_DATE,username from dba_users where username='SYSTEM';

LOCK_DATE
------------------
USERNAME
--------------------------------------------------------------------------------

SYSTEM

SQL> 

SQL> select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
--------------------------------------------------------------------------------
COM INH IMP
--- --- ---
DEFAULT
FAILED_LOGIN_ATTEMPTS            PASSWORD
10
NO  NO  NO

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME                    RESOURCE
-------------------------------- --------
LIMIT
--------------------------------------------------------------------------------
COM INH IMP
--- --- ---
ORA_STIG_PROFILE
FAILED_LOGIN_ATTEMPTS            PASSWORD
3
NO  NO  NO

SQL> 

SQL> alter profile default limit FAILED_LOGIN_ATTEMPTS 30;

Profile altered.

SQL> 

修改为无限次（为安全起见，不建议使用）
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;