You can select the Oracle OCI connection type. Then, configure the tnsnames.ora on that server, as required.
Ah... Okay. Your are talking about the RA Retail Connection Object, and not the regular CONN object.
To get that to use the RAC, you will have to use your scan-ip and RAC service name in the free form window. You will need to speak with the consultant that worked with you on the configuration of the system for the best solution to fit your system architecture.
If you are using OS clustering, the RA Retail agent should be installed on the clustered file system. In a fall-over situation, the cluster file system and service IP will be moved by the OS from the fail node to the standby node. Then, the cluster service will start the application services on the standby node making it active. The start sequence for the RA Retail agent should be a service in the cluster application service.
Another way to do it would be to install the RA Retail agent on the local file system. Then, you would have 2 RA Retail agent in an Automic Agent Group. Then, you would assign all the Retail job to that group. Using this scenario, you will not have to deal with the OS cluster, Cluster service IP and file system. You must ensure that the workflows does not have re-use agent calculation in the Attributes tab.
I am planning to install the agent using a very similar configuration.
Would you have a guide on how to set it up?
I haven't seen anything on the guide for Oracle cluster.
Anyone else able to help on this?