CHANGE HOSTNAME OR IP-Address OR DOMAIN NAME ON APPS-TIER OR DB-TIER in R12

Autoconfig Frequently asked Question : 218089.1

For any queries related to below mentioned steps Question Number from 23 onwards will help you.

Steps to change hostname or domain name or port number of Database.

Doc-id : 338003.1

1. Login to DB-Tier as oracle user

2. start the database if not up and running.

3. De-register the current database server.

As the database hostname and/or port will be changed, the current database server node needs to be de-registered

$ perl adgentns.pl appspass=apps contextfile=$ORACLE_HOME/appsutil/Contextfilename.xml -removeserver

4. Take a backup of your context file Edit contextfile i.e SID_hostname.xml file $ORACLE_HOME/appsutil

Replace all old domain entries to newdomain/hostname use vi to edit for e.g changing hostname from abc.com to xyz.com using vi editor

esckey :%s/abc.com/xyz.com/g

Note : Before Running autoconfig Change Hostname or domain name in /etc/hosts and or relevant files.

5. Execute AutoConfig for dbTier

cd $ORACLE_HOME/appsutil/bin

./adconfig.sh contextfile=$ORACLE_HOME/appsutil/SID_hostname.xml

Steps to change hostname or domain name of Application Tier using Auto-config .

Doc-id: 341322.1

1. Login to Apps-Tier  as apps user

2. Stop application services.

3. De-register the current apps server

As the Applications hostname will be changed, the current Applications server node needs to be de-registered.

$ perl $AD_TOP/bin/adgentns.pl appspass=apps contextfile=$ INST_TOP/appl/admin/SID_hostname.xml

–removeserver

4. Take a backup of your context file Edit contextfile i.e SID_hostname.xml

Replace all old domain entries to newdomain/hostname use vi to edit for e.g changing hostname from abc.com to xyz.com using vi editor

esckey :%s/abc.com/xyz.com/g

5. Execute AutoConfig for appTier

cd $AD_TOP/bin

./adconfig.sh contextfile=$INST_TOP/appl/admin/SID_hostname.xml appspass=apps

Finishing Tasks

1. As oracle user, do the following:

$ sqlplus apps/apps
sql> update icx_parameters set session_cookie_domain=' newdomain.com';
sql> conn applsys/apps
sql> select profile_option_value from fnd_profile_option_values where profile_option_value
like '%oldhost%'; if not correct then update it accordinly with the correct one
sql> update fnd_profile_option_values set profile_option_value='newhost' where profile_option_value like '%oldhost%';
sql> exit;

Done. You can startup AppTier now and access E-Business Suite login page at http://newhost.newdomain.com:8000/