Oracle密码过期处理

数据库密码过期

alter profile default limit password_life_time unlimited; alter user itempv2 identified by 123456; commit;

1.系统提示 ORA-28001

 //ORA-28001: the password has expired
 select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

2. 修改为unlimited

alter profile default  limit password_life_time unlimited; 
commit;

3. 修改密码

alter user XXXUSER identified by Welcome1;

4. 如果账号被锁住，则需要解锁命令

//如果账号被锁住，则需要解锁命令
alter user XXXUSER identified by oracle account unlock; 

写成批处理方式（会在文件夹中生成*.SQL 文件）

@echo off
goto End
 
:SetPasswordUnlimited
echo 设置密码永过期... 
echo alter profile default  limit password_life_time unlimited;