My Oracle Support Banner

Pipeline Not Starting : ERR_DB_CONNECTION_MODULE Error in ifw.DataPool.DiscountModelDataModule.Module (Doc ID 1413793.1)

Last updated on OCTOBER 24, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 27-Feb-2014***

Goal

In a BRM 74 setup, one of the several pipeline instances would not come up successfully and printed below error on the console :

bin/ifw: An error occurred during creation.

Originator : ifw.DataPool.DiscountModelDataModule.Module
Destination :
Message : ERR_DB_CONNECTION_MODULE
Arguments :
State : false
Severity : CRITICAL
Thread : 633055552

 
Additional Information :

* The setup consists of 6 application servers (BRM) having their own pipeline setup
* Three of the BRM instances (pipeline) can start up fine and 3 of them are not starting
* All registry files on all instances are exactly same
* Verified that the library liboci11g6312d.so is same (cksum) on both good and bad servers
* Also verified ldd on this library on both servers and output are the same
* In the process log of the bad server, below messages are printed:

09.02.2012 13:28:43 DEV01 ifw IFW NORMAL [T:3459119424] 00253 - (ifw.DataPool.CustomerData.Module) INF_LOADING_DATA_PLUGIN | Loading data module ifw.DataPool.CustomerData.Module - Version 10285.
09.02.2012 13:28:43 DEV01 ifw IFW NORMAL [T:3459119424] 30060 - (ifw.DataPool.CustomerData.Module) INF_FETCH_SIZE | Fetch size buffer = 1000 rows.
09.02.2012 13:28:46 DEV01 ifw IFW MAJOR [T:3459119424] 00217 - (ifw.DataPool.LoginInfranet.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-12519: TNS:no appropriate service handler found (method DBC::DatabasePlugIn::connection)'.
...
09.02.2012 13:28:46 DEV01 ifw IFW NORMAL [T:3459119424] 00253 - (ifw.DataPool.DiscountModelDataModule.Module) INF_LOADING_DATA_PLUGIN | Loading data module ifw.DataPool.DiscountModelDataModule.Module - Version v10096.
09.02.2012 13:28:47 DEV01 ifw IFW MAJOR [T:3459119424] 00217 - (ifw.DataPool.Login.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-12519: TNS:no appropriate service handler found (method DBC::DatabasePlugIn::connection)'.
09.02.2012 13:28:47 DEV01 ifw IFW MAJOR [T:3459119424] 00217 - (ifw.DataPool.Login.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-12519: TNS:no appropriate service handler found (method DBC::DatabasePlugIn::openConnection)'.
09.02.2012 13:28:47 DEV01 ifw IFW CRITICAL [T:3459119424] 00218 - (ifw.DataPool.DiscountModelDataModule.Module) ERR_DB_CONNECTION_MODULE | Database connection module is invalid.
09.02.2012 13:28:47 DEV01 ifw IFW NORMAL [T:3459119424] 00254 - (ifw.DataPool.DiscountModelDataModule.Module) INF_UNLOADING_DATA_PLUGIN | Unloading data module ifw.DataPool.DiscountModelDataModule.Module.

* This error suggested that there could be some issue in the database side.
* From Oracle database docs about ORA 12519, it indicates the following :

Oracle docs note this about ORA-12519:

ORA-12519: TNS:no appropriate service handler found

Cause: The listener could not find any available service handlers that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener,  and are accepting connections.

Question :

        How can we address the problem ?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.