Change the Schema Password with the Console

Not Oracle Cloud at Customer This topic does not apply to Oracle Cloud at Customer.

Use Oracle SOA Cloud Service to change the Oracle schema password in the Oracle Database Cloud Service deployment, and to also update your service instance to use the new password.

Note:

This topic does not apply to Oracle Cloud Infrastructure native database.

Note:

The following schemas are updated during the updated 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

Update the Database Schema Password

  1. Access your service console.
  2. Click the name of the service instance whose schema password you want to change.
  3. At the bottom of the Overview page, expand Associations.
  4. From the list of associations for this service instance, identity the association with these characteristics:
    • Service Type - Oracle Database Cloud Service
    • Type - Depends On
  5. Click Manage Association Menu icon for this association, and then select Update Database Credentials.

    This menu option is only available for the Infrastructure database association. It it not available for Application databases.

  6. Complete the following input fields:
    Field Description

    Database Administrator Username

    Enter the name of the system administrator for the selected database deployment.

    Password

    Enter the password for the database administrator.

    New Schema Password

    Enter a new password for the Oracle schemas in the selected database deployment.

    The password must start with a letter, be between 8 and 30 characters long, and contain at least one number. The password can optionally include the special characters: $, #, _.

  7. Click Update.

    You can monitor the operation’s progress from this page or from the Activity page. Oracle SOA Cloud Service updates the database credentials, the WebLogic Server domain configuration, and the bootstrap credentials. If you service instance is running WebLogic Server 11g or 12.1.3, then all server processes are restarted as well.

Update the Wallet Password

After you update the 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 avoid this problem, you must manually update the wallet password.

See Remounting DBFS Shared Storage in SOA CS and MFT CS Clusters.