ORA-01017 when changing expired password on oracle 11G

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@<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/********@<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@<host>-<sid>]
/oracle01/oracle_base/product/11.2.0/db_1/network/admin > sqlplus
testuser/******@<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@<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

Other related posts: