Sunday, December 9, 2012

3 ORA-01017: invalid username/password; logon denied after change the expire password.

ORA-01017 error indicates user name and password mismatch. It is quite straightforward error. However the situation I encounter is a little bit strange.

1. I create the user with the expire password option.

2. When I login as that user , the oracle would tell me the password expire and needs to change.

Now is the wired part, if I perform the 2nd step on the same host as oracle database, the password change would work just fine. But if I do it on my windows sqlplus client. I would get the below the error.

Here are the steps to reproduce it.

create user PO2
identified by oracle
password expire
profile default;
grant create session to PO2;


Lets connect it from Windows:



Lets do it on Linux


After some Google, it turns out it is because the oracle client incompatibility .  The Linux sqlplus client is and my windows is

Let me try it with windows client.

Change the password to expire first.

alter user PO2 password expire;


It works…


It does not seems to be the first time oracle has similar issue. In the past, if we are using 10g client connect to 11g db, it would be the similar issue but that is because 11g password is case sensitive by default ( sec_case_sensitive_logon).  In this case, it is just the client incompatibility issue.




  1. Great put Good stuff.All the topics were explained quickly understand for me.I am waiting for your next fantastic blog.Thanks for sharing.Any coures related details learn...

    AWS Training in Bangalore|

  2. If you have forgotten the password to your Windows computer, the good news is that you can regain access to your PC again pretty easily. reset windows 10 password

  3. Very excellent post!!! Thank you so much for your great content. Keep posting.....

    Big Data Training Institute in Pune
    Big Data Analytics Training in Pune



SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates