With EM Running, OID 10g Fails To Start Due to ODS Database Account Getting Constantly Locked - oidmon.log error: [Gsdsiconnect] Ora-28000: The Account Is Locked
Last updated on MARCH 08, 2017
Applies to:Enterprise Manager for Fusion Middleware - Version 220.127.116.11.0 to 10.1.2.0.0
Oracle Internet Directory - Version 9.0.4 to 10.1.4 [Release 10gR1 to 10gR3]
Information in this document applies to any platform.
Oracle Internet Directory (OID) fails to start and the ODS database account (which holds the OID objects on the Metadata Repository database) keeps getting locked over and over.
The OID $ORACLE_HOME/ldap/log/oidmon.log shows error:
will retry again after 20 sec
2008/04/22:14:48:34 * Connecting to database, connect string is asdb
2008/04/22:14:48:34 * [gsdsiConnect] ORA-28000, ORA-28000: the account is locked
Tried unlocking the ODS database account as per <Note:563398.1> but it immediately gets locked again.
The problem happens whenever Enterprise Manager (EM) is running, i.e., the Grid Control Agent is started.
The password for the OID database account, ODS, was changed with oidpasswd, and it cannot be reverted back to what it was during install time due to new password policy rules adopted.
Tried running the OID $ORACLE_HOME/bin/oidemdpasswd to update the proper database password for EM to use, however the same problem continues.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms