Steps when changing AUTOSYS database in Oracle

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We are migrating to a new database location for better system performance.

Can you please let us know how we can configure the existing Autosys location to be mapped to this new database. Request your inputs to proceed.

 

Environment

Workload Automation AE 11.x/12.x

Resolution

Here are different steps to change your database location :

1. If the tns alias name is not changing, the $TNS_ADMIN/tnsnames.ora file will need to reflect the new hostname or IP address where the database is located.
2. If the tns alias name is changing, the $AUTOUSER/config.$AUTOSERV file needs to be modified. You need to change the EventServer entry.
   
   Then the $TNS_ADMIN/tnsnames.ora file will need to reflect the new hostname or IP address where the database is located and new tns alias name.
    
3. Migrate the data by using Oracle import/export facility for Oracle.
4. The Autosys client and/or agents will not need any modifications because those components don't access the database directly
5. Check the sqlnet.ora to make sure it is properly set and also ensure the service_name matches with what the DB Server is listening to.
   
   Run command " lsnrctl status " on the DB server and compare the output.
    
6. And finally make sure that the Unix/Linux rights of the TNS_ADMIN path and files tnsnames.ora and sqlnet.ora allow this to be read by everyone