For Oracle extraction, Tungsten Cluster must have write access to the database so that status and progress information can be recorded correctly.
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.