Oracle19C-java.sql.SQLException: ORA-28001: the password has expired

版本

Version 19.9.0.0.0

连接数据库提示 ORA-28001: the password has expired

sqlplus连接

sqlplus / as sysdba

执行命令修改过期时间

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> SELECT
    profile,
    resource_name,
    resource_type,
    limit
FROM dba_profiles
WHERE resource_name LIKE 'PASSWORD%'
ORDER BY profile, resource_name;  2    3    4    5    6    7    8  

PROFILE          RESOURCE_NAME              RESOURCE LIMIT
-------------------- -------------------------------- -------- ----------------
DEFAULT          PASSWORD_GRACE_TIME          PASSWORD 7
DEFAULT          PASSWORD_LIFE_TIME           PASSWORD UNLIMITED
DEFAULT          PASSWORD_LOCK_TIME           PASSWORD 1
DEFAULT          PASSWORD_REUSE_MAX           PASSWORD UNLIMITED
DEFAULT          PASSWORD_REUSE_TIME          PASSWORD UNLIMITED
DEFAULT          PASSWORD_VERIFY_FUNCTION          PASSWORD NULL
ORA_STIG_PROFILE     PASSWORD_GRACE_TIME          PASSWORD 5
ORA_STIG_PROFILE     PASSWORD_LIFE_TIME           PASSWORD 60
ORA_STIG_PROFILE     PASSWORD_LOCK_TIME           PASSWORD UNLIMITED
ORA_STIG_PROFILE     PASSWORD_REUSE_MAX           PASSWORD 10
ORA_STIG_PROFILE     PASSWORD_REUSE_TIME          PASSWORD 365
ORA_STIG_PROFILE     PASSWORD_VERIFY_FUNCTION          PASSWORD ORA12C_STIG_VERI
                                   FY_FUNCTION


12 rows selected.