oracle数据库密码到期怎么解决

select username,profile from dba_users;

select *from dba_profiles s where s.profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

select * from dba_users where username='CMCDP';SELECT * from dba_profiles s where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';