Skip to Content
0
Former Member
Mar 23, 2005 at 04:17 PM

Portal Activity Reporting with Oracle

29 Views

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