Installed AEWS on seperate server, how to change dbaccessmode as scripts not avaliable

Article Id: 16730

Status: Published

Updated On: 14-02-2018 07:52

Legacy Id: TEC1099204

Products:

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

Issue/Introduction:

I have only installed CA-AEWS (Web Services) on a separate server connected to the scheduling Database (oracle). We have now changed the scheduler to use oracle wallets to only allow TCPS protocol to access the database, but script switchDBAccessMode.pl is not present to change the DBAccessMode on the CA-AEWS server

Need to migrate all the CA Autosys components to use TCPS protocol towards the oracle DB

(which requires oracle wallets for the connection validation)

How do we configure the Autosys web server to use an Oracle wallet for the database connection ?

Environment:

WORKLOAD AUTOMATION AE, Release: 11.3.6. sp6

Resolution:

If CA-AEWS is installed on a separate server and directory $AUTOSYS/dbobj/switchDBAccessMode does not exist, with the switchDBAccessMode.pl perl script,you can copy it from the Autosys Scheduler

For the configuration see details at this link
https://docops.ca.com/display/CWAA/.DBAccessMode+vAE_11.3.6_SP6