Java error running banner jobs

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Banner Job submission fails with the below error:

Exception in thread "main" java.sql.SQLException: Could not load class oracle.jdbc.OracleDriver
 at com.sct.messaging.bif.BatchResourceHolder.initialize(BatchResourceHolder.java:60)
 at com.sct.messaging.bif.banner.BannerBatchProcessor.initialize(BannerBatchProcessor.java:82)
 at com.sct.messaging.bif.banner.BannerBatchProcessor.main(BannerBatchProcessor.java:166)

Caused Exception:

com.sct.messaging.bif.BatchProcessorException
 at com.sct.messaging.bif.banner.BannerBatchProcessor.initialize(BannerBatchProcessor.java:85)
 at com.sct.messaging.bif.banner.BannerBatchProcessor.main(BannerBatchProcessor.java:166)

Environment

Release : 9.3

Component : APPLICATIONS MANAGER

Cause

Due to conflict of multiple Oracle environments

Resolution

The error can be cause by a number of factors, it is generally due to a conflict or mixup of multiple Oracle environments.

For example, having 2 different Oracle environments and setting ORACLE_HOME from one Oracle environment but setting an LD_LIBRARY_PATH from the other Oracle environment may cause the issue.

Reviewing the current environment and all relating environment scripts (ie banenv.sh) and make sure only one Oracle environment active should resolve the issue.