I am trying to configure portal activity reporting on a WAS 6.40 box with EP SP 11 patch 2 installed. The underlying database is oracle. I am getting the following error:
com.sap.sql.log.OpenSQLException: Could not load class oracle.jdbc.OracleDriver
These are the lines from my DB_Connection.properties file:
#Oracle Properties:
URL=jdbc:oracle:thin:@localhost:1527:DP1
DRIVER_CLASSNAME=oracle.jdbc.OracleDriver
And these are the lines from my Aggregator.sh file:
#! /bin/ksh
J2EE_HOME=/usr/sap/EDP/JC00
if [ "R$J2EE_HOME" = "R" ]
then
echo J2EE_HOME not set.
echo "Please enter the path to your J2EE instance(ex. /usr/sap/XXX/JCXX):"
read J2EE_HOME
fi
export WCR_PATH=$J2EE_HOME/j2ee/cluster/server0/apps/sap.com/irj/servlet_jsp/irj/root/web-inf/portal/portalapps/com.sap.portal.activityreport.core
export CLASSPATH=$J2EE_HOME/j2ee/admin/lib/opensqlsta.jar:$J2EE_HOME/j2ee/admin/lib/exception.jar:$J2EE_HOME/j2ee/admin/lib/admin.jar:$J2EE_HOME/j2ee/admin/lib/logging.jar:$J2EE_HOME/j2ee/cluster/server0/bin/core_lib/tc_sec_secstorefs.jar:$J2EE_HOME/j2ee/classes12.jar:$J2EE_HOME/j2ee/jdbc/base.jar:$J2EE_HOME/j2ee/jdbc/util.jar:$J2EE_HOME/j2ee/cluster/server0/bin/ext/antlr/antlr.jar:$J2EE_HOME/j2ee/cluster/server0/bin/ext/jdbdictionary/jddi.jar:$WCR_PATH/lib/com.sap.portal.activityreport.core_api.jar
if [ -f $JAVA_HOME/bin/java ]
then
$JAVA_HOME/bin/java -cp $CLASSPATH com.sap.portal.webreport.tools.Aggregator $@
else
echo JAVA_HOME not found. Please set JAVA_HOME and run aggregator.sh again.
fi
Does anyone have any thoughts on this?
TIA