Change the Database Schema Password Using the Oracle SOA Cloud Service Console

This topic applies only to Oracle Cloud Infrastructure Classic.

If you want to change the password for the Oracle Database schemas used by your Oracle SOA Cloud Service instance, and your service instance was created after November 2017 (release 18.2.5), then you can use the Oracle SOA Cloud Service console to change the Oracle schema password in the Oracle Database Classic Cloud Service deployment, and to update your service instance to use the new password.

To change the database schema password using the Oracle SOA Cloud Service Console:

1. In the Oracle SOA Cloud Service Console, click the name of the service instance whose schema password you want to change.
2. At the bottom of the Overview page, expand Associations.
3. From the list of associations for this service instance, identity the association with these characteristics:
   • Service Type - Oracle Database Cloud Service
   • Type - Depends On
4. Click Manage Association 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.

5. 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: $, #, _.

6. 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 your service instance is running WebLogic Server 12.1.3, then all server processes are restarted as well.

7. Update the wallet password. See Update the DBFS Wallet Password.