Home » Server Options » Replication » error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found (OGG12c)
error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645703] Sun, 13 December 2015 02:29 Go to next message
arminva
Messages: 3
Registered: December 2015
Junior Member
I have below issue during OGG12c DIR installation. I installed jdk1.8 and set JAVA_HOME and PATH.

Execption while processing db setup. Cannot continue. Exception follows...
java.lang.Exception: JDBC Driver Jar not found. Looking for: /u01/oracle/GG_Director/ERROR: Unresolved installer variable "screen.jdbcDriverJarUnix"

Please help.
Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645713 is a reply to message #645703] Sun, 13 December 2015 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
jars are located using CLASSPATH variable
Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645780 is a reply to message #645713] Mon, 14 December 2015 23:42 Go to previous messageGo to next message
arminva
Messages: 3
Registered: December 2015
Junior Member
BlackSwan,
Thanks for reply. I set Oracle bash_profile like below.


TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=testsrv; export ORACLE_HOSTNAME
ORACLE_UNQNAME=testdb; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.1.0.3/db_1; export ORACLE_HOME
ORACLE_SID=testdb; export ORACLE_SID
MW_HOME=$ORACLE_BASE/product/ofm12.1.2; export MW_HOME
WLS_HOME=$MW_HOME/wlserver; export export WLS_HOME
DOMAIN_BASE=$ORACLE_BASE/config/domains; export DOMAIN_BASE
DOMAIN_HOME=$DOMAIN_BASE/mydomain; export DOMAIN_HOME
JAVA_HOME=/usr/java/jre1.8.0_65; export JAVA_HOME

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:/usr/java/jdk1.8.0_65/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$JAVA_HOME/lib:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

But I have same issue. This is cds-tool.log content:


CLASSPATH=/usr/java/jdk1.8.0_65/lib/tools.jar:/u01/app/oracle/product/ofm12.1.2/wlserver/modules/features/wlst.wls.classpath.jar:/usr /java/jre1.8.0_65/lib:/u01/app/oracle/product/12.1.0.3/db_1/jlib:/u01/app/oracle/product/12.1.0.3/db_1/rdbms/jlib

PATH=/u01/app/oracle/product/ofm12.1.2/wlserver/server/bin:/u01/app/oracle/product/ofm12.1.2/wlserver/../oracle_common/modules/org.ap ache.ant_1.9.2/bin:/usr/java/jdk1.8.0_65/jre/bin:/usr/java/jdk1.8.0_65/bin:/u01/app/oracle/product/12.1.0.3/db_1/bin:/usr/java/jdk1.8 .0_65/bin:/usr/sbin:/u01/app/oracle/product/12.1.0.3/db_1/bin:/usr/java/jdk1.8.0_65/bin:/usr/sbin:/u01/app/oracle/product/12.1.0.3/db _1/bin:/usr/java/jdk1.8.0_65/bin:/usr/sbin:/u01/app/oracle/product/12.1.0.3/db_1/bin:/usr/java/jdk1.8.0_65/bin:/usr/sbin:/usr/lib64/q t-3.3/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/u01/app/oracle/product/ofm12.1.2/wlserver/../oracle_common/mo dules/org.apache.maven_3.2.5/bin

Your environment has been set.
Starting ConfigureDirectorServer -- 12.1.2.0.1:


Canonicaly: /u01/oracle
Execption while processing db setup. Cannot continue. Exception follows...
java.lang.Exception: JDBC Driver Jar not found. Looking for: /u01/oracle/GG_Director/ERROR: Unresolved installer variable "screen.jdbcDriverJarUnix"
at com.goldengate.gdsc.util.ConfigDirectorServer.checkDBSetup(ConfigDirectorServer.java:364)
at com.goldengate.gdsc.util.ConfigDirectorServer.startDBSetup(ConfigDirectorServer.java:681)
at com.goldengate.gdsc.util.ConfigDirectorServer.main(ConfigDirectorServer.java:955)

ConfigureDirectorServer Tool -- 12.1.2.0.1
GoldenGate Software (c)2007

Usage is: java -jar cds.jar <property file>
Property file can contain:
director.home=<path to installation directory> This is required.
http.port=<port number> The port the webserver should listen on.
param.dict="<path to new param dictionary file>" Insert the given param dictionary into the system (restart required).
jdbc.driver.jar="<path to jdbc driver jar>" The jar with the jdbc driver to use.
jdbc.driver.apiversion="<major jdbc version number>" The major jdbc version nubmer that this driver supports.
jdbc.driver.class="<full driver classname>" The full classname of the jdbc driver.
jdbc.url="<driver url>" The jdbc url for the driver.
jdbc.username="<username>" The username to log into the database.
jdbc.password="<password>" The password to login to the database (stored in clear text!).
jdbc.testconnection="true | false" Test the connection before attempting switch. Optional. Default is true.
All jdbc properties (except testconnection) are required before the jdbc driver can be configured.

Alternate Options: java -jar cds.jar -pt <port property file> Tests if director servers ports are in use.
java -jar cds.jar --use-current-db-config Will use last valid db config settings in file: cds_current_db_config.xml

[Updated on: Mon, 14 December 2015 23:43]

Report message to a moderator

Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645815 is a reply to message #645780] Tue, 15 December 2015 07:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>java.lang.Exception: JDBC Driver Jar not found. Looking for: /u01/oracle/GG_Director/ERROR: Unresolved installer variable "screen.jdbcDriverJarUnix"
EXPLAIN how error above includes a directory never previously listed in this thread?

where does JDBC jar file reside on this system?
Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645819 is a reply to message #645815] Tue, 15 December 2015 07:55 Go to previous messageGo to next message
arminv
Messages: 1
Registered: October 2012
Location: Iran
Junior Member
I copied OJDBC.jar in JAVA_HOME/lib. Please let me know about correct configuration. One more thing that in OGG home directory I saw db-config.cfg with below content. Look at BOLD row.

# Default DB setting for Director Server.
#
# To change the DB that Director Server uses copy this file
# and edit the values as needed. Then run the cds.jar.
#
# java -jar cds.jar new-director-db-config.cds
#
# The home location of the director server
director.home=../
# Path to the jdbc driver jar file. Relative to this directory
jdbc.driver.jar=ERROR: Unresolved installer variable "screen.jdbcDriverJarUnix"
# The JDBC API version that this driver implements. Typically this will be 2 or 3.
# This is NOT the same as the driver type 1,2,3,4.
jdbc.driver.apiversion=3
# The name of the driver class
jdbc.driver.class=oracle.jdbc.OracleDriver
# The URL that the driver class recognizes
jdbc.url=jdbc:oracle:thin:@localhost:1521:oggdb
# The username to log into the db with.
jdbc.username=ggs_user
# the password to log into the db with.
jdbc.password=samplepassword
Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645822 is a reply to message #645819] Tue, 15 December 2015 08:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/us/products/export/export-regulations-345813.html

arminv
Messages: 1
Registered: October 2012
Location: Iran

You're On Your Own (YOYO)!
Re: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found [message #645874 is a reply to message #645822] Tue, 15 December 2015 10:25 Go to previous message
arminva
Messages: 3
Registered: December 2015
Junior Member
Thanks for your time! Smile
Previous Topic: Golden gate Oracle to MYSQL replication not happening
Next Topic: adding checkpoint table
Goto Forum:
  


Current Time: Thu Mar 28 10:36:25 CDT 2024