The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Add support for RAC and TNS configuration for Oracle 11g Database instances to vRealize Orchestrator (1022828)
To configure vRealize Orchestrator (formerly known as vCenter Orchestrator) to support Oracle Real Application Clusters (RAC) 11g using TNSNAMES aliases:
- Verify that the Oracle database server is correctly configured to support connections with TNSNAMES aliases.
- Open the $ORACLE_HOME\network\admin folder
- Check that the tnsnames.ora file is well-formed
- Check that the sqlnet.ora file contains the TNSNAMES protocol. You should see an entry similar to NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
- Download the Oracle JDBC driver version 10.2.0.4 from the Oracle driver download site.
- Copy the Oracle JDBC driver to the following locations on the vRealize Orchestrator server:
- Remove any existing older versions of the Oracle JDBC driver.
- Open the vRealize Orchestrator configuration interface in a browser at:
- 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.
- Open the installation_dir\app-server\server\vmo\deploy\vmo-server\vmo-ds.xml file in a text editor.
- 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 vRealize Orchestrator configuration interface will show a configuration error. However, the configuration works correctly.
- 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.
- Open the installation_dir\app-server\server\vmo\conf\vmo.properties file in a text editor.
- Add this entry the vmo.properties file:
- Restart the vRealize Orchestrator server.
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.