1. Administering Oracle SOA Cloud Service
  2. Administer Oracle SOA Cloud Service
  3. Perform Database Operations for an Oracle SOA Cloud Service Instance
  4. Change the Database Schema and Wallet Passwords

Change the Database Schema and Wallet Passwords

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

You must change the password for the Oracle schemas to meet Oracle security policies, corporate security policies or government regulations, or in response to a perceived security threat. By default, the password expires 180 days after your service instance is created.

Password expiration leads to the following scenarios:

  • The following Oracle SOA Cloud Service instance-specific datasources fail:

    • EDNDataSource

    • mds-owsm

    • EDNLocalTxDataSource

    • mds-soa

    • OraSDPMDataSource

    • SOADataSource

    • SOALocalTxDataSource

  • The following non-Oracle SOA Cloud Service instance-specific datasources fail and the failure to connect to schemas might 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.

For Oracle SOA Cloud Service instances provisioned in Oracle Cloud Infrastructure Classic, to change the password for the Oracle Required Schemas found in the associated database (see Database):

For Oracle SOA Cloud Service instances provisioned in Oracle Cloud Infrastructure, to change the password for the Oracle Required Schemas found in the associated database (see Database), you must directly modify the configuration of both the database and your WebLogic Server domain. See Change the Database Schema Password Using the Oracle SOA Cloud Service Console.

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

Note:

The following schemas are updated during the update schema password operation:
Entity Schema
WebLogic Server

IAU

IAU_APPEND

IAU_VIEWER

MDS

OPSS

STB

WLS

WLS_RUNTIME
Oracle SOA Cloud Service

SOAINFRA

UMS

ESS

MFT

Note:

If your service instance was created before November 2017 (release 18.2.5), you cannot use the Oracle SOA Cloud Service Console to change the schema password. You must perform these modifications manually on your service instance.

Topics: