How to enable use of Oracle databases in Greenplum chorus

posted Apr 28, 2017, 4:05 PM by Sachchida Ojha
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.

Comments