oracle数据库密码过期修改

1. 用系统账号登入数据库
   sqlplus / as sysdba;

2. 查询此用户的准确用户名
   SELECT USERNAME FROM DBA_USERS WHERE USERNAME LIKE ‘%username%’;

3. 查看数据库默认的密码有效期
   SELECT * FROM DBA_PROFILES WHERE PROFILE=‘DEFAULT’ AND RESOURCE_NAME=‘PASSWORD_LIFE_TIME’;

4. 修改密码有效期，会立即生效
   ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;

5. 帐户修改密码
   ALTER USER %username% IDENTIFIED BY %password%;

6. 对用户进行解锁
   ALTER USER %username% ACCOUNT unlock;
   COMMIT;

查询验证
select USERNAME, PROFILE FROM DBA_USERS;