CA-wcc-services keeps failing
Article ID: 219808
Updated On:
Products
Issue/Introduction
The CA-wcc-services service keeps failing, locking out the WCC appl user account. We've tried to chg the WCC_USER psw, but can't seem to find out where else it needs to be changed since it keeps locking.
Here's what we change (it's a dual WCC host; single WCC Oracle DB on Linux). tnsnames.ora file exists. WCC was working fine until a week or so ago(after an OS patch which may/may not have been the culprit).
autouser@test-server:wcc/bin --> ./wcc_config.sh -u <WCC Uid> --dbuser WCC_USER --dbpassword <psw>
Password:
Logging in as '<WCC Uid>' - SUCCESS
Cannot validate the database using the connection properties below:
TNS name of the database connection: Oracle_SID
Path to the tnsnames.ora file: /opt/oracle/product/19c/client/network/admin
Schema User: fRZSwWIQyzsNDwmh1Iv8ASNempC7QF8LIIyQHpuI9T3bTvKofbR8PXXXXXXXXXXXXXXXX==
Platform: ORACLE
User: WCC_USER
Password: *****
E190664 - Cannot connect to database. Changes will not be applied. See log for full exception.
Environment
Release : 12.0
Component : WORKLOAD CONTROL CENTER
Resolution
For 12.0.01, run wcc_config.sh to change the password.
For 12.0.00, use the following workaround:
1. Make a copy of the following files:
$CA_WCC_INSTALL_LOCATION/data/config/application/config/resources/connection.properites
$CA_WCC_INSTALL_LOCATION/collectors/data/config/application/config/resources/connection.properties
2. Reset the following parameters to the new password for your WCC database user in both files:
reporting.database.password=<new password of database user>
wcc.database.password=<new password of database user>
Note: the password is in clear text at this time.
3. Change the database user password in the database to be the same as used in connection.properties.
4. Restart WCC services.
5. Run wcc_config.sh and use the new password as you use in connection.properties.
6. Restart WCC services again. The password in connection.properties will then be encrypted.
Feedback
