PROD WCC is down - E190664 - Cannot connect to database.

Products

• CA Workload Automation AE

Issue/Introduction

Database server host was changed by DB team and we are trying to modify our config accordingly now, also modified the TNS Connection string as provided by DBA team. But facing issues and are not able to get the URL's back up. 

Updating the database information in WCC using wcc_config is failing with message:
$./wcc_config.sh -u USERNAME --dbuser WCCDBUSER --dbpassword XXXXXXXXXXXXXXX --dbhost dbhostname  --dbport 152 dbtnspath <tnsnames.ora path>
Password:
Logging in as 'username' - SUCCESSCannot validate the database using the connection properties below:
Host Name: hostname
Port: 152
Database instance name: wccwap1p
Platform: oracle
User: WCCDBUSER
Password: *****
E190664 - Cannot connect to database. Changes will not be applied. See log for full exception.

 

Environment

Release : 11.3.6

Component : WORKLOAD CONTROL CENTER

Resolution

The protocol in the tnsnames.ora was TCPS instead of TCP.  However, when using wcc_config batch script to update the new database information, TCPS protocol was not being recognized. 

Changing the protocol in the tnsnames.ora to TCP allowed the wcc_config command to succeed by updating the database information in WCC config.