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.
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com