Password Expiry Issue

We were trying to start IDM services but services were failing with error as shown in below screen shot

Inline image 1

 

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/logs/OPMN/opmn). And it was showing below issue.

 

[2015-11-17T01:33:48-05:00] [opmn] [TRACE:1] [536] [pm-workers] Job 0 0 result: [[

oid1~oid1~oidmon~OID~2045482973:2865

Status: Stop

Operation: internal (time out while waiting for a managed process to stop)

ErrFile: /u02/oracle/config/instances/oid1/diagnostics/logs/OID/oid1/console~OID~1.log

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/oid1/diagnostics/logs/OID/oid1)

[2015-11-17T02:04:27-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

[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.

Leave a Comment: