How to enable use of Oracle databases in Greenplum chorus

Post date: Oct 31, 2013 7:33:26 PM

To enable use of Oracle databases

1. Place the Oracle client driver, jar ojdb6.jar, in <installation directory>/shared/libraries. You can find the Oracle client driver at:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html.

2. Set the permissions on the file: chmod 644 ojdbc6.jar

chown chorus:chorus ojdbc6.jar

3. Set oracle.enabled to true in the chorus.properties file (see “Customizing chorus.properties” ).

4. Restart Greenplum Chorus.