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.
Release : 11.3.6
Component : WORKLOAD CONTROL CENTER
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.