Change Host Name or Port Num in R12 EBS

We ve choices to changing the host name in Oracle application R12.one of the choices is to change the required values in context files and run the autoconfig on appsTIer and dbTier. The following information gives detailed information how to change the host name and port no in E-business suite.

1.Deregister the current database server (Required) and Apps Tier

Db Side:perl <RDBMS ORACLE_HOME>/appsutil/bin/adgentns.pl appspass=<APPSpwd> \ contextfile=<CONTEXT> -removeserver

Apps Side: perl $AD_TOP/bin/adgentns.plappspass=<APPSpwd> \ contextfile=<CONTEXT> -removeserver

2. Update the AutoConfig Context files (conditional)
Take the Backup of the two  contextfiles (.xml) of Db and apps And Change values as follows.

Change the values “Data Server Host” and  “Database Port” in the Applications Tier Context file on all APPL_TOP nodes.

You should also reset the value for “s_apps_jdbc_connect_descriptor” to an empty value (” “) on all APPL_TOP nodes
3. Shutdown the Applications Tier Services

 sh adstpall.sh apps/apps pw

4. Run AutoConfig on the database tier node using the following syntax

cd <RDBMS ORACLE_HOME>/appsutil/bin/./adconfig.sh contextfile=<RDBMS ORACLE_HOME>/appsutil/<SID>_<new_hostname>.xml

5. Run AutoConfig on the Applications tier node using the following syntax

cd  $ADMIN_SCRIPTS_HOME./adautocfg.sh appspass=<appspasswd>

6.Shutdown the DB TNS listener using the script under the following location (old configuration script) and Shutdown the database.

cd <RDBMS ORACLE_HOME>/appsutil/scripts/<old SID_hostname>/addlnctl.sh stop {listener}SQL>shutdown immediate

7. Changes need to be done from OS side  if u changed the Host name.(optional). 

 Once we installed the Linux OS,For changing the host name or domain name we ve to change the some configuration files.Now let us see the those files in the bellow information.

Step1: Change the New Values in  the Host file
[root@erp ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain localhost
192.168.0.1        erp.myappsdba.com  erp
[root@erp ~]#

Step2: Change the New Values in  the network file
[root@erp ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=erp.myappsdba.com
GATEWAY=192.168.0.3

Step3: Change the New Values in  the sysctl.conf and resolv.conf files
[root@erp ~]## cat /etc/sysctl.conf
kernel.hostname=erp.myappsdba.com
kernel.domainname=myappsdba.com

[root@erp etc]# cat /etc/resolv.conf
search myappsdba.com
nameserver 192.168.0.7
nameserver 192.168.0.2
option attemts : 5
option timeout :15
[root@erp etc]#

Step4:Ping the Host Name or Changed IP Address.
[root@erp etc]# ping myappsdba.com
PING myappsdba.com (192.168.0.1) 56(84) bytes of data.
64 bytes from fortedc.myappsdba.com (192.168.0.1): icmp_seq=1 ttl=128 time=1.06 ms

Step5:Restart the Network or Reboot the system for effecting the changes
[root@erp ~]# init 6     or

[root@erp ~]# service network restart 

8.Start the Database and Application Services

a) Source your new environment file, and start the Database

<RDBMS ORACLE_HOME>/appsutil/scripts/<new SID_hostname>/addbctl.sh start

b) Start the DB TNS Listener

 <RDBMS ORACLE_HOME>/appsutil/scripts/<new SID_hostname>/addlnctl.sh start {listener}

c) Start the Applications Tier Services

sh adstrtall.sh apps/appspw