Skip to main content
Delphix

Migrating an Oracle E-Business Suite (EBS) dbTechStack dSource to a New Host (KBA6334)

 

KBA

KBA# 6334

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

4.3

4.3.1.0, 4.3.2.0, 4.3.2.1, 4.3.3.0, 4.3.4.0, 4.3.4.1, 4.3.5.0

4.2

4.2.0.0, 4.2.0.3, 4.2.1.0, 4.2.1.1, 4.2.2.0, 4.2.2.1, 4.2.3.0, 4.2.4.0 , 4.2.5.0, 4.2.5.1

4.1

4.1.0.0, 4.1.2.0, 4.1.3.0, 4.1.3.1, 4.1.3.2, 4.1.4.0, 4.1.5.0, 4.1.6.0

How to Task

Oracle E-Business Suite dSources comprise of the E-Business Suite Application Server Tier, the Oracle Database used by E-Business Suite, and the Oracle Database software binaries.  The Database Software, when linked to Delphix as a dSource, is known as the dbTechStack.  When relocating the Oracle database to a new host, both the database and the dbTechStack must be detached from the old dSource host and attached to the new host.  Delphix provides functionality that facilitates the database migration through the Delphix GUI and CLI and this is documented in the Delphix Documentation.  Relocating the dbTechStack does not have this same degree of clarity in the Delphix Documentation. This knowledge base article exists to cover this dbTechStack relocation process.

Prerequisites

  • An existing E-Business Suite dSource configured within the Delphix Virtualization Engine.
  • A new target host environment that has been discovered through environment discovery and is present in the Delphix Virtualization Engine.
  • Relocation of the dbTechStack and Oracle database from the old dSource environment to the new dSource environment is required.

To complete migration of an EBS dbTechStack

The following list provides an overview of the process for performing the migration:

  • Log in to the Delphix Command Line Interface (CLI) as the "admin" user or a like-privileged user.
  • Locate the existing source configuration in the sourceconfig area of the CLI.
  • Set the environmentUser object to the new environment user associated with the new environment you want the dbTechStack to be relocated to.
  • Set the repository object for the dbTechStack source configuration to the new Oracle Home repository in the new environment.

 

Sample CLI changes:

The existing/old source configuration prior to the environment change being made is seen as follows:

plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD'> ls
Properties
    type: AppDataDirectSourceConfig
    name: current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD
    discovered: false
    environmentUser: current-db1-host/oraerp
    linkingEnabled: true
    parameters: {}
    path: /u01/oraerp/11.2.0
    reference: APPDATA_SOURCE_CONFIG-2
    repository: current-db1-host/E-Business Suite R12.2 dbTechStack
    toolkit: `APPDATA_TOOLKIT-11/ebs122-db

Implement the changes using the commands and following sourceconfig object properties:

  • Update the environmentUser for the EBS dbTechStack sourceconfig to point to the new target environment and new user through the CLI:
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD'> update
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD' update *> set environmentUser=new-db1-host/oraerp
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD' update *> ls
Properties
    type: AppDataDirectSourceConfig
    name: ERPPROD
    environmentUser: new-db1-host/oraerp (*)
    linkingEnabled: true
    parameters: {}
    path: /u01/oraerp/11.2.0
    repository: az-erac-db1-host/E-Business Suite R12.2 dbTechStack
  • Set the new repository for the EBS dbTechStack sourceconfig to the new target environment and new user through the CLI :
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD' update *> set repository="new-db1-host/E-Business Suite R12.2 dbTechStack"
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD' update *> ls
Properties
    type: AppDataDirectSourceConfig
    name: ERPPROD
    environmentUser: new-db1-host/oraerp (*)
    linkingEnabled: true
    parameters: {}
    path: /u01/oraerp/11.2.0
    repository: new-db1-host/E-Business Suite R12.2 dbTechStack (*)
    
plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD' update *> commit
  • From the Delphix GUI, update the configuration using:

Custom -> Configuration -> Modify and set the "DB Tier Context Name" field to match the <CONTEXT_NAME> for the new host.

This value usually corresponds to ${ORACLE_SID}_hostname, or in this case ERPPRD_new-db1-host.

 

The source configuration in the CLI will appear as follows after the changes have been implemented:


plb539.dcenter sourceconfig 'current-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD'> ls
Properties
    type: AppDataDirectSourceConfig
    name: new-db1-host/E-Business Suite R12.2 dbTechStack/ERPPROD
    discovered: false
    environmentUser: new-db1-host/oraerp
    linkingEnabled: true
    parameters: {}
    path: /u01/oraerp/11.2.0
    reference: APPDATA_SOURCE_CONFIG-2
    repository: new-db1-host/E-Business Suite R12.2 dbTechStack
    toolkit: `APPDATA_TOOLKIT-11/ebs122-db


To ensure the changes have been made correctly, capture a snapshot of the dbTechStack in the new environment.