ORA-28001: the password has expired

December 13, 2010 § 24 Comments

That’s the error you get for oracle user for whom password is expired.

One Solution – Connect using sqlplus to set new password, you can even use the same password you had earlier.

$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 13 01:12:07 2010

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: myuser
Enter password:
ERROR:
ORA-28001: the password has expired

Changing password for myuser
New password:
Retype new password:
Password changed

Connected to:
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production

Free Online Certifications

About these ads

§ 24 Responses to ORA-28001: the password has expired

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading ORA-28001: the password has expired at Varun's Blog.

meta

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: