Update the Database Schema Password
When the database schema password expires, it must be updated. You can update the database schema password using an automation script or perform the steps manually.
Note:
The database schema password must be same for all database schemas.Update the Database Schema Password Using an Automation Script
Prerequisite: The Administration Server must be up and running.
To update the database schema password using an automation script:
- Test database connectivity using the following
ping
command:java -classpath /u01/app/oracle/middleware/wlserver/server/lib/ weblogic.jar utils.dbping ORACLE_THIN username password HOST:PORT:DBNAME
-
Use the
ssh
command to connect to the Administration Server VM (as theopc
user):ssh -i private_key opc@AdminServerVM_IP_address
-
Change to the
oracle
user:sudo su - oracle
-
Navigate to the directory containing automation scripts:
cd /opt/scripts/runbooks
-
Run the script to update the database schema password and respond to the prompts for WebLogic Server administration password, RCU schema prefix, and RCU password:
./updateDBPassword.sh
- Update the wallet password. See Update the DBFS Wallet Password.
- Stop and then restart the Managed Servers. It is not necessary to stop and start the Oracle SOA Suite on Marketplace instance. See Stop or Start the Managed Servers.
Update the Database Schema Password Manually
The following summary shows the high-level tasks to update the database schema password manually. Detailed steps are below.
- Test database connectivity using the following
ping
command:java -classpath /u01/app/oracle/middleware/wlserver/server/lib/ weblogic.jar utils.dbping ORACLE_THIN username password HOST:PORT:DBNAME
-
Update each infrastructure repository schema's password on the database deployment.
-
If the WebLogic Servers are running and the WebLogic Server Administration Console is accessible, update the password for all the corresponding data sources from the WebLogic Server Administration Console.
-
If the WebLogic Servers are not running and the WebLogic Server Administration Console is inaccessible, manually update the passwords in the WebLogic Server configuration.
-
Update the bootstrap credentials using the WebLogic Scripting Tool (WLST).
-
Start the Administration Server with the Node Manager, and then start the Managed Servers.
To update the database schema password manually: