WCC 11.4 SP7 installer loops at DB validation
Article ID: 202461
Updated On:
Products
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.
Feedback
