Bit of an odd one this. Oracle 11g database, a user’s password has expired. But when I try to change it, I can’t:
$sqlplus MYUSER/oldPW@oraDBServer
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Sep 23 07:57:41 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28001: the password has expired
Changing password for MYUSER
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied
Password unchanged
After a bit of digging around I found a post (cached) which says that this is a problem when you use 10g clients with 11g database. And sure enough:
C:\Windows\System32>C:\instantclient_11_1\sqlplus.exe MYUSER/oldPW@oraDBServer
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Sep 23 08:34:39 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-28001: the password has expired
Changing password for MYUSER
New password:
Retype new password:
Password changed
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>