How to change hostname for E-Business Suite Release 12 on single node (Doc ID 1277556.1)

How to change hostname for E-Business Suite Release 12 on single node (Doc ID 1277556.1) To Bottom Modified:13-Feb-2014Type:HOWTO In this Document Goal   Solution APPLIES TO: Oracle Applications Manager - Version 12.0.6 to 12.1.3 [Release 12 to 12.1] Information in this document applies to any platform. ***Checked for relevance on 11-Jan-2014***  GOAL Oracle E-Business Suite is dependent to hostname and domain. Assume that E-Business Suite has just one node so that all Tiers and Servers reside on this node. Please refer to following to modify the hostname on EBS R12. For Windows EBS server users,  that have to open a command window and source the mks Enviroenment to be able to execute below Unix commands.   SOLUTION 1. DB Tier: Deregister the current database server As the database hostname and domain will be changed, the current database server node needs to be de-registered.   select NAME, SERVER_TYPE   from FND_APP_SERVERS, FND_NODES   where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID   and SERVER_TYPE='DB'   and FND_NODES.NODE_NAME='old_hostname';   NAME SERVER_TYPE   --------------- -----------   oldhost_<SID>_DB DB   Executing following commands to deregister the current database server:   cd $ORACLE_HOME/appsutil   perl ./bin/adgentns.pl appspass=<APPSpwd> contextfile=./<SID>_oldhost.xml -removeserver   select NAME, SERVER_TYPE   from FND_APP_SERVERS, FND_NODES   where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID   and SERVER_TYPE='DB'   and FND_NODES.NODE_NAME='old_hostname';   no rows selected. 2. DB Tier: Create a new Context file You can create the new context file using whichever of the following methods:   a. Manual Method:   cd $ORACLE_HOME/appsutil   cp <SID>_oldhost.xml <SID>_newhost.xml   Edit <SID>_newhost.xml manually:   Replace all oldhost with newhost b. Script Method:(The command below will create a new Context file of the format <SID>_newhost.xml in the current working directory.)   cd $ORACLE_HOME/appsutil   perl ./clone/bin/adclonectx.pl contextfile=./<SID>_oldhost.xml   ************************************************************************************************************************** Enter the APPS password :  <Password>  Log file located at <DB - $ORACLE_HOME>/appsutil/CloneContext_1223165155.log   Provide the values required for creation of the new Database Context file.   Target System Hostname (virtual or normal) [nascapp6] :   It is recommended that your inputs are validated by the program.   However you might choose not to validate them under following circumstances:   -If cloning a context on source system for a remote system.   -If cloning a context on a machine where the ports are taken and   you do not want to shutdown the services at this point.   -If cloning a context but the database it needs to connect is not available.   Do you want the inputs to be validated (y/n) [n] ? :   Target Instance is RAC (y/n) [n] :   Target System Database SID : <SID>   Target System Base Directory : <EBS Base Directory>  Oracle OS User [oravis] :   Oracle OS Group [dba] :   Target System utl_file_dir Directory List :/usr/tmp   Number of DATA_TOP's on the Target System [4] : 1   Target System DATA_TOP Directory 1 : /d01/oracle/PROD/db/apps_st/data <------- input the path of your data files   Target System RDBMS ORACLE_HOME Directory [/d01/oracle/PROD/db/tech_st/11.1.0] :   Do you want to preserve the Display [null] (y/n) ? : n   Target System Display [newhost:0.0] :   Do you want the the target system to have the same port values as the source system (y/n) [y]?:   Complete port information available at <DB - $ORACLE_HOME>/appsutil/out/<SID>_nascapp6/portpool.lst   New context path and file name [<DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml] :   Creating the new Database Context file from :   <DB - $ORACLE_HOME>/appsutil/template/adxdbctx.tmp   The new database context file has been created :   <DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml   Log file located at <DB - $ORACLE_HOME>/appsutil/CloneContext_1223170424.log   contextfile=<DB - $ORACLE_HOME>/appsutil/PROD_nascapp6.xml   Check Clone Context logfile <DB - $ORACLE_HOME>/appsutil/CloneContext_1223170424.log for details.   ************************************************************************************************************************** 3. APPS Tier: Deregister the current Applications server As the Applications hostname and domain will be changed, the current Applications server node needs to be de-registered.   select NAME, SERVER_TYPE   from FND_APP_SERVERS, FND_NODES   where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID   and SERVER_TYPE='APPS'   and FND_NODES.NODE_NAME='old_hostname';   NAME SERVER_TYP   ----------------- ----------   oldhost_<SID>_APPS APPS   Executing following commands to deregister the current Applications server:   cd $APPL_TOP/admin   perl $AD_TOP/bin/adgentns.pl appspass=<APPSpwd> contextfile=./<SID>_oldhost.xml -removeserver   select NAME, SERVER_TYPE   from FND_APP_SERVERS, FND_NODES   where FND_APP_SERVERS.NODE_ID = FND_NODES.NODE_ID   and SERVER_TYPE='APPS'   and FND_NODES.NODE_NAME='old_hostname';   no rows selected.  4. APPS Tier: Create a new Context file You can create the new context file using whichever of the following methods:   a. Manual Method:   cd $APPL_TOP/admin   cp <SID>_oldhost.xml <SID>_newhost.xml   Edit <SID>_newhost.xml manually:   Replace all oldhost with newhost b. Script Method:(The command below will create a new Context file of <SID>_newhost.xml in new <SID>_newhost directory.)   cd $INST_TOP/appl/admin   perl $COMMON_TOP/clone/bin/adclonectx.pl contextfile=./<SID>_oldhost.xml   ************************************************************************************************************************** Enter the APPS password : apps   Log file located at $INST_TOP/appl/admin/CloneContext_1223173053.log   Provide the values required for creation of the new APPL_TOP Context file.   Target System Hostname (virtual or normal) [nascapp6] :   It is recommended that your inputs are validated by the program.   However you might choose not to validate them under following circumstances:   -If cloning a context on source system for a remote system.   -If cloning a context on a machine where the ports are taken and   you do not want to shutdown the services at this point.   -If cloning a context but the database it needs to connect is not available.   Do you want the inputs to be validated (y/n) [n] ? :   Target System Database SID : <SID>   Target System Database Server Node [nascapp6] :   Target System Base Directory : <EBS Base Directory>  Target System Tools ORACLE_HOME Directory [<10.1.2 $ORACLE_HOME>] :   Target System Web ORACLE_HOME Directory [<10.1.3 $ORACLE_HOME>] :   Target System APPL_TOP Directory [<$APPL_TOP>] :   Target System COMMON_TOP Directory [<$COMMON_TOP>] :   Target System Instance Home Directory [<$INST_TOP>] :   Username for the Applications File System Owner [applvis] :   Group for the Applications File System Owner [dba] :   Target System Root Service [enabled] :   Target System Web Entry Point Services [enabled] :   Target System Web Application Services [enabled] :   Target System Batch Processing Services [enabled] :   Target System Other Services [disabled] :   Do you want to preserve the Display [oldhost:0.0] (y/n) ? : newhost:0.0   Target System Display [newhost:0.0] :   New context path and file name [$INST_TOP/appl/admin/<SID>_newhost.xml] :   ************************************************************************************************************************** 5. APPS Tier: Shutdown the Application Tier Services cd $INST_TOP/admin/scripts   ./adstpall.sh apps/<appspasswd>   6. Change the server machine hostname. Please contact your IT administrator to change the machine hostname. 7. DB Tier: Reseed the Net Services Topology Model cd $ORACLE_HOME/appsutil   ./bin/adconfig.sh contextfile=./<SID>_newhost.xml   8. APPS Tier: Reseed the Net Services Topology Model The Net Services Topology Model is automatically updated by running AutoConfig.   $AD_TOP/bin/adconfig.sh contextfile= $INST_TOP/../<SID>_newhost//appl/admin/<SID>_newhost.xml appspass=<appspasswd>   9. DB Tier: Shutdown the database and listener $ORACLE_HOME/appsutil/scripts/<SID>_oldhost/addbctl.sh stop   $ORACLE_HOME/appsutil/scripts/<SID>_oldhost/addlnctl.sh stop <SID>   10. DB Tier: Start the listener and database $ORACLE_HOME/appsutil/scripts/<SID>_newhost/addlnctl.sh start <SID>   $ORACLE_HOME/appsutil/scripts/<SID>_newhost/addbctl.sh start   11. APPS Tier: Start the Application Tier Services $INST_TOP/admin/scripts/<SID>_newhost/adstrtal.sh apps/<appspasswd>