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>
Nice posting for newbee. This is useful to change password without connect into sqlplus otherwise we can change using “alter user identified by” (but after loging in sqlplus).
Comment by Jack Nicholson — April 12, 2010 @ 07:08
Excellent it was my problem
For fixing this issue:
Solution
Apply one of the following solutions:
- upgrade the clients to 11gR1 or 11gR2
- install patchset 10.2.0.5 on the client: patch 8202632
- on Windows with 10.2.0.4 install the latest patch bundle,see note 342443.1
- for 10.1.0.5 on Unix / Linux, apply patch 6277160
Comment by Marcos Santos — March 1, 2012 @ 20:39