This topic describes the process of linking an EBS R12.1 instance and creating the necessary dSources.

Prerequisites

Prepare your source EBS R12.1 instance for linking by following the outline in Preparing a Source EBS R12.1 Instance for Linking.

Procedure

Link the Oracle Database

  1. Link the Oracle database used by EBS as outlined in Linking an Oracle Data Source.

Link the EBS dbTechStack

  1. Login to the Delphix Management application.

  2. Click Manage.
  3. Select Environments.
  4. Select the source dbTier environment containing the source dbTechStack.
    If you have not already added the environment, see the Managing Unix Environments topics for more information about adding environments.

    Linking from RAC dbTier

     

    If you are linking from a RAC dbTier, select the environment for a single running node of the RAC cluster.  

  5. Click the Environment Details tab.

  6. If the oracle environment user described in Preparing a Source EBS R12.1 Instance for Linking  is not already added to the Delphix Engine, add the user.
    For more information about adding environment users, see the Managing Unix Environment Users topics.

  7. Click the Databases tab.

  8. Click the Plus icon next to Add Dataset Home.
    Adding the files as a dataset home will register the type and location of the files with the Delphix Engine.

  9. For your Dataset Home Type , select E-Business Suite R12.1 dbTechStack.
    When you select this type of dataset home, the Delphix Engine will know to automate pre-clone logic. Specifically, adpreclone.pl dbTier will be run prior to every SnapSync of the dbTechStack. During dSource creation, you will be able to enter additional pre-clone steps as Pre-Sync hook operations.

  10. Enter an Installation Home.
    This path should be the Oracle base install directory. For example, if the value of $ORACLE_HOME on your source environment is /u01/oracle/VIS/db/tech_st/11.1.0, the Oracle base install directory is /u01/oracle/VIS.

  11. Click the Confirm icon to save your dataset home.
    If necessary, scroll down the list of dataset homes to view and edit this dataset home.
  12. Click Manage > Datasets.
  13. Select Add dSource.
  14. In the Add dSource wizard, select the dbTechStack files source you just created.

  15. Enter the EBS-specific parameters for your dbTechStack.
    These parameter values will be used when adpreclone.pl is run.
    Ensure that the DB Tier Context Name uses the short hostname.

  16. Click Advanced.

  17. Exclude the EBS database's data files if they are stored underneath the Oracle base install directory. 
    These data files will be linked with the database i nstead of with the dbTechStack . Add the relative path to the data files to the  Paths to Exclude  list.

    Ensure that you add the relative paths and NOT the absolute paths.

    For example, if you want to exclude the /u01/oracle/VIS/data path, then add "data" only under the Paths to Exclude list. Here, /u01/oracle/VIS/data is the absolute path and "data" is the relative path to be added.

  18. Click Next.

  19. Enter a dSource Name.

  20. Select a Database Group for the dSource.
  21. Click Next
    Adding a dSource to a database group enables the ability for you to set Delphix Domain user permissions for that dSource's objects, such as snapshots. For more information, see the topics under Users, Permissions, and Policies.
  22. Select a SnapSync policy. 
  23. Click Next.
  24. Enter any custom pre- or post-sync logic as Pre-Sync or Post-Sync hook operations.
    Remember that adpreclone.pl dbTier is already run prior to every SnapSync of the dbTechStack.
    The Pre-Sync hook operations will be run prior to running the adpreclone.pl tool. 
    For more information, see Customizing Unstructured Files with Hook Operations.

  25. Click Next.

  26. Review the dSource Configuration and Data Management information, and then click Submit.
    The Delphix Engine will initiate two jobs to create the dSource,  DB_Link and  DB_Sync . You can monitor these jobs by clicking  Active Jobs in the top menu bar, or by selecting  System > Event Viewer. When the jobs have completed successfully, the files icon will change to a dSource icon on the Environments > Databases screen, and the dSource will be added to the list of Datasets under its assigned group.

Link the EBS appsTier

  1. Login to the Delphix Management application.

  2. Click Manage.
  3. Select Environments.
  4. Select the source appsTier environment
    If you have not already added the environment, see the Managing Unix Environments topics for more information on how to do so.

    Linking from multi-node appsTier

     

    If you are linking from a multi-node appsTier, select the environment for the node on which EBS admin services reside.

  5. Click the Environment Details tab.

  6. If the applmgr environment user described in Preparing a Source EBS R12.1 Instance for Linking is not already added to the Delphix Engine, add the user.
    For more information about adding environment users, see the Managing Unix Environment Users topics.

  7. Click the Databases tab.

  8. Click the Plus icon next to Add Dataset Home.
    Adding the files as a dataset home will register the type and location of the files with the Delphix Engine.

  9. For your Dataset Home Type, select E-Business Suite R12.1 appsTier.
    When you select this type of dataset home, the Delphix Engine will know to automate pre-clone logic. Specifically, the Delphix Engine will run adpreclone.pl appsTier prior to every SnapSync of the appsTier. During dSource creation, you will be able to enter additional pre-clone steps as Pre-Sync hook operations.

  10. Enter an Installation Home.
    This path should be the Oracle base install directory. For example, if the value of $APPL_TOP on your source environment is /u01/oracle/VIS/apps/apps_st/appl, the Oracle base install directory is /u01/oracle/VIS.

  11. Click the Confirm icon to save your dataset home.
    If necessary, scroll down the list of dataset homes to view and edit this dataset home.
  12. Click Manage > Datasets.
  13. Select Databases.
  14. Select Add dSource.
  15. In the Add dSource wizard, select the appsTier files source you just created.

  16. Enter the EBS-specific parameters for your appsTier.

    These parameter values will be used when adpreclone.pl is run.
    The APPS Password is needed to accomplish the provision. This field is important for password change functionality.
    The Parameter Context Name should be the value of $CONTEXT_NAME in the environment being linked.
    Ensure that the Instance Home Directory specifies an absolute path.
  17. Click Next.

  18. Enter a dSource Name.

  19. Select a Database Group for the dSource.
  20. Click Next
    Adding a dSource to a database group enables you to set Delphix Domain user permissions for that dSource's objects, such as snapshots. For more information, s ee the topics under Users, Permissions, and Policies.
  21. Click Next.

  22. Select a SnapSync policy.
  23. Click Next.
  24. Enter any custom pre- or post-sync logic as Pre-Sync or Post-Sync hook operations. 
    Remember that adpreclone.pl appsTier is already run prior to every SnapSync of the appsTier. 
    The Pre-Sync hook operations will be run prior to running the adpreclone.pl tool.
    For more information, see Customizing Unstructured Files with Hook Operations

  25. Click Next.

  26. Review the dSource Configuration and Data Management information, and then click Submit.
    The Delphix Engine will initiate two jobs to create the dSource, DB_Link and DB_Sync. You can monitor these jobs by clicking Active Jobs in the top menu bar, or by selecting System  >  Event Viewer. When the jobs have successfully completed, the files icon will change to a dSource icon on the Environments  >  Databases screen, and the dSource will be added to the list of Datasets under its assigned group.

Related Links