Defining ORACLE_RAC login type for OAE agent

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is it possible to create and select  Oracle_RAC login type for OAE agent? Oracle_RAC object allows an automated failover where the OAE login object does not. 

We have created the Login object, but when we look in the drop down list in the agent setup, there is nothing to select.

 

Environment

Release : 9.3x, 9.4x

Component : CA Automic APPLICATIONS MANAGER

Resolution

The OAE Agent currently does not accept "Oracle_RAC" login types at this time. While a RAC database is accepted, most clients use a SCAN RAC which uses a single OAE login.

As a workaround, you can manually set the OAE Agent to use an Oracle RAC login using the below sql:

select SO_LOGIN_NUMBER from SO_IDS where SO_LOGIN='<Oracle Rac Login Name>';

update SO_OPERATORS set SO_AGENT_LOGIN='<so_login_number>' where SO_OPER_NAME='OAE AGENT NAME';

commit;

Please note that the above sequence of sql requires the OAE Agent to be already defined.

We recommend creating a temporary OAE Login so the OAE Agent can be defined and save. Once saved, the above sql can be run to update the login to the Oracle RAC Login.

Please test this on a test system prior to production.

Let us know for questions if any.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/applications-manager/9-3/Oracle_Applications_Extension_Guide/Installing_and_Upgrading_the_OAE_Extension/Defining_the_OAE_Agent.html