This topic does not apply to Oracle Cloud at Customer.
Note:This topic does not apply to Oracle Cloud Infrastructure native database.
Note:The following schemas are updated during the updated schema password operation:
|Oracle SOA Cloud Service||
Update the Database Schema Password
- Access your service console.
- Click the name of the service instance whose schema password you want to change.
- At the bottom of the Overview page, expand Associations.
- From the list of associations for this service instance, identity the association with these characteristics:
- Service Type - Oracle Database Cloud Service
- Type - Depends On
- 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.
- Complete the following input fields:
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: $, #, _.
- 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.