Stopping XELSYSADM Password from Expiring
I’m yet to see if this actually works, but this should stop the XELSYSADM account from expiring in OIM. This should hopefully stop alerts being generated when the account comes to expire.
sqlplus / AS SYSDBA
ALTER SESSION SET CURRENT_SCHEMA=DEV_OIM;
UPDATE USR SET USR_PWD_WARN_DATE=null, USR_PWD_EXPIRE_DATE=null, USR_PWD_NEVER_EXPIRES='1' WHERE USR_LOGIN='XELSYSADM';
Supposedly this doesn’t work in 11gR2, but apparently setting the password expiry date and warning date to be some spurious date in the future should fix that.