With Oracle system tables, StreamsRCS fails to start
Symptoms: When you use Oracle for your system tables, the StreamsRCS service fails to start. In the StreamsRCS log the following error occurs.
Error:
Caused by: java.lang.RuntimeException: There were errors initializing your configuration:
<openjpa-2.2.1.1-SNAPSHOT-r422266:1431746 fatal user error>
org.apache.openjpa.util.UserException: A connection could not be obtained for driver class
"oracle.jdbc.OracleDriver" and URL "jdbc:oracle:thin:@//Machine-Name:Port/DB-Name". You may
have specified an invalid URL.
Resolution:
- Copy the ojdbc6.jar file from your from Oracle installation to /home/streamsadmin/OpDetection/StreamsRemoteControlService/ wlp/usr/servers/StreamsRCS/dropins/StreamsRCS/WEB-INF/lib
- Restart the StreamsRCS and StreamsInstance services.