WCC DB issue when external DB is used during installation. Login timeout

Document ID : KB000044167
Last Modified Date : 14/02/2018
Show Technical Document Details


During the installation of WCC with Oracle database, the installation stopped with error:

2016-06-07 13:21:47 : DatabaseUtil:: Substitute on $WCC_TNSNamesFilePath$ yields </Oracle/app/oracle/product/client112/Client_2/network/admin/tnsnames.ora>
2016-06-07 13:21:47 : DatabaseUtil:: Generated URL = jdbc:ca:oracle:TNSNamesFile=/Oracle/app/oracle/product/client112/Client_2/network/admin/tnsnames.ora;TNSServerName=WCC
2016-06-07 13:21:47 : DatabaseUtil:: getSelectedDBConnectionString - Return
2016-06-07 13:21:57 : DatabaseUtil:: [CA][Oracle JDBC Driver]Login has timed out.



WCC 11.4 SP1 on Linux with Oracle external database


Oracle SID for this WCC  installation was WCC

In the tnsnames.ora file, there were two entries:

The first one with “WCC.world”

The second one with  “WCC”

For example:





Remove the “WCC.world” entry from the tnsnames.ora 

Additional Information:

If for whatever reason both entries are required, the tnsnames.ora file can be copied at another location to only keep the entry without .world

For example in /opt/CA/WorkloadCC