Version:11.2.0.1
OS : RHEL 5.4
Password for one of our DB user(schema) has expired . The user was using DEFAULT profile
SQL> select resource_name, RESOURCE_TYPE, limit FROM DBA_PROFILES where profile = 'DEFAULT' AND resource_name like 'PASSWORD%';
RESOURCE_NAME RESOURCE LIMIT
-------------------------------- -------- ----------------------------------------
PASSWORD_LIFE_TIME PASSWORD 180
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL
PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD 7
6 rows selected.
This schema is used only by apps server ie. No manual logins from SQL*Plus or PL/SQL developer .
Both apps team and me (the DBA) have forgotton the password.
SQL> select account_status from dba_users where username = 'PARF_CALIB_USR';
ACCOUNT_STATUS
--------------------------------
EXPIRED
SQL> alter user PARF_CALIB_USR account unlock; --- Unlock won't help
User altered.
SQL> select account_status from dba_users where username = 'PARF_CALIB_USR';
ACCOUNT_STATUS
--------------------------------
EXPIRED
I think this can be fixed by setting a new password (ALTER USER parf_calib_usr IDENTIFIED BY newpassword ; )
But I want to keep the old password and renew this user account. Is this possible ?