Oracle driver error

Opportunity Detect is installed using the manual database setup option, and the system tables are in Oracle. The following error occurs in the trace log.

org.apache.axis2.AxisFault: A connection could not be obtained for driver class "oracle.jdbc.OracleDriver" and URL "jdbc:oracle:thin:@//[DB Host]:[Port]/[Schema]". You may have specified an invalid URL.

Procedure

  1. Add the ojdbc7.jar file on the runtime server in the following location. /home/streamsadmin/OpDetection/StreamsRemoteControlService/wlp/usr/servers/StreamsRCS/dropins/StreamsRCS/WEB-INF/lib/.
  2. Restart the Streams instance and the StreamsRCS service.