OID 10g ODS Schema Is Locking After Password Change. The emagent.trc Shows: OCI Error -- ErrorCode(1017): ORA-01017: invalid username/password; logon denied
(Doc ID 419674.1)
Last updated on AUGUST 30, 2023
Applies to:
Oracle Internet Directory - Version 9.0.4 to 10.1.2 [Release 10gR1 to 10gR2]Information in this document applies to any platform.
Symptoms
- After changing the Oracle Internet Directory (OID) ODS Database (DB) schema password, opmnctl startall hangs on the Mid Tier and eventually results in the ODS schema password becoming locked
- ACCOUNT_STATUS of the ODS user in the database changes to LOCKED(TIMED) after 5-10 minutes
- When the ODS password is changed back to the original password, the schema is not locked again
- Enterprise Manager (EM) is being used to monitor OID
- AGENT_HOME/sysman/log/emagent.trc shows:
2007-03-14 12:52:17 Thread-77585328 WARN vpxoci: OCI Error -- ErrorCode(1017): ORA-01017: invalid username/password; logon denied
SQL = " OCISessionBegin"...
LOGIN = ods/<PASSWORD>@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTO =TCP)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))
2007-03-14 12:52:17 Thread-... ERROR vpxoci: ORA-01017: invalid username/password; logon denied
2007-03-14 12:52:17 Thread-... WARN vpxoci: Login ... failed, error=ORA-01017: invalid username/password; logon denied
2007-03-14 12:52:17 Thread-... ERROR engine: [oracle_ldap,10_1_2_<OID_HOSTNAME>_LDAP,LDAPserverMemHealthStatsCC] : nmeegd_GetMetricData failed : ORA-01017: invalid username/password; logon denied
2007-03-14 12:52:17 Thread-77585328 WARN collector: <nmecmc.c> Error exit. Error message: ORA-01017: invalid username/password; logon denied
Changes
The ODS schema password was changed.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |