Change DOMAIN NAME on Oracle Apps (11.5.10.2)

I have changed the domain name ies.apps.com to ies.oracle.com as follows

Step 1

Enter in to “vi /etc/hosts” then change the host name as u want

e.g.: (ies.apps.com) to (ies.oracle.com)

Enter to “vi /etc/sysconfig/network” then change to the new host name

e.g.: (ies.apps.com) to (ies.oracle.com)

Then run $ service network restart

Then reboot the computer

NOTE: Ensure that backup must be taken of .xml file of both DB Tier and Apps Tier…

Step 2

Go to DB Tier…..

“$ vi /v01/oracle/visdb/appsutil/VIS_ies.xml”

Values of following parameters you have to change:

Change the new values to “ies.oracle.com” or as u want

1. global_database_name oa_var="s_global_database_name"
2. domain oa_var="s_domainname"

Step 3

Go to Apps Tier….

“$ vi /v01/oracle/visappl/admin/VIS_ies.xml”

Values of following parameters you have to change:

1. domain oa_var="s_dbdomain"
2. domain oa_var="s_admdomain"
3. domain oa_var="s_cpdomain"
4. domain oa_var="s_wfdomain"
5. domain oa_var="s_smtpdomainname"
6. domain oa_var="s_formsdomain"
7. chronosURL oa_var="s_chronosURL"
8. domain oa_var="s_metdomain"
9. domain oa_var="s_mwadomain"
10. discoinstancename oa_var="s_discoinstance"
11. disco_machine oa_var="s_disco_machine"
12. webentrydomain oa_var="s_webentrydomain"
13. proxybypassdomain oa_var="s_proxybypassdomain"
14. apps_portal_url oa_var="s_apps_portal_url"
15. sysadminmail oa_var="s_sysadmin_mail" osd="unix"
16. cookiedomain oa_var="s_cookie_domain"
17. login_page oa_var="s_login_page"
18. jdbc_url oa_var="s_apps_jdbc_connect_descriptor"
19. ohs_serveradmin oa_var="s_ohs_serveradmin"
20. domain oa_var="s_webcache_domain"
21. domain oa_var="s_domainname"
22. FORMS60_MAPPING oa_var="s_f60map"

Step 4

Then manually login to apps/apps@vis

Then manually you have to update the following table in database:

1. HOME_URL in ICX_PARAMETERS

Then login to /sys as sysdba

Then manually you have to update the following table in database:

2. GLOBAL_NAME in GLOBAL_NAME

Then exit from sqlplus….

Step 5

Then go to “/v01/oracle/visdb/9.2.0/network/admin”

Then change the all old host name (apps) to new host name (oracle) of the following scripts:

$ vi listner.ora

$ vi tnsname.ora

$ vi sqlnet.ora

Step 6

Run Auto Config on DB Tier…

“/v01/oracle/visdb/9.2.0/appsutil/scripts/VIS_ies/”

Run ./adautocfg.sh app/apps

Run Auto Config on Apps Tier…

“$ /v01/oracle/viscomm/admin/scripts/VIS_ies/”

Run $ ./adautocfg.sh app/apps