oracle 密码过期

    1、sqlplus / as sysdba;

　　2、select username,profile from dba_users;

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

　　4、alter profile default limit password_life_time unlimited;

　　5、alter user yqdz identified by bocd account unlock;

   6、commit;