检查Oracle数据库原有密码过期策略:
SELECT * FROM dba_profiles s where s.profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'
修改Oracle密码过期策略为永不过期:
-- ALTER PROFILE DEFAULT LIMIT PASSword_life_time unlimited;
查看修改后的密码过期策略:
SELECT * FROM dba_profiles s where s.profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'
https://www.cnblogs.com/xiaochina/p/6892569.html
测试可行