rmoff's random ramblings
about talks

Changing password on Oracle 11g from 10g clients (ORA-28001 -> ORA-01017)

Published Sep 23, 2009 by in Oracle at https://rmoff.net/2009/09/23/changing-password-on-oracle-11g-from-10g-clients-ora-28001-gt-ora-01017/

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: [sourcecode language=“bash”] $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 [/sourcecode]

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:

[sourcecode language=“bash”] 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> [/sourcecode]


Robin Moffatt

Robin Moffatt works on the DevRel team at Confluent. He likes writing about himself in the third person, eating good breakfasts, and drinking good beer.

Story logo

© 2025