Handling "ORA-28001: the password has expired"

[William Robertson]

I notice if the password has expired but I am within the grace period, PL/SQL Developer 9.0.6 fails the connection attempt with ORA-28001.

However SQL*Plus is able to detect this and prompt me for a new password, e.g:

SQL> conn williamr/pass123@xyz
ERROR:
ORA-28001: the password has expired

Changing password for williamr
New password:
Retype new password:
Password changed
Connected.

Our DBAs create accounts with pre-expired passwords expecting the client tool to prompt us for a new one, so it would be quite useful if PL/SQL Dev could do this automatically.

 

[Marco Kalter]

You don't get this password change dialog?

 

[William Robertson]

Sorry missed your reply earlier.

I've never seen that prompt. I'll look out for it next time this happens.

 

[William Robertson]

OK, PL/SQL Developer does prompt to change the password when you connect using the main "Oracle Logon" dialog (after hitting the key symbol in the toolbar). I missed it because I always pick the connection directly from the drop-down list (little arrow next to it).