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

Document ID : KB000016730
Last Modified Date : 14/02/2018
Show Technical Document Details
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

Question:

 

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
Answer:

 

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