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;