ORA-01017 when changing expired password on oracle 11G

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Mon, 13 Aug 2012 09:17:16 +1000
Message-ID: <CAFeFPA9uzFTnZeHn8=B5EauAmYUipEBy06rfOW-rNM1+yznR2w_at_mail.gmail.com>

Hi,

We have implemented password expiry and complexity rules on all our databases and one recent one is giving us some headache by giving us ORA-01017 when we connect remotely to change it We already set sec_case_sensitive_logon to false to accomodate 10G clients but even from my desktop I get this error and I have 11.2.0.3 client. If I run the same on the server it works fine.

I am sure it is something minor, but I can't see it

There is no sqlnet.ora on the server
I do know that the Linux team have made modifications to secure the server more than the default but am not aware of the full details yet, but that may be my next port of call.

<REMOTE>

i:\temp>sqlplus system_at_<sid>

SQL*Plus: Release 11.2.0.3.0 Production on Mon Aug 13 08:33:00 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter case

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
sec_case_sensitive_logon             boolean     FALSE

SQL> connect testuser/********_at_<sid>
ERROR:
ORA-28001: the password has expired

Changing password for testuser
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied

Password unchanged
Warning: You are no longer connected to ORACLE. SQL>
</REMOTE>

<SERVER>

[oracle_at_<host>-<sid>]
/oracle01/oracle_base/product/11.2.0/db_1/network/admin > sqlplus testuser/******_at_<sid>
SQL*Plus: Release 11.2.0.2.0 Production on Sun Aug 12 23:08:31 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR:
ORA-28001: the password has expired

Changing password for testuser
New password:
Retype new password:
Password changed
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
TESTUSER_at_<sid> >

</SERVER

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Aug 12 2012 - 18:17:16 CDT