The installation of CA WAAE 11.3 fails during the database creation with perl script CreateAEDB.pl

Products

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

Issue/Introduction

Description:

The installation of CA WAAE 11.3 fails during the database creation with perl script CreateAEDB.pl

Solution:

The installation of CA WAAE 11.3 GA on AIX 6.1 fails during the creation of the database: AEDB with the following error:

CreateAEDB.pl for Oracle failed. For more information, see:
/opt/CA/SharedComponents/installer/log/CAWorkloadAutomationAE.log
Also, see: /tmp/ora_createaedb_pri

When running manually the script:

perl CreateAEDB.pl COAS1R SYS dba autosys autosys
/opt/CA/SharedComponents/JRE/1.5.0 /tmp/ora_createaedb_pri Y AEDB_DATA
"/db/COAS1R_1" "2048" "AEDB_INDEX" "/db/COAS1R_1" "800"

we get error:

....
110000 sqlplus -L "SYS/[email protected] AS SYSDBA" 
@/tmp/ora_createaedb_pri/tempchkpwd.sql 
sh: sqlplus: not found 
115000 32512 
125000 32512

As a possible workaround:

• Specify the full path of sqlplus in CreateAEDB.pl
• Use a non root user (auto_dev)

Investigation:

In this AIX machine The ENV variable is defined as follow:
ENV=/.kshrc which means that Korn shell is used for root user

From the following link:
http://docsrv.sco.com/SHL_custom/The_Korn_shell_profile_and_kshrc.html:

The .profile file is read once, by the login ksh. The ENV file is read by each invocation of ksh

If ENV is defined in the current environment then this variable is available to all future child shells (unless ENV is unset).

Resolution:

[root]co-autosys1-pprd:/# unset ENV

Environment

Release:
Component: ATSYS