OIM And/or SOA Datasources do not Connect after Changing Schema Password (Doc ID 2099794.1)

Last updated on MARCH 08, 2017

Applies to:

Identity Manager - Version 11.1.2.3.4 and later
Oracle SOA Suite - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

After changing the schema password for all the servers(BI,OIM & SOA), the SOA and OIM servers are starting but some operations fail.
- Followed note 1672134.1 for steps.

Example:
Some how requests are not created and the following error is seen in logs.
Also soa-infa is shown as down in EM console.

Caused by: javax.ejb.CreateException: SDP-25700: An unexpected exception was caught.
Cause: weblogic.common.resourcepool.ResourceDeadException: 0:
Could not connect to 'oracle.jdbc.OracleDriver'.

The returned message is: ORA-01017: invalid username/password; logon denied

It is likely that the login or password is not valid.
It is also possible that something else is invalid in
the configuration or that the database is not available.
Action: Check the stack trace for more details.
at oracle.sdpinternal.messaging.storage.MessagingStoreBean.ejbCreate(MessagingStoreBean.java:175)
at oracle.sdpinternal.messaging.storage.MessagingStore_urkbp2_Impl.ejbCreate(Unknown Source)
... 56 more
; nested exception is: com.oracle.pitchfork.interfaces.LifecycleCallbackException: Failure to invoke public void oracle.sdpinternal.messaging.storage.MessagingStore_urkbp2_Impl.ejbCreate() throws javax.ejb.CreateException,javax.ejb.EJBException on bean class class oracle.sdpinternal.messaging.storage.MessagingStore_urkbp2_Impl with args: []
]]

 

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