Change the Schema Password with the Console

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

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 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.