Malik_Abdul_8942

Update the ucsrv connection strings in bulk

Discussion created by Malik_Abdul_8942 on Aug 28, 2017

Question:

We have a migration going on in our environment where all exalogic servers will be migrated to cloud. In this case there is a possibility of change in hostnames present in all Connections made previously. 

Please suggest how to carry out such changes on a bulk level without having to create all connections (and hence jobs and activities on a bulk level).

Solution:

Because of the migration, yes you will need to update the connection strings on the .ini files. You can use SED with unix and power shell to update the .ini files.

 

https://www.gnu.org/software/sed/manual/sed.html

 

You can also use the attributes of the sql job with the db change

 

https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#AWA/Objects/obj_job_Attributes_SQL.htm

 

https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#AE_AWA_Source/Administration/uczadp.htm%3FTocPath%3DAdministration%2520Guide%7CAdministering%2520the%2520Automation%2520Engine%7CUtilities%7CAE%2520DB%2520Change%7C_____0

Outcomes