2014/09/16

ORA-28001: the password has expired


Passwords in Oracle can expire after some time. Here is solution how to remove expiration and create new password.

  1. Open sqlplus
  2. Enter connect / as sysdba
  3. Find profile connected to expired user:  select profile from DBA_USERS where username='';
  4. Default name of profile is DEFAULT.
  5. alter profile DEFAULT limit password_life_time UNLIMITED;
  6. To show more info: select resource_name,limit from DBA_PROFILES;
  7. Change user's password: alter user identified by ;
  8. Commit
Now you can connect again ;)
▼ Click here to say thanks ▼

1 comment :

  1. This comment has been removed by a blog administrator.

    ReplyDelete