The BPEL Process State Switches Off when Oracle Database Service Shuts Down

(Doc ID 457412.1)

Last updated on JULY 29, 2008

Applies to:

Oracle(R) BPEL Process Manager - Version: 10.1.3.1
This problem can occur on any platform.

Symptoms

A BPEL process which has a database adapter associated with it, which is polling for changes to a table in this database, automatically changes the BPEL process’s state from "ON" to "OFF" when the database is shutdown and / or restarted. Effectively switching off the BPEL process indefinitely until it is manually changed back to on in the BPEL console.

Steps To Reproduce:

1. Deploy BPEL process that is polling for changes in Oracle 10g database.
2. View the BPEL process state in BPEL console - should be on.
3. Through SQLPLUS, shutdown and start the database.
4. View the BPEL process state in BPEL console - now is off.

Impact:

Unable to perform cold backup of database.

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