Info Mart on Redhat with Oracle 11g - Java errors when running the ETL checker

I’m in the middle of deploying Info Mart on Redhat 5.5 with Oracle 11g. When I run the etl checker it complains about the oracle driver. I tried mapping the CLASSPATH and LD_LIBRARY_PATH to different drivers with different results. Just wanted to see if there is a confirmed driver to use:

[genesys@xxxxx]$ ./gim_etl_config_check 
55-35000 "GimConfig.processCfgData: host=cgyvmdevcim01 port=2020 appName=gim_linux outFile=/gcti/gim/gim_etl_cfgs.cfg"
55-35000 "GimConfig.updateAppServers - Connection count=6"
55-35000 "GimConfig.updateAppServers - Primary msgServer: name=Message_Server address=CGYVMDEVCIM01:5150 DBID=167"
2010-06-18 08:48:15,125 INFO  main         55-30000 "System Information:  os.name=Linux, os.arch=i386, os.version=2.6.18-194.el5xen, java.vendor=Sun Microsystems Inc., java.version=1.6.0, user.country=US, user.language=en, user.name=genesys"
2010-06-18 08:48:15,125 INFO  main         55-30013 "Genesys Info Mart version is '7.6.009.08'."
2010-06-18 08:48:15,125 INFO  main         55-30014 "Connected to Config Server 'cgyvmdevcim01:2020' for application 'gim_linux'."
2010-06-18 08:48:15,125 INFO  main         55-30028 "Using JDBC Driver: oracle.jdbc.driver.OracleDriver version: 1.0 for the following DAP(s): dap_gim_icon_cfg_jdbc_linux, dap_gim_icon_jdbc_linux, dap_gim_jdbc_linux, dap_gim_staging_jdbc_linux"
2010-06-18 08:48:15,125 INFO  main         55-30032 "Testing connection to Dap 'dap_gim_icon_cfg_jdbc_linux' for role(s) 'ICON_CFG'"
Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1698)
        at java.lang.Runtime.loadLibrary0(Runtime.java:840)
        at java.lang.System.loadLibrary(System.java:1047)
        at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:304)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:374)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1698)
        at java.lang.Runtime.loadLibrary0(Runtime.java:840)
        at java.lang.System.loadLibrary(System.java:1047)
        at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:304)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:374)
        at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
        at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
[genesys@xxxxx]$ 

Here are the paths:

export ORACLE_HOSTNAME=xxxxx
export ORACLE_SID=orcl
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/owb/wf/lib/ojdbc14.jar:$ORACLE_HOME/oui/jlib/classes12.jar
export PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin

Just to confirm this is all running on 1 server with the applications and database and database driver. I can connect to the database and ICON is running and collecting data.

Gustav,

Neither Red Hat 5.5 nor Oracle 11g is supported by Info Mart so you should not be surprise when it isn’t working… I would recommend you to migrate to supported platforms - Red Hat 4 and Oracle 10g R2.

R.

I hear you regarding supported platforms, this is really a proof of concept in a lab, therefore I was hoping to get away with some of our internal platforms.

However, I did get it working with the following environment settings for the Genesys user:

export ORACLE_HOSTNAME=xxxxx
export ORACLE_SID=orcl
export ORACLE_BASE=/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/bin:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc5.jar