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 220.127.116.11.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.