CA WCC R11.4 SP2 upgrade fails *** Reporting database error ***

Document ID : KB000072144
Last Modified Date : 26/02/2018
Show Technical Document Details
Issue:

Upgrading CA Workload Control Center to R11.4 SP2 fails with *** Reporting database error ***
 

WCC Install log shows JDBC errors:
----------------------------------------------------------
2015-12-02 16:27:33 : DatabaseUtil:: Generated URL = jdbc:ca:oracle:TNSNamesFile=/opt/CA/oraclient/app/product/11.2.0.1/client_1/network/admin/tnsnames.ora;TNSServerName=
2015-12-02 16:27:33 : DatabaseUtil:: getSelectedDBConnectionString - Return
2015-12-02 16:27:33 : DatabaseUtil:: java.sql.SQLNonTransientConnectionException: [CA][Oracle JDBC Driver]Missing connection information. When using the TNSNamesFile connect option, a value must also be specified for the TNSServerName connect option.
2015-12-02 16:27:33 : DatabaseUtil:: [CA][Oracle JDBC Driver]Missing connection information. When using the TNSNamesFile connect option, a value must also be specified for the TNSServerName connect option.
----------------------------------------------------------

Cause:

TNS Alias/Net-service name entry for WCC or Reporting databases in the WCC connection.properties files is missing.

Resolution:

Applicable for both WCC and Reporting databases; when you choose to use TNSNamesFile connect option. Valid TNSServerName should be present in the WCC connection.properties file.

Verify current WCC connection.properties file is pointing to a valid TNS Alias name for parameters wcc.database.tnsname and reporting.database.tnsname

Note: Location of the connection.properties file is %CA_WCC_INSTALL_LOCATION%\data\config\application\config\resources (Windows) and $CA_WCC_INSTALL_LOCATION/data/config/application/config/resources (UNIX/Linux)

If the tnsname parameters highlighted below are blank please update them according to your Oracle environment.

Example: WCC connection.properties file from a Linux server using "WCCDB" as TNS alias for WCC and Reporting databases.

User-added image
 

Additional Information: