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

Prerequisites

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 Admin application using Delphix Admin credentials.

  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.2 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.2 dbTechStack.
    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 dbTier 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/11.2.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.
  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 instead of with the dbTechStack. Add the relative path to the data files to the Paths to Exclude list.

  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 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 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 Snapshot 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 Finish.
    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  My Databases under its assigned group.

Link the EBS appsTier

  1. Login to the Delphix Admin application using Delphix Admin credentials.

  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 about adding environments.

    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.2 Instance for Linking   is not already added to the Delphix Engine, add the user.
    For more information about adding environment users, s ee 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.2 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 one level above Run/Patch edition file system base directory. For example, if the value of $RUN_BASE on your source environment is /u01/oracle/VIS/fs1, the 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.
  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.

  17. Click Advanced .

  18. Add the relative paths of files to exclude to the  Paths to Exclude  list.
    Exclude the non-edition file system, instance directories, and FMW home directories which will be recreated when provisioning a virtual EBS appsTier.
    These paths should typically include:

    • fs_ne
    • fs1/inst
    • fs2/inst
    • fs1/FMW_Home
    • fs2/FMW_Home
  19. Click Next.

  20. Enter a dSource Name.

  21. Select a Database Group for the dSource.
  22. 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 .
  23. Click Next.

  24. Select a SnapSync policy. 
  25. Click Next.
  26. 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 . 

  27. Click Next.

  28. Review the dSource Configuration and Data Management information, and then click Finish.
    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 My Databases under its assigned group.

Related Links