Delphix – What to do when the Production Database moved to another server?
What to do when the Production Database moved to another server?
Recently we had an interesting case where our customer moved 4 of the Production Databases to other servers. The servers that the databased move to are in similar configurations but still Delphix threw the error since it could not connect to the database.
Now we have a dSource in Delphix Engine that does not have the source database to receive the snapshots. The solution to this problem consist of multiple steps:
1) Unlink/Detach the dSource from its source database: This will give us the chance to delete the old environment since it is no longer used in the system. Deletion can be either performed GUI or Delphix CLI (Command Line Interface).
2) Add new environment: This step is required since the database is moved to a new server. Adding new environment might require creation of an operating system user and providing required user rights for this user in the new server.
Once the new environment is added, it is likely that Delphix will find the database(s) that are running in the new environment. If not, new database information should be added manually.
Please be aware that after adding database we will skip the “add dSource” step.
3) Attach dSource to new environment: Since we have a dSource and the new environment we need make these to related to each other. This step requires Delphix CLI access with delphix_admin account. After connecting to CLI with delphix_admin the following commands are required to run.
delphix> database "dexample" delphix database "dexample"> attachSource delphix database "dexample" attachSource *> set attachData.type=OracleAttachData delphix database "dexample" attachSource *> set attachData.config=<name-of-database-in-new-environment> delphix database "dexample" attachSource *> set attachData.environmentUser=<env-user> delphix database "dexample" attachSource *> set attachData.dbUser=<orauser> delphix database "dexample" attachSource *> set attachData.dbCredentials.password=<orauserpwd> delphix database "dexample" attachSource *> commit *dexample: <name of the dSource that we want to make changes>
After “commit” your new environment will be connected to the dSource again.
ps: You can always visit https://www.delphix.com for more details