How do I find the name of the database WCC is using?

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

How do I find the name of the database being used by Workload Control Center?

 

Environment

Workload Automation AE 11.3.xWorkload Control Center 11.4.xPlatform: Windows, UNIX/Linux

Resolution

 

Navigate to %CA_WCC_INSTALL_LOCATION%\bin and run the following command:

wcc_config.bat -u <username> -p <password> --displaydb 

 

Example:

wcc_config.bat -u ejmcommander -p ejmcommander --displaydb 

Note: The user specified in the command must have access to 'Configuration' within the WCC ApplicationAccess policies in EEM.

 

Sample Result: 

Database server connection 

TNS name of the database connection: orcl      <<<<<<<<<<<<<<<<<<<< Name of the database 

Path to the tnsnames.ora file: C:\app\Oracle\product\12.1.0\dbhome_2\NETWORK\ADMIN\ 

Platform: ORACLE 

User: wccuser 

Password: ***** 

 

For more information on the wcc_config.bat (or .sh on UNIX/Linux) command please refer to our documentation.

https://docops.ca.com/ca-wla-ae-wcc/11-4-2/en/administrating/administer-ca-wcc/administer-the-configuration-batch-interface