Problem Description: R12: How to change the hostname/IP address of Apps Database Tier using AutoConfig




Solution:





Sometimes we have a need of changing the hostname/domainname/port on database tier. Oracle recommends the following set of action rather than simply changing the context-file and running autoconfig.




1. Deregister the current database server


perl /appsutil/bin/adgentns.pl appspass=APPSpwd \
contextfile=$CONTEXT -removeserver
2. Update the AutoConfig Context files


DB Tier: Create a new context file using the following syntax :


cd $ORACLE_HOME/appsutil/bin

perl adclonectx.pl contextfile=$CONTEXT_FILE.

3. Shutdown the Applications Tier Services

4. Reseed the Net Services Topology Model

Run AutoConfig on the Database Tier


./adconfig.sh contextfile=$ORACLE_HOME/appsutil/$SID_new_hostname>.xml
Run AutoConfig on the Applications Tier(s)


./adautocfg.sh appspass=appspasswd



5. Shutdown the Database Listener

6. Shutdown the Database

7. Change the machine hostname

edit the /etc/hosts file to update the new hostname/domainname.




8. Start the Database

9. Start the DB TNS Listener

10. Start the Applications Tier Services










References:




Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'