Exadata

Oracle User Password Expired – chage

If you hit oracle password expired error on a linux box or on an exadata machine and you do not want your oracle user password expire you can easily change it with “chage” linux command.
You will need root privilege for modification linux password policies. Even if you are not root , do not worry you can still use the -l option to check the user password expiration info 🙂

Initial setup for the root user and the oracle user :

[root@host]# chage -l root
Last password change                                    : Sep 10, 2008
Password expires                                        : never
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 0
Maximum number of days between password change          : 99999
Number of days of warning before password expires       : 7
[root@host]# chage -l oracle
Last password change                                    : Oct 23, 2013
Password expires                                        : Jan 21, 2014
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 1
Maximum number of days between password change          : 90
Number of days of warning before password expires       : 7

Modify the oracle user to have the same password policy :

[root@host]# chage -I -1 -m 0 -M 99999 -E -1 oracle

Final result :

[root@host]# chage -l oracle
Last password change                                    : Oct 23, 2013
Password expires                                        : never
Password inactive                                       : never
Account expires                                         : never
Minimum number of days between password change          : 0
Maximum number of days between password change          : 99999
Number of days of warning before password expires       : 7
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s