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:
[code][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]$ [/code]
Here are the paths:
[code]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[/code]
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.
