DB Host name change
Article ID: 235469
Updated On:
Products
Issue/Introduction
The DB hostname will be changing. Other than the tnsnames.ora file and the below line from config.instance:
############## User Comments - End. Keyword: EventServer_1 #################
EventServer_1=<database name>:aedbadmin,1521,old_hostname
Is there anywhere else where I would need to change the hostname?
Stopping/starting autosys is all that is needed after making the change?
Environment
Release : 12.0, 12.0.1
Component : Workload Automation AE
Platform: Unix
Resolution
You will need to stop the AutoSys processes first. In the config.<instance> file, you would need to change the below line
from:
EventServer_1=<database name>:aedbadmin,1521,old_hostname
to:
EventServer_1=<database name>:aedbadmin,1521,new_hostname
You will need to update the tnsnames.ora file to have the new hostname of the database machine
Then restart the AutoSys processes. Run chk_auto_up command to verify that a connection can be made to the database
Feedback
