Pages

Monday, June 3, 2013

Oracle User Password Never Expired

As development demands, we would like to turn off Orace User Password Never Expired function.

Check the current profile's password life time:
SQL> select * from dba_profiles where profile='PROFILE' and RESOURCE_NAME='PASSWORD_LIFE_TIME';

we need to change the limit of password_life_time parameter to unlimited.
SQL> alter profile PROFILE limit PASSWORD_LIFE_TIME unlimited;  

then all the users' password will never be expired.

Unable to activate changes on WebLogic

Last week, I was configuring monitoring on server status, and other items we cared about. Some configurations might be wrong so that it was unable to active changes on WebLogic, instead of reporting below errors:

weblogic.management.provider.EditFailedException: Can not undo unactivated changes while an activate changes operation is still in progress

Which made a lock on server configuration, and caused my deployment was failed even restarting it.

Workaround:

cd /pending

rm *.*
and then restart all the servers.

Everything went well again without those changes.