Unable to start OID- ORA-28002, ORA-28002: the password will expire within 7 days

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

Unable to start OID ORA 28002 ORA 28002 the password will expire within 7 days1 1024x185 Unable to start OID  ORA 28002, ORA 28002: the password will expire within 7 days

 

 

 

 

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 .

 

OID PASSWORD5 Unable to start OID  ORA 28002, ORA 28002: the password will expire within 7 days

 

 

 

 

 

 

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>