B.4. Oracle Database Setup


For Oracle extraction, Tungsten Cluster must have write access to the database so that status and progress information can be recorded correctly.

B.4.1. Oracle Version Support

Database Version Support Status Notes
Oracle 10g Release 2 (, 11g Primary Platform Synchronous CDC is supported on Standard Edition only; Synchronous and Asynchronous are supported on Eneterprise Editions

B.4.2. Oracle Environment Variables

Ensure the tungsten user being used for the master Tungsten Replicator service has the same environment setup as an Oracle database user. The user must have the following environment variables set:

Environment Variable Sample Directory Notes
ORACLE_HOME /home/oracle/app/oracle/product/11.2.0/dbhome_2 The home directory of the Oracle installation.
LD_LIBRARY_PATH $ORACLE_HOME/lib The library directory of the Oracle installation.
ORACLE_SID orcl Oracle System ID for this installation.
JAVA_HOME   The home of the Java installation.
PATH $ORACLE_HOME/bin:$JAVA_HOME/bin Must include the Oracle and Java binary directories.
CLASSPATH $ORACLE_HOME/ucp/lib/ucp.jar:$ORACLE_HOME/jdbc/lib/ojdbc6.jar:$CLASSPATH Must include the key Oracle libraries the Oracle JDBC driver.

These should be set within the .bashrc or .profile to ensure these values are set correctly for all logins.