windows服务器
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;
alter user testuser identified by abc123;
Linux服务器
登陆oracle所在的linux服务器(用dba用户)或使用putty工具登录
打开控制台执行
sqlplus / as sysdba;
alter profile default limit password_life_time unlimited;
alter user testuser identified by abc123;