Knowledge Base

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.