Identifying the database being used by WCC/WebUI

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

One can display the Web UI or Reporting database server information by running wcc_config program

Environment

Workload Automation Autosys

Cause

Display the Database Server Information

Resolution

1. Navigate to %CA_WCC_INSTALL_LOCATION%\bin and run the following command:  (for Unix,   /opt/CA/WorkloadAutomationAE/wcc/bin  and the program is wcc_config.sh)
   

   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.

    

2. 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\19.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 Display the Database Server Information