CMT Failed When Running On Oracle 11g

(Doc ID 1126048.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Haansoft Linux x86-64
***Checked for relevance on 30-Mar-2012***
***Checked for relevance on 29-August-2015***


Symptoms

After installing Conversion Manager (CMT), running pin_cmt fails with oracle driver issues (using JDK 1.5):

[pin - srvxxx02b]/apps/BRM/portal/7.4/apps/cmt:pin_cmt -import -file sample7.xml
Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:993)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:304)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:374)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:515)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:345)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.portal.pcm.DatabaseConnection.createOracleConnection(Unknown Source)
at com.portal.cmt.DBConnectionPool.createOCIConnection(Unknown Source)
at com.portal.cmt.DBConnectionPool.getConnection(Unknown Source)
at com.portal.cmt.DBConnectionPool.init(Unknown Source)
at com.portal.cmt.DBConnectionPool.<init>(Unknown Source)
at com.portal.cmt.DBConnectionPool.getInstance(Unknown Source)
at com.portal.cmt.DBConnection.getDBConnection(Unknown Source)
at com.portal.cmt.CMTUtils.fetchPoids(Unknown Source)
at com.portal.cmt.CMTUtils.getNewPoidId(Unknown Source)
at com.portal.cmt.CMTUtils.getBatchId(Unknown Source)
at com.portal.cmt.Driver.init(Unknown Source)
at com.portal.cmt.Driver.getInstance(Unknown Source)
at com.portal.cmt.Cmt.main(Unknown Source)


Script pin_cmt has been changed to get driver acceptable for Oracle 11g, with driver ($ORACLE_HOME/jdbc/lib/ojdbc5.jar) instead of the standard classes12.jar.

Then, run pin_cmt with samplexxx.xml, and it fails on functional error (test with standard sample.xml), which freezes CMT process:

***************************************************
Batch id for this process is: 3208086
***************************************************
===================================================
Executing Import ...
===================================================
===================================================
Preprocess step done in 1634 mili-seconds
===================================================
===================================================
Total Number Of Records : 1
Number Of Success Records : 1
===================================================
Exception in thread "main" java.lang.IllegalAccessError: tried to access class oracle.jdbc.driver.OracleCallableStatement from class com.portal.cmt.CMTupdater
at com.portal.cmt.CMTupdater.updateDueAmount(Unknown Source)
at com.portal.cmt.Driver.executeImport(Unknown Source)
at com.portal.cmt.Driver.execute(Unknown Source)
at com.portal.cmt.Cmt.main(Unknown Source)


A clean Oracle driver configuration for CMT deployment is needed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms