SOA - "ORA-28001: the password has expired" Errors - How to Change the Repository Database Passwords for the SOA Schemas?

(Doc ID 1303698.1)

Last updated on JULY 19, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 and later
Information in this document applies to any platform.

Goal


Your whole SOA enviroment is down and there is no way to make it work.
You have been using Oracle SOA for some time and now you get the following error in your logs:

MDS-01330: unable to load MDS configuration document
MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.
MDS-00922: The ConnectionManager "oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl" cannot be instantiated.
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired


Also, it is possible to find the following error in the logs:

ORA-01017: invalid username/password; logon denied



Solution

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