Database Adapter and Bpel Process Manager run out of Database Connections

-
Oracle(R) BPEL Process Manager - Version: 10.1.2.0.2

Symptoms
The problem manifests itself by the database adapter and BPEL running out of database connections. New connections cannot be established.

The following error might occur as a side effect:

Database Adapter::Inbound oracle.tip.adapter.db.InboundWork runOnce Exception during
polling of the database ORABPEL-11624 DBActivationSpec Polling Exception.
Query name: [ClarifyPollingProdService], Descriptor name:
[ServiceRequestAutomation.TableCase].
Polling the database for events failed on this iteration.
If the cause is something like a database being down successful polling will resume once conditions change.
Caused by Exception [TOPLINK-4002]

(OracleAS TopLink - 10g (9.0.4.5) (Build 040930)):
oracle.toplink.exceptions.DatabaseException
Exception Description:
java.sql.SQLException: Io exception: Connection timed out
Internal Exception: java.sql.SQLException: Io exception: Connection timed out
Error Code: 17002.

Cause

Both OC4J running BPEL and the database adapter reached the maximum number of connections and were unable to establish new ones.

The reason for the problem is a database adapter Bug 5595347.

According to Bug 5595347, the database adapter might leave open connections behind.
The fix for Bug 5595347 is included in Patch 5638122.

Solution
To implement the solution, please execute the following steps:

Apply Patch 5638122.

References
Bug 5595347 - ORIONCMTCONNECTION NOT CLOSED IN ORABPEL~OC4J_BPEL~DEFAULT_ISLAND~1
Note 314422.1 - Remote Diagnostic Agent (RDA) 4 - Getting Started
Patch 5638122 - MERGE LABEL REQUEST ON TOP OF 10.1.2.0.2 FOR BUGS 5149866 5595347 5205630

Comments

Post a Comment

Popular posts from this blog

How to mount a WD Book Live as NFS in OEL6U3

-
Scenario : I have a Windows 8 (Host) laptop on which I am running two OEL6U3 (Guest) machines in a Virtual Box. I want to have a shared mount between the two Linux machine which will allow me to read/write from both the machines concurrently. Its a very common scenario for a High Availability Environment. Virtual Box provides a facility of creating sharable VDI disks which can be mounted on multiple machines, but it doesn’t allow concurrent read/write access from multiple machines. If you are installing RAC database then its still achievable, because ASM will provide the feature of concurrent read/writes, but if you want to install a WebLogic cluster with High Availability the recommended approach would be to have a Shared Mount. Step to create a shared nfs mount is fairly simple. I am using a WD My Book Live, and will mount the Public folder as shared mount 1. Get the hostname/ip of the WD device. 2. On the Linux Machine 1 create the folder where you want to mount the nfs
Read more

ORA-44412: XE edition memory parameter invalid or not specified

-
SQL> connect sys as sysdba Enter password: Connected to an idle instance. SQL> startup ORA-44412: XE edition memory parameter invalid or not specified SQL> startup pfile=C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 bytes Redo Buffers 2904064 bytes Database mounted. Database opened. SQL> create spfile from pfile='C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts\init.ora'; File created. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 805306368 bytes Fixed Size 1289996 bytes Variable Size 209715444 bytes Database Buffers 591396864 byt
Read more

Oracle SQL Developer 19.4 font too small

-
Image
I downloaded the latest version of Oracle SQL developer on my windows laptop and when I started it, the font on GUI was too small. To fix the font size scroll to the bottom of the  'Welcome Page' and uncheck 'show on startup'. Restart the SQL Developer and issue will be fixed.
Read more