CA Workload Automation AE (WAAE) installation, new or upgrade, fails during the Event Server (AEDB) creation when using Oracle Database server.
The WAAE installation log [CAWorkloadAutomationAE.log in $CASHCOMP/installer/log directory on Unix or Linux | Install(%AUTOSERV%).log or Install_Upgrade.log in the %AUTOROOT% folder on Windows] shows errors similar to the following;
11:29:41 ++ -- WA: CreateAEDB.pl for Oracle failed. For more information, see: /opt/CA/SharedComponents/installer/log/CAWorkloadAutomationAE.log
11:29:41 ++ -- WA: Also, see: /tmp/ora_createaedb_pri
CreateAEDB: CA Workload Automation AE database was not created or updated. Please check /tmp/ora_createaedb_pri/install_aedb.log for details.
And the install_aedb.log file contains errors:
-------------------------------------------------------------------------------
SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 14 12:29:41 2017
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
...
...
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Return code = 256
CA Workload Automation AE database was not created or updated.
-------------------------------------------------------------------------------