search cancel

WCC 11.4 SP7 installer loops at DB validation

book

Article ID: 202461

calendar_today

Updated On:

Products

CA Workload Automation AE

Issue/Introduction

The WCC installer loops through the following message while installing the WCC 11.4 SP7 pointing to the Oracle 19c (Oracle TNS) database. : 

===============================================================================
Database Settings
-----------------

WCC DB
  ->1- Oracle
    2- Oracle TNS
    3- Oracle TNS PKI
    4- Microsoft SQL Server
    5- Internal (Derby)

Database Type: 2
tnsnames.ora directory path (Default:
   /opt/oracle/instantclient_19_6/network/admin):
Net service alias (Default: AUTOSYS_WCC_DEV2):
User (Default: AUTOSYS_WCC_MON):
Password:*xxxxxxxx*

******************************************************************************
*
*** Database Version Warning ***
********************************
The version <19.0.0.0.0> of the Oracle database for WCC DB was not supported at
the time the application was released.
Please consult the WCC documentation for more details or http://support.ca.com
for currently supported databases.
Please be aware that you may encounter unexpected issues if you choose to
'Continue with the Installation'.
  ->1- Change Database
    2- Continue with the Installation

ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE
   DEFAULT: 2
WCC DB
    1- Oracle
  ->2- Oracle TNS
    3- Oracle TNS PKI
    4- Microsoft SQL Server
    5- Internal (Derby)

Database Type:
tnsnames.ora directory path (Default:
   /opt/oracle/instantclient_19_6/network/admin):
Net service alias (Default: AUTOSYS_WCC_DEV2):
User (Default: AUTOSYS_WCC_MON):
Password:*xxxxxxxx*

******************************************************************************
*
*** Database Version Warning ***
********************************
The version <19.0.0.0.0> of the Oracle database for WCC DB was not supported at
the time the application was released.
Please consult the WCC documentation for more details or http://support.ca.com
for currently supported databases.
Please be aware that you may encounter unexpected issues if you choose to
'Continue with the Installation'.
  ->1- Change Database
    2- Continue with the Installation

ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE
   DEFAULT:

Environment

Release : 11.3.6

Component : WORKLOAD CONTROL CENTER

Cause

WCC 11.4.7 is shipping ojdbc7.jar which works with Oracle 19c without enabling network security and data integrity.

The ojdbc8.jar is needed when the network security and data integrity are enabled in the Oracle 19c.

The ojdbc8.jar with WCC 11.4.7 can not be used during installation as all the libraries are getting loaded when the installer is invoked.

The installer does not consider the new libraries.

Resolution

Autosys R12 WebUI works fine with the Oracle 19c as it is shipped with ojdbc8.jar. However, for WCC 11.4.7 the below can be followed as a workaround - 

Install WCC 11.4.7 with derby database.

Replacing ojdbc7*.jar files with ojdbc8.jar in  following WCC install directories:

  • /opt/CA/WorkloadCC/bin/lib/ojdbc7.jar

  • /opt/CA/WorkloadCC/tomcat_32/lib/ojdbc7-12.1.0.2.0.jar

  • /opt/CA/WorkloadCC/tomcat/lib/ojdbc7-12.1.0.2.0.jar

  • /opt/CA/WorkloadCC/tomcat/webapps/collector/WEB-INF/lib/ojdbc7-12.1.0.2.0.jar

Ensure they have world execute permissions and are owned by wcc:wcc.