Oracle EBS discovery operations

Adding an environment

This topic describes the process of adding a Oracle EBS source and target environment.

Prerequisites

Ensure all the essential requirements, as described in Requirements and Prerequisites are met.

Procedure

Perform the following steps to add an environment to the Delphix Continuous Data Engine:

  1. Login to the Delphix Management application.

  2. Navigate to the Manage > Environments page.

  3. Click the Actions ... menu and select Add Environment.

  4. From the Add Environment dialog window, select Unix/Linux.

  5. Select Standalone Host.

  6. Click Next.

  7. Provide the name of the environment.

  8. Provide the Host IP address or host FQDN.

  9. Provide the SSH port. The default value is 22.

  10. Provide an Environment Username for the environment. If you intend to use a low-privileged environment user, ensure that you have fulfilled the Privilege elevation requirements for Oracle EBS.

  11. Choose the Login Type that fits your setup. 

  • Username and Password – provide the environment username and password

  • Username and Public Key – provide the environment username 

  • Password Vault – select from an existing Enterprise Password Vault

Note: Using Public Key Authentication
If you want to use public-key authentication for logging into your Unix-based environment, you have two options: 

  1. For Password, enter the password associated with the user in step 11.

  2. If you want to use Public Key Encryption for logging into your environment:

    1. Select Public Key for the Login Type

    2. Click View Public Key

    3. Copy the public key that is displayed, and append it to the end of your ~/.ssh/authorized_keys file. If this file does not exist, it must be created.

The addition of the public key is a one-time requirement per user and per environment. Additionally, you have the option to add public key authentication to an environment user's profile via CLI (for details, refer to the CLI Cookbook: Setting up SSH key authentication for UNIX environment users topic).
  1. For Password Login, click Verify Credentials to test the username and password.

  2. Enter Toolkit Path (ensure that the toolkit path does not have any spaces).

  3. To provide your own Oracle Java Development Kit, select the Provide my own JDK checkbox and click Next.

    1. On the Java Development Kit page, provide an absolute path to your Oracle JDK and click Next

  4. Click Submit.

After successfully adding and discovering the environment, you should be able to view the newly added environment listed under the Environments tab. In case it does not appear, click the refresh icon in your browser.

After the environment has been successfully discovered, if you wish to establish further links, add a source configuration to the previously discovered installation.

Perform the following steps to access the information about any environment you have created:

  1. Navigate to Manage > Environments.

  2. Select the environment name.

Discovery of the Oracle database is handled by Continuous Data Engine. To add the EBS DBTechstack and AppsTier installations, you must add “Source Config” for each under the respective installations.

Adding Source Config

Details of how to add source config for DBTechstack and AppsTier

  1. In Delphix Continuous Data Engine, navigate to Manage > Environments.

  2. Select the environment name in which you want to add source config.

  3. Click the Environment Details tab.

  4. If the oracle environment user described in Requirements for Oracle EBS source databases for linking is not already added to the Delphix Continuous Data Engine, add the user.

  5. Click the Databases tab.

  6. Click the Plus icon within the E-Business Suite R12.2 DBTechstack section under installations.

  7. Add Database dialog box pops to add source config for DBTechstack.

  8. Provide a user-defined name to the `Database Name` field and Oracle base install directory in the `Path` field.

  9. Click on the Add button to successfully add the source config.Oracle EBS discovery operations