E-IB: Is it Possible to Enable Active Data Guard (ADG) Database Routing for Any Read-Only Integration Broker Service Operation? (Doc ID 2081968.1)

Last updated on NOVEMBER 25, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Goal

PeopleTools 8.54 delivered product documentation, in book "Data Management", chapter "Implementing Oracle Active Data Guard" discusses which PeopleSoft objects can be used with Active Data Guard (ADG) standby database and the ways to enable those objects for it.

(See for example at http://docs.oracle.com/cd/E58500_01/pt854pbh1/eng/pt/tadm/task_ImplementingOracleActiveDataGuard-3b7d04.html )

It describes the ways to ADG-enable PeopleSoft Component objects and PeopleSoft batch (Process Scheduler) processes, but not other kinds of objects such as Integration Broker service operations.

On the other hand it says, on passing: "There is a limited set of Integration Broker service operations that are enabled, and those operations are specifically related to Feeds and QAS."

On inspecting the PSOPERATION table that stores Integration Broker service operation definition data, it has a field called IB_ACTIVEDATAGUARD (of type small int, not null).
That field has value '1' for some delivered service operations, in particular those with names matching pattern ''QAS%' and some of those named in pattern 'PTFP%' .

However there seems to be no user interface control, such as a checkbox in a PIA page or an Application Designer property sheet, to mark a service operation for ADG routing of SQL statements.

The question is:

If there is a number of custom Integration Broker service operations that are known to issue only read-only SQL to the database (only get data, never modify those data),
is it feasible to set PSOPERATION.IB_ACTIVEDATAGUARD = 1 at the database back-end in their respective definition rows, to enable ADG routing of their SQL?
 

Solution

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