Change hostname for EBS 12.2

EBS 12.2 environment running on two servers

Database server and application server

Run preclone on both database tier and application tier

Stop the both services

Database Server :

Hostname : dbs-bah-xxx-yyy.zzzzz.com
Target : dbs-leb-xxx-yyy.zzzzz.com

[root@dbs-bah-xxx-yyy ~]# hostnamectl status
Static hostname: dbs-bah-xxx-yyy.zzzzz.com
Icon name: computer-vm
Chassis: vm
Machine ID: bbb7386b86c44808b6ee2e4b9be95357
Boot ID: ee32a1c8afdd4bd4a935eff51b9a836c
Virtualization: vmware
Operating System: Red Hat Enterprise Linux Server 7.6 (Maipo)
CPE OS Name: cpe:/o:redhat:enterprise_linux:7.6:GA:server
Kernel: Linux 3.10.0-957.el7.x86_64
Architecture: x86-64
[root@dbs-bah-xxx-yyy ~]# vi /etc/hosts
[root@dbs-bah-xxx-yyy ~]# hostnamectl set-hostname dbs-leb-xxx-yyy.zzzzz.com
[root@dbs-bah-xxx-yyy ~]# hostnamectl status
Static hostname: dbs-leb-xxx-yyy.zzzzz.com
Icon name: computer-vm
Chassis: vm
Machine ID: bbb7386b86c44808b6ee2e4b9be95357
Boot ID: ee32a1c8afdd4bd4a935eff51b9a836c
Virtualization: vmware
Operating System: Red Hat Enterprise Linux Server 7.6 (Maipo)
CPE OS Name: cpe:/o:redhat:enterprise_linux:7.6:GA:server
Kernel: Linux 3.10.0-957.el7.x86_64
Architecture: x86-64

Startup the database:

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address ‘(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbs-bah-xxx-yyy.zzzzz.com)(PORT=1586)))’
SQL> SQL> exit

[orauat@dbs-leb-xxx-yyy admin]$ mkdir -p LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy admin]$ cd LEBUAT_dbs-leb-xxx-yyy/
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ pwd
/u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ cd ..
[orauat@dbs-leb-xxx-yyy admin]$ cd LEBUAT_dbs-bah-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ cp -r * /u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy

Replace with new hostname
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-bah-xxx-yyy]$ cd /u01/app/oracle/db/tech_st/12c/network/admin/LEBUAT_dbs-leb-xxx-yyy
[orauat@dbs-leb-xxx-yyy LEBUAT_dbs-leb-xxx-yyy]$ ls
listener_ifile.ora listener.ora sqlnet_ifile.ora sqlnet.ora tnsnames.ora

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4294967296 bytes
Fixed Size 2932632 bytes
Variable Size 2667577448 bytes
Database Buffers 1610612736 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.

[orauat@dbs-leb-xxx-yyy ~]$ lsnrctl start LEBUAT

perl adbldxml.pl

perl adconfig.pl

Changed hostname for Application Server:

hostname : ebs-bah-xxx-yyy.zzzzz.com
target hostname : ebs-leb-xxx-yyy.zzzzz.com

removed the directory of fs2, fs1/FMW_Home, fs1/inst and fs_ne

[appluat@ebs-leb-xxx-yyy bin]$ perl adcfgclone.pl appsTier

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.60

***********************************************************
In AD-TXK Delta 7, we recommend you clone the run and patch
file systems in a single operation using the ‘dualfs’ option.
Separate cloning of the run and patch file systems will be deprecated
************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone…

Log file located at /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/CloneContext_1203103249.log

Target System File Edition type [run] :

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [ebs-leb-xxx-yyy] :

Target System Database SID : LEBUAT

Target System Database Server Node [ebs-leb-xxx-yyy] : dbs-leb-xxx-yyy

Target System Database zzzzz Name [zzzzz.com] :

Target System Base Directory : /u01/LEBUAT

Target System Base Directory set to /u01/LEBUAT

Target System Current File System Base set to /u01/LEBUAT/fs1

Target System Other File System Base set to /u01/LEBUAT/fs2

Target System Fusion Middleware Home set to /u01/LEBUAT/fs1/FMW_Home

Target System Web Oracle Home set to /u01/LEBUAT/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/LEBUAT/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/LEBUAT/fs1/EBSapps/comn

Target System Instance Home Directory [/u01/LEBUAT] :

Target System Instance Top set to /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy

Do you want to preserve the Display [0.0] (y/n) : n

Target System Display [ebs-leb-xxx-yyy:0.0] :

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 the target system to have the same port values as the source system (y/n) [y] ? :
Validating if the source port numbers are available on the target system..
Complete port information available at /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/out/LEBUAT_ebs-leb-xxx-yyy/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /u01/LEBUAT/db/tech_st/11.2.0/appsutil/outbound/LEBUAT_ebsprodleb
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
The new APPL_TOP context file has been created :
/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml
Check Clone Context logfile /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/CloneContext_1203103249.log for details.

Running Rapid Clone with command:

Running:
perl /u01/LEBUAT/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/LEBUAT/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/LEBUAT/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs1/EBSapps/comn/clone -log /u01/LEBUAT/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Tue Dec 3 10:33:28 2019

/u01/LEBUAT/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/java:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/LEBUAT/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/LEBUAT/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/LEBUAT/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/log/clone/ApplyAppsTier_12031033.log
/ 0% completed

start the service

[appluat@ebs-leb-xxx-yyy scripts]$ ./adstrtal.sh apps/password

[appluat@ebs-leb-xxx-yyy scripts]$ perl adpreclone.pl appsTier

[appluat@ebs-leb-xxx-yyy scripts]$ ./adstpall.sh apps/password

copy the files to fs2

[appluat@ebs-leb-xxx-yyy fs1]$ cp -r EBSapps/ /u01/LEBUAT/fs2/

[appluat@ebs-leb-xxx-yyy bin]$ perl adcfgclone.pl appsTier

Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.60

***********************************************************
In AD-TXK Delta 7, we recommend you clone the run and patch
file systems in a single operation using the ‘dualfs’ option.
Separate cloning of the run and patch file systems will be deprecated
************************************************************

Enter the APPS password :

Enter the Weblogic AdminServer password :

Do you want to add a node (yes/no) [no] :

Running: Context clone…

Log file located at /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/CloneContext_1203135510.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml

Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /u01/LEBUAT/fs2/FMW_Home

Target System Web Oracle Home set to /u01/LEBUAT/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/LEBUAT/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/LEBUAT/fs2/EBSapps/comn

Target System Instance Top set to /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy

Target System Port Pool [0-99] : 66

Checking the port pool 66
done: Port Pool 66 is free
Report file located at /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml
Check Clone Context logfile /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/CloneContext_1203135510.log for details.

Running Rapid Clone with command:

Running:
perl /u01/LEBUAT/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/LEBUAT/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/LEBUAT/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs2/EBSapps/comn/clone -log /u01/LEBUAT/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Tue Dec 3 13:56:28 2019

/u01/LEBUAT/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/java:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/LEBUAT/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/LEBUAT/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/LEBUAT/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/appl/admin/LEBUAT_ebs-leb-xxx-yyy.xml -stage /u01/LEBUAT/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/LEBUAT/fs2/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/log/clone/ApplyAppsTier_12031356.log
| 0% completed

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

[appluat@ebs-leb-xxx-yyy LEBUAT]$ . ./EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/LEBUAT/fs1/EBSapps/appl
PATCH File System : /u01/LEBUAT/fs2/EBSapps/appl
Non-Editioned File System : /u01/LEBUAT/fs_ne

DB Host: dbs-leb-xxx-yyy.zzzzz.com Service/SID: LEBUAT

Sourcing the RUN File System …

[appluat@ebs-leb-xxx-yyy LEBUAT]$ cd $ADMIN_SCRIPTS_HOME
[appluat@ebs-leb-xxx-yyy scripts]$ pwd
/u01/LEBUAT/fs1/inst/apps/LEBUAT_ebs-leb-xxx-yyy/admin/scripts
[appluat@ebs-leb-xxx-yyy scripts]$ ./adstrtal.sh apps/password

You are running adstrtal.sh version 120.24.12020000.11

Enter the WebLogic Server password:

Service started with new changed hostname.