Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

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

Solution

To configure 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 10.2.0.4 from the Oracle driver download site.
  3. Copy the Oracle JDBC driver to the following locations on the vCO 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 vCO configuration interface in a browser at:

    http://vco_server:8282/

  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.

    IMPORTANT
    : After you update the vmo-ds.xml file, the Database tab in the vCO 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 vCO server host.
    For example, copy the tnsnames.ora file to C:\Oracle.
  10. Open the installation_dir\app-server\server\vmo\conf\vmo.properties file in a text editor.
  11. Add this entry the vmo.properties file: 

    oracle.net.tns_admin=C:\Oracle

  12. Restart the vCO 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.

Feedback

  • 7 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)
  • 7 Ratings
Actions
KB: