Failed to install WAAE 11.3.6SP6 on Oracle 12c

Products

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

Issue/Introduction

Installation of WAAE 11.3.6 SP6 on Oracle 12c was interrupted by the below error message:

'The specified Oracle Service ID is a Container Database which cannot be used for the CA Workload Automation AE installation. Provide Pluggable Database to proceed further'.

 

This has been observed with the Windows installer for CA Workload Automation AE 11.3.6 SP6.

 

Environment

CA WA AE 11.3.6 SP6 on Windows

Resolution

Installer extracts a file named conid_info.ora in temporary directory.

After starting the Windows installer and when you are in the Welcome dialog, just replace the content of the conid_info.ora in temporary directory as shown below:

=============================================================================
WHENEVER OSERROR EXIT FAILURE;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
SET HEADING OFF;
SET FEEDBACK OFF;
SET PAGESIZE 0;
SET MARKUP HTML OFF SPOOL OFF;

column CON_ID new_value vresult
SELECT (case when CON_ID = 0 THEN 4 ELSE 0 END) as CON_ID from V$CONTAINERS where ROWNUM=1 order by CON_ID;
EXIT vresult

=============================================================================

Additional Information

 

The above workaround can be used to circumvent this issue, till a fix for the problem is available.

The fix will be available with the next release CA WA AE 11.3.6 SP7 (ETA: Feb 2018)