• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 12263
  • Last Modified:

ORA-28001: the password has expired

Can someone explain why does this password expired even I login for the first time using this user. I am using oracle 9i. Is this  a DBA issue

SQL> conn rman/rman
ORA-28001: the password has expired

Changing password for rman
New password: ****
Retype new password: ****
Password changed
Muhammad Ahmad Imran
Muhammad Ahmad Imran
2 Solutions
probably user was created with pawwsord expire clausule


Specify PASSWORD EXPIRE if you want the user's password to expire. This setting forces the user (or the DBA) to change the password before the user can log in to the database.
It is a security thing.  When I set up a user, I give him an easy password (like password, or his SSN), but I want it changed to something difficult.  So, I use the expire clause, and recommend they change to match their network password (so they don't have a post-it note on their PC with all their user accounts and passwords).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now