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

Prerequisite

Upload the EBS 12.2 dbTechStack plugin and refresh the environments during the preparation of the source environment. For more information, see Upgrade EBS Objects to 6.0.

For successful linking of DBTECHSTACK from the standby site, follow any one of the procedures below:

  • Place the physical standby database in READ ONLY mode and run linking of source DBTECHSTACK. Even during subsequent snapsync operations, you have to make sure that the standby database is in READ ONLY mode.
  • Perform the linking of dbTechStack(ORACLE_HOME) from the primary source site which is in READ_WRITE mode.
  • Before DBTechStack linking, to ensure that the hook operation succeeds during database provision, the ETCC patch level should be the latest. In the configure clone 1 hook adcfgclone dbconfig will perform the ETCC patch level check and will fail if it's not the latest.
  • While linking using the EBS plugin, the plugin runs adpreclone.pl dbTier in the background, which asks for apps database user password and connects with standby DB. If database is in MOUNT state then linking fails, as apps schema will not be able to login into standby DB.
  1. Login to the Delphix Management application.

  2. Click Manage.

  3. Select Environments.
  4. Select the source dbTier environment containing the source dbTechStack.

    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.

  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 > Datasets.
  13. Click the Plus icon and 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.
    In the DB Tier Context Name field, provide the source context name; To get the DB Tier context name on source side:

    • For Oracle 12.1.0.2 version,

      cd $ORACLE_HOME
      source SID_hostname.env file
      echo $CONTEXT_NAME

      Below is an example, 
      Consider VISDB as the database SID and tavsrc-db as the short hostname.

      [oravis@tavsrc-db VIS]$ source /u01/oracle/VIS/12.1.0.2/VISDB_tavsrc-db.env
      [oravis@tavsrc-db VIS]$ echo $CONTEXT_NAME
      VISDB_tavsrc-db




    • For multi-tenant database,
      CONTEXT_NAME will be (<PDB_NAME>_<short hostname>)
    • For RAC,
      CONTEXT_NAME will be <INSTANCE_SID>_<HOSTNAME>
      For example: VIS2_exaukdb02

  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. If the audit files (located under $ORACLE_HOME/rdbms/audit) are large in size, the path of these files could also be excluded so as to avoid dbTechStack timeout issues during provisioning.

    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 you to set Delphix Domain user permissions for that dSource's objects, such as snapshots. 
  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. 

  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  Datasets under its assigned group.

Link the EBS appsTier

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

  2. Click Manage.
  3. Select Environments.
  4. Select the source appsTier environment.

    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.

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


  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

    • fs2/EBSapps or fs1/EBSapps depending on patch FS in your environment.
    • EBSapps.env
      You can exclude all other directories or files placed in $APPS_BASE path.

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

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

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

  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 Datasets under its assigned group.

Related Topics