Password Expiry Issue
We were trying to start IDM services but services were failing with error as shown in below screen shot
1. As it was showing issue with OPMN services so we tried to start opmn services manually but it
was failing to start opmn services We looked into opmn log file log (located under
$ORACLE_INSTANCE/diagnostics/
[2015-11-17T01:33:48-05:00] [opmn] [TRACE:1] [536] [pm-workers] Job 0 0 result: [[
oid1~oid1~oidmon~OID~
Status: Stop
Operation: internal (time out while waiting for a managed process to stop)
ErrFile: /u02/oracle/config/instances/
String: second stop attempted
]]
[2015-11-17T01:33:48-05:00] [opmn] [NOTIFICATION:1] [663] [pm-process] Stopping
Process: oid1~oidmon~OID~1 (2045482973:2865)
2. After that we looked into oidmon.log file located under (/u02/oracle/config/instances/
will retry again after 10 sec
[2015-11-17T02:04:37-05:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: iamdemo04.k21technologies.com] [pid: 4425] [tid: 0] Guardian: Connecting to database, connect string is oiddb [2015-11-17T02:04:37-05:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: iamdemo04.k21technologies.com] [pid: 4425] [tid: 0] Guardian: [gsdsiConnect] ORA-28002, ORA-28002: the password will expire within 5 days [2015-11-17T02:04:37-05:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: iamdemo04.k21technologies.com] [pid: 4425] [tid: 0] Guardian: [oidmon]: Unable to connect to database,will retry again after 10 sec
So as shown in logs above there was some issue with Database users.
Temporary Fix
For fixing the issue temporarily, reset the password of expired users and to check the status of
users, run the below command after connecting to database.
SQL> select USERNAME,ACCOUNT_STATUS, LOCK_DATE, EXPIRY_DATE form dba users;
After that run below command to reset the password
SQL> alter user <username> identified by <password>;
For Example
SQL> alter user ODS identified by k21technologies;
Permanent Fix
For permanent fix of this issue, create one password policy and assign it to database users
as shown in below screenshot after resetting the password
SQL> CREATE PROFILE FMWNOLOCK LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED PASSWORD_LIFE_TIME UNLIMITED;
SQL> ALTER USER ODS PROFILE FMWNOLOCK;
About the Author Nancy Kamboj
Oracle Consultant at K21 Technologies - Oracle Gold Partner specialising in Design, Implement, and Support.