Adding an Oracle Single Instance or RAC Environment
Datasets / Oracle Environments and Data Sources / Managing Oracle Environments and Hosts / Adding an Oracle Single Instance or RAC Environment

This topic describes how to add a new Oracle or Oracle RAC environment.

Prerequisites

  • See the topics Requirements for Oracle Hosts and Databases.
  • There can be one Oracle unique database name (DB_UNIQUE_NAME) per Delphix Engine. For example, if you provision a VDB with a database unique name "ABC" and later try to add an environment that has a source database that also has a database unique name of "ABC", errors will occur.

Procedure

  1. Login to the Delphix Management application.
  2. Click Manage.
  3. Select Environments.
  4. Click the Actions (...) menu next to Environments and select Add Environment.
  5. In the Host and Server tab, select Unix/Linux.
  6. Select Standalone Host or Oracle Cluster, depending on the type of environment you are adding.
  7. Click Next.
  8. For standalone Oracle environments:
    Enter the Environment name
    Enter Host IP Address
  9. For cluster Oracle RAC environments:
    Enter the Environment name
    Enter Cluster Home
    Enter Node Address

  10. For NFS Addresses (Optional): 
    Enter one or more comma-separated IP Address/Hostname

    In the case of the Oracle RAC environment, ensure that the NFS Address list includes IP Addresses from all the cluster nodes. NFS address given at the time of environment creation is applied to all the discovered RAC nodes. If some nodes in the cluster need a different IP Address list, users can edit the specific host and update the NFS Address after the environment has been created.

    If specified, Delphix Engine only allows NFS requests (mount, etc) originated from IP Addresses specified for the host.
  11. If server authentication for remote host communication or engine to host throughput tests is desired, make sure the appropriate config is set. For more details refer to  Configuring Network Security Settings.  You will need to create a JKS or PKCS#12 keystore on the remote host with the full CA chain of the DSP key in the keystore. By default, the key will just the signed by the Delphix CA, but you can replace the DSP key if you wish.  Refer to KeyStore Settings for more details.
  12. If client authentication for remote host communication or engine to host throughput tests is also desired, make sure the appropriate config is set. For more details refer to  Configuring Network Security Settings  You will need to create another JKS or PKCS#12 keystore on the remote host with the desired key pair. Make sure the created keystore has permissions such that it is readable by all environment users.  Then, add the full CA chain of the remote host’s key pair to the TrustStore on the engine. For more details, refer to TrustStore Settings. 
  13. Enter the SSH port. The default value is 22.

  14. Select a Login Type:
    — Username and Password - enter the OS username and password, or
    — Username and Public Key - enter the OS username.

    Using Public Key Authentication

    If you want to use public-key encryption for logging into your Unix-based 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, you will need to create it.
      1. Run chmod 600 authorized_keys to enable read and write privileges for your user.
      2. Run chmod 755 ~ to make your home directory writable only by your user.

    The public key needs to be added only once per user and per environment.

  15. For Password Login, click Verify Credentials to test the username and password.
  16. Enter Toolkit Path. 
    The toolkit directory stores scripts used for Delphix Engine operations, and should have a persistent working directory rather than a temporary one. The toolkit directory will have a separate subdirectory for each database instance and must have 0770 permissions. At least 1.6 GB of storage is needed at the time of setting up the environment and at least 500MB of free space is required to allow refreshes and maintenance of the toolkit, especially during upgrades.
  17. To provide your own Oracle Java select the Provide my own JDK checkbox and click Next.
  18. In the Java Development Kit, tab enter the absolute path to your Oracle JDK and click Next. For more information, see OpenJDK on Delphix Engine.
  19. Click Submit.

Post-Requisites

After you create the environment, you can view information about it:

  1. Click Manage.
  2. Select Environments.
  3. Select the environment name.

Related Topics