Search the VMware Knowledge Base (KB)
View by Article ID

Add support for RAC and TNS configuration for Oracle 11g Database instances to vRealize Orchestrator (1022828)

  • 8 Ratings


You can configure vRealize Orchestrator (formerly known as vCenter Orchestrator) to support Oracle Real Application Clusters (RAC) 11g using TNSNAMES aliases instead of IP addresses or DNS names.


To configure vRealize Orchestrator (formerly known as vCenter Orchestrator) to support Oracle Real Application Clusters (RAC) 11g using TNSNAMES aliases:

  1. Verify that the Oracle database server is correctly configured to support connections with TNSNAMES aliases. 
    1. Open the $ORACLE_HOME\network\admin folder
    2. Check that the tnsnames.ora file is well-formed
    3. Check that the sqlnet.ora file contains the TNSNAMES protocol. You should see an entry similar to NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)

  2. Download the Oracle JDBC driver version from the Oracle driver download site.
  3. Copy the Oracle JDBC driver to the following locations on the vRealize Orchestrator server:   
    • installation_dir\app-server\server\vmo\lib\
    • installation_dir\configuration\jetty\lib\ext\ 

  4. Remove any existing older versions of the Oracle JDBC driver.
  5. Open the vRealize Orchestrator configuration interface in a browser at:


  6. On the Database tab, set the database name to a classic Oracle thin-style service scheme connection, that follows the host, port, service name syntax.
    For example, jdbc:oracle:thin:@myhost:1521/myservicename
  7. Open the installation_dir\app-server\server\vmo\deploy\vmo-server\vmo-ds.xml  file in a text editor.
  8. Edit the vmo-ds.xml file to use your TNSNAMES alias by replacing jdbc:oracle:thin:@ myhost:1521/myservicename with jdbc:oracle:thin:@YOUR_TNSNAMES_ALIAS.

    : After you update the vmo-ds.xml file, the Database tab in the vRealize Orchestrator configuration interface will show a configuration error. However, the configuration  works correctly.

  9. Copy the tnsnames.ora file from the Oracle database server (or create the file) to the vRealize Orchestrator server host.
    For example, copy the tnsnames.ora file to C:\Oracle.
  10. Open the installation_dir\app-server\server\vmo\conf\ file in a text editor.
  11. Add this entry the file:\Oracle

  12. Restart the vRealize Orchestrator server.
IMPORTANT: If you subsequently modify the database configuration using the Orchestrator configuration interface, the above modifications are lost.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.


  • 8 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)

Please enter the Captcha code before clicking Submit.
  • 8 Ratings