很久不用的项目遇到报错
2024-03-14 11:15:01.806 [Druid-ConnectionPool-Create-110651474] ERROR com.alibaba.druid.pool.DruidDataSource 2879 - create connection SQLException, url: jdbc:oracle:thin:@//192.168.0.54:1521/orcl, errorCode 28001, state 99999
java.sql.SQLException: ORA-28001: the password has expired
很显然密码过期;
快速处理方法
修改密码的过期时间:这是因为Oracle Database 11g 版本的Oracle数据库有一项默认配置,就是密码过期时间默认为180天(6个月左右)
1、su - oracle
2、sqlplus "/as sysdba"
3、SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
4、ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
5、alter user 密码已过期的USERNAME identified by 密码;