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.


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


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









Oracle SOA Cloud Service





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.


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

To update the wallet password.
  1. Regenerate the DBFS wallet with a new password:
    1. Log in as the oracle user.
    2. Go to the DBFS directory:
    3. Back up the old wallet:
      mv wallet wallet_bckup
    4. Create a new wallet directory:
      mkdir wallet
    5. Create a temp file to store the database credentials:
      vi /var/tmp/dbfsp
    6. Enter the new credentials three times in the dbfsp file on three different lines.
    7. Save the file.
    8. Generate the Oracle Wallet at /u01/data/domains/<domain_name>/dbfs by executing the following command:
      $middleware_home/oracle_common/bin/mkstore -wrl /u01/data/domains/domain_name 
      /dbfs/wallet -create < /var/tmp/dbfsp
    9. Add the new credentials in the wallet by executing the following command. For this example, SchemaPrefix_DBFS is the DBFS user name specified:
      $middleware_home/oracle_common/bin/mkstore -wrl /u01/data/domains/domain_name/dbfs/wallet 
      -createCredential ORCL SchemaPrefix_DBFS < /var/tmp/dbfsp
    10. Repeat Step 1 on all nodes of the managed server.
  2. Verify the status of the mount:
    ls –ltr /u01/soacs
    1. If the permissions on mount directories /u01/soacs/dbfs and /u01/soacs/dbfs_directio are corrupted (shows ???? in place of permissions), execute the following commands:
      fusermount -u /u01/soacs/dbfs
      fusermount -u /u01/soacs/dbfs_directio
    2. Verify the status of the mount directory again:
      ls –ltr /u01/soacs
    3. Once the directory permissions are restored, go to step 3.
  3. Restart the Oracle SOA Cloud Service and Oracle Managed File Transfer Cloud Service instances from Oracle SOA Cloud Service Console.

If you have issues in mounting DBFS, see Remounting DBFS Shared Storage in SOA CS and MFT CS Clusters.