R12: How to change the hostname/IP address of an Database Tier using AutoConfig

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

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'

Get Oracle Certifications for all Exams
Free Online Exams.com