Autosys installation stuck on Oracle database connection test

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation Agent

Issue/Introduction

During an Autosys installation, the install appears to be stuck performing a database connection test and does not move forwward.

Cause

This issue can occur when the tnsnames.ora file has thousands of entries. The installer gets stuck scanning the tnsnames.ora file for the SID that was provided earlier during the install.

Environment

Release:
Component: ATSYS

Resolution

We recommend creating a separate tnsnames.ora file with only the entries needed for the AEDB. By referencing it during the install it will perform the connection test very quickly.

Additional Information

Tested with 5000 entries in the tnsnames.ora