Password Expiry for Database
If a password expires or is changed, credential issues may arise with the Meta Data Store (MDS) or with an integration specific database. To fix this issue, perform the following steps:
1. Reset or unlock the password for the corresponding database (MDS or integration specific database).
2. Change the password for the data source for which the password is changed/or locked from the WebLogic Administration console.
3. Change the password in the InstallationProperties.xml for the database instance (this helps only while reinstalling).
4. Perform the following steps to find the adf-config.xml file that is generated during installation.
The file is generally located at $PRODUCT_HOME/install/util/template/.
a. Identify the correct “metadata-store-usage” from the “meta-data-namespaces” element by the path mentioned above.
b. In the “metadata-store-usage” element, find the element property with the attribute value as “jdbc-password” for the “name” attribute.
c. Change the password for the value attribute in the property element.