ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Does Application Manager 9.2+ support load balancing for multi-node Oracle Applications databases?

book

Article ID: 88134

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Error Message :
N/A

Prior to the release of Applications Manager (AM) version 9.2, AM used a DBMS_PIPE package to connect to the Oracle Applications (OA) databases.  Therefore, AM did not support load balancing for multi-node OA databases.

However, an enhancement to AM in 9.2 replaced the DBMS_PIPE package with Oracle Advanced Queuing (AQ) which allows AM to support load balancing for multi-node Oracle Applications databases.

Cause

Cause type:
Other
Root Cause: In Applications Manager v9.2 the DBMS_PIPE package has been replaced by Oracle Advanced Queuing (AQ) for OAE related code to support Oracle E-Business suite on RAC. 

Environment

OS Version: N/A

Resolution

Update to a fix version listed below or a newer version if available, where Advanced Queing has been implemented and allows for laod balancing to be enabled on the Oracle Applications database.

The DBMS_PIPE package has been replaced by Oracle Advanced Queuing (AQ) for OAE related code to support Oracle E-Business suite on RAC. 
New installation and upgrade instructions are added to the documentation.

Beware:  This functionality is only for connections to the Oracle Applications databases.  Load balancing for the Application Manager core repository is not a supported configuration as it is known to cause performance degradation.

Fix Status: Released

Fix Version(s):
Application Manager 9.2 - Available

Additional Information

Workaround :
N/A