1. Using Oracle SOA Suite on Marketplace in Oracle Cloud Infrastructure
  2. Manage Oracle SOA Suite on Marketplace Instances
  3. Perform Database Operations for an Oracle SOA Suite on Marketplace Instance
  4. Change the Database Schema and Wallet Passwords

Change the Database Schema and Wallet Passwords

Update the password used by an Oracle SOA Suite on Marketplace instance to access the Oracle schemas in the Oracle Cloud Infrastructure database.

When your password is about to expire, make sure that you update it to avoid the following password expiration scenarios:

  • The following Oracle SOA Suite on Marketplace instance-specific datasources fail:

    • EDNDataSource

    • mds-owsm

    • EDNLocalTxDataSource

    • mds-soa

    • OraSDPMDataSource

    • SOADataSource

    • SOALocalTxDataSource

  • The following non-Oracle SOA Suite on Marketplace instance-specific datasources fail and the failure to connect to schemas may lead to production environment shutting down:

    • opss-data-source

    • opss-audit-viewDS

    • opss-audit-DBDS

  • The database user account can get locked because data sources still use the old password and the administrator enters a different password.

When you change the password, the passwords for the Oracle SOA Suite and non-Oracle SOA Suite schemas are reset.

You can only use Oracle SOA Suite to change the password for the Oracle Required Schemas found in the Infrastructure database for an instance. To change the password for schemas hosted in an Application database in your instance, you must directly modify the configuration of both the database and your WebLogic Server domain.

After you update the database schema password, the Oracle Database File System (DBFS) mount point does not work because its wallet is not synchronized with the credentials and fails to mount. To avoid this problem, you must manually update the wallet password.

Topics: