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;
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/
