Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I connect to my local development database, I get an error saying the password has expired. I've been trying to change it with sqlplus to no avail:

C:\>sqlplus TPMDBO/password@localhost/global

SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 6 15:41:02 2013

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

ERROR:
ORA-28001: the password has expired


Changing password for TPMDBO
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied


Password unchanged

I get this error no matter what new password I type in.

My main question is how I can reset this password. However, I'm also curious if there's a way to make the password never expire. This is a local dev database, I really don't care about the security or anything and none of the data on it is important.

share|improve this question

migrated from stackoverflow.com Nov 7 '13 at 5:38

This question came from our site for professional and enthusiast programmers.

    
This seems more like a [dba] question than an SO question. Voting to migrate there instead. –  Ken White Nov 6 '13 at 23:55

1 Answer 1

up vote 3 down vote accepted

Log in to your database as a user who has privilege to alter other users (for example, SYS) and issue the following command:

ALTER USER tmpdbo IDENTIFIED BY new_password;

You can change the expiration behaviour. There already was a question about that on stack overflow, check this thread: Make Oracle Password Never Expire

share|improve this answer
    
So basically you're saying a user does not have the ability to change their own expired password? –  Mike Christensen Nov 6 '13 at 23:57
1  
@MikeChristensen If the account is locked, then, as far as I know, a user can't change it then. –  Przemyslaw Kruglej Nov 6 '13 at 23:58
    
Great, thanks! Clever how Oracle asks you for a new password but doesn't actually allow you to change it. I think I've just come to expect this sort of thing from Oracle. –  Mike Christensen Nov 7 '13 at 0:01
    
@MikeChristensen Just to be clear, a user can change his own password, but the account must not be locked (the same way that I have shown in my answer). –  Przemyslaw Kruglej Nov 7 '13 at 0:03
    
@MikeChristensen Furthermore, the Oracle output in your question shows the account is not locked, but expired. So the error message clearly indicates you entered the wrong old password. Not presenting the correct one there, of course you are not allowed to set a new (I would be much worried otherwise). –  Izzy Nov 21 '13 at 9:37

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.