What to do when the Production Database moved to another server?

Share on facebook
Share on google
Share on twitter
Share on linkedin

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 Source 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.

Recent Posts

Achieving DataOps

DataOps defined by Gartner as “collaborative data management practice focused on improving the communication, integration and automation of data flows between data managers and data

Delphix Use Cases for Insurance Market

When we start talking about big companies and their approach to handling their software delivery methods data comes out eventually as an obstacle to the