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 (Doc ID 567256.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Fusion Middleware - Version 9.0.2.0.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.

Symptoms

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:

2008/04/22:14:48:14 * [oidmon]: Unable to connect to database,
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.

Changes

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.

Cause

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