To restore the default embedded vRealize Orchestrator database settings on a vRealize Automation 7.3.x appliance, please complete the steps below:
- Backup and/or snapshot the vRealize Automation environment.
- Secure Shell (SSH) login to each vRealize Automation virtual appliance node.
- Stop the vRealize Orchestrator services:
- service vco-server stop
- service vco-configurator stop
- Reset the vRealize Orchestrator database configuration by running the following command
- /usr/lib/vco/tools/configuration-cli/bin/vro-configure.sh db --type psql --skipUpdateDbScheme --databaseName vcac --dbUsername vcac --dbPassword $(/usr/sbin/vcac-config prop-util -d --p `xpath /etc/vcac/server.xml "//@password" 2>&1 | grep password | cut -d'"' -f2`) --port 5433 --jdbcUrl 'jdbc:postgresql://127.0.0.1:5433/vcac?sslmode=verify-ca&sslrootcert=/var/vmware/vpostgres/current/.postgresql/root.crt' --host 127.0.0.1
- Start the vRealize Orchestrator services:
- service vco-server start
- service vco-configurator start
- Login to the vRealize Orchestrator client and validate the most recent content is still present.
Note: The first vco-server start, after resetting the database connection, may take a bit more time as changing the database settings will force plug-in reinstalls (This is a safe procedure).