rmoff

September 23, 2009

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

Filed under: oracle — rmoff @ 07:44

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>
Advertisements

2 Comments

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

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


RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Create a free website or blog at WordPress.com.

%d bloggers like this: