patternModerate
Oracle password has expired, however I have no way of changing it
Viewed 0 times
howeverexpiredwaypasswordhaschangingoraclehave
Problem
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
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.
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 unchangedI 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.
Solution
If the account is locked, as far as I know, the user can't change it. The Oracle output in your question shows the account is not locked, but expired.
Log in to your database as a user who has privilege to alter other users (for example,
You can change the expiration behaviour. There already was a question about that on Stack Overflow:
Make Oracle Password Never Expire
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:
Make Oracle Password Never Expire
Code Snippets
ALTER USER tmpdbo IDENTIFIED BY new_password;Context
StackExchange Database Administrators Q#52929, answer score: 13
Revisions (0)
No revisions yet.