This post explains the steps for fixing the OID startup issue - Unable to start OID- ORA-28002, ORA-28002: the password will expire within 7 days . While starting the OID server using the OPMN tool the following error was throwing in the OIDmonitor logs.
Guardian: Connecting to database, connect string is oiddb
Guardian: [gsdsiConnect]ORA-28002, ORA-28002: the password will expire within 7 days
Guardian: [oidmon]: Unable to connect to database, will retry again after 10 sec
The output of the below query showed that the ODS schema password was expired . The solution to fix this issue is to reset the password for ODS schema user .
Steps to reset the ODS password to a new value is explained here . Follow these steps and reset the ODS password to a new value.
Start the OID server using OPMN tool . The OID server will start without any errors.
To avoid password expiry of ODS schema again after 180 days , change the Password Life time of database profile corresponding to ODS to UNLIMITED.