Initialization of JDBC Connection pool failed in Oracle DB.

Initialization of JDBC Connection pool failed in Oracle DB.

book

Article ID: KB0089887

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
============
Initialization of JDBC Connection pool failed in Oracle DB.

Environment:
===========
TIBCO BusinessEvents 5.1.1 .
All Operating Systems.

Symptoms:
========
The following error is encountered:

Failed to initialize pool [JDBCConnectionPoolOracle(jdbc:oracle:oci:@<host>:<port>/<sid>)] during startup
java.lang.Exception: SQL Error while Instantiating Connection Cache :
java.sql.SQLException: Closed Connection
        at com.tibco.cep.modules.db.service.ORAConnectionPool.activate(SourceFile:57)
        at com.tibco.cep.modules.db.service.JDBCConnectionPoolOracle.init(SourceFile:102)
        at com.tibco.cep.modules.db.service.JDBCConnectionPoolManager.init(SourceFile:32)
        at com.tibco.cep.modules.db.service.DBConnectionFactory.initialize(SourceFile:57)
        at com.tibco.cep.modules.impl.ModuleManagerImpl.init(ModuleManagerImpl.java:40)
        at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.initModules(RuleServiceProviderImpl.java:1012)
        at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.initCluster(RuleServiceProviderImpl.java:707)
        at com.tibco.cep.runtime.session.impl.RuleServiceProviderImpl.configure(RuleServiceProviderImpl.java:260)
        at com.tibco.cep.container.standalone.BEMain.jumpStart(SourceFile:151)
        at com.tibco.cep.container.standalone.BEMain.main(SourceFile:69)

Cause:
=====
Environment's PATH variable is missing the Oracle Bin folder entry.

Resolution:
==========
Add the Oracle Bin folder to the Environment's PATH variable.

Issue/Introduction

Initialization of JDBC Connection pool failed in Oracle DB.