OAM/OIM schema passwords expired

I have OAM/OIM/ODSM 11g in my environment. While logging into sqlplus as ODS or OAM or OIM users it throws the error as shown in below screenshot.

So I have logged into DB as sys user and verified the status of ODS, OAM and OIM schema users. In my case, the schema users are ODS, DEV_OAM, DEV_OIM. Refer the below screenshot. It shows Account_status as expiry but in grace period.

So password policies has to be disabled. To do this execute the below SQL statement logging into SQL as SYS user:

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED; 

Enable the users by resetting their passwords using command

alter user dev_oam identified by admin123;

Execute the above statement for rest of users for which password is expired.

 

Comments are closed.

Scroll to Top