• VMware

    Learn about VMware virtualization for its products like vsphere ESX and ESXi, vCenter Server, VMware View, VMware P2V and many more

  • Linux

    Step by step configuration tutorials for many of the Linux services like DNS, DHCP, FTP, Samba4 etc including many tips and tricks in Red Hat Linux.

  • Database

    Learn installation and configuration of databases like Oracle, My SQL, Postgresql, etc including many other related tutorials in Linux.

  • Life always offers you a second chance ... Its called tomorrow !!!

    Tuesday, April 19, 2016

    ORA-28002: the password will expire within 6 days (certain string)

    I have been working in Sql developer for certain time, few days back found new notification/warning  windows is popping up with the error message - ORA-28002: the password will expire within 6 days (certain string) as below :



    Although there are many other ways you can get rid of this notification/warning like changing the user password. But I'll prefer to set this value as unlimited instead changing the Password again in few weeks later.

    Cause : Basically this is causing because Sql developer password expiration has been set to 180 days By default.

    How to see Expiration: To view the validity of the password you can use below query:

    select resource_name,limit from dba_profiles where profile='DEFAULT';

    Output:


    Now most of us will wonder can we change this date to unlimited, the answer is yes, we can by using below query:

    Alter Profile Default Limit Password_Life_Time Unlimited;

    Output: Profile DEFAULT Altered.

    To check if the Password has been reset successfully, execute below query and verify the result.

    select resource_name,limit from dba_profiles where profile='DEFAULT';


    Final Note :  You need to change the password again for new limit to take effect.

    Thanks for reading this post.




    0 comments:

    Post a Comment