Steps to validate the Delphix database account (i.e. "delphix_db") password
Delphix uses the delphix_db database user account for connecting to a VDB over a JDBC connection. In the event that a database user password is locked/changed, Delphix would throw a fault notification and subsequent VDB Snapshot would throw following error...
Note: The virtual database (VDB) is likely still up, running, and accessible by Applications connecting to that database using any other database credentials, but for some reason the credentials for the delphix_db database account are no longer working.
To verify whether the delphix_db password has changed, open the detailed VDB database card and select the DB User option and enter the known password and click “Verify Credentials”. If the password has been changed then an error would result, similar to that shown below...
If the delphix_db password was changed recently, enter the new password and verify first that it is connecting successfully. Once it is working, consider refreshing the Target Environment to update Delphix repository with new password as shown below:
Steps to validate the Delphix OS account (i.e. "delphix_os") password
Delphix uses delphix_os user account for connecting to a target database server, using SSH for UNIX/Linux servers, using Powershell for Windows servers. To verify if the password to the delphix_os account has changed, please select Manage -> Environments from the top menu on the Delphix graphical user-interface, and choose the target environment from the list of environments in left-hand navigation bar on that screen.
Choose the Environment Details panel for the selected target environment, and then enter the delphix_os password as shown...
Delphix would throw an error if the password is changed. Please enter the new password and re-try the operation to ensure Delphix is able to connect successfully.
Note: Please refresh the Target environment if the password is changed to update the Delphix data repository.
Recommendation for SSH access on UNIX/Linux servers:
- If it is likely that the password for the delphix_os account will be changed frequently, perhaps due to a corporate password-change policy, then another alternative to consider is to use “Public Key Authentication" (PKA), as it is more secure and removes any dependency on passwords being changed/locked.