DEV Community: Jose Carlos Moreira (Deco)

🚀 Application Tier Platform Migration Oracle EBS R12.2.x

Jose Carlos Moreira (Deco) — Mon, 05 May 2025 18:54:09 +0000

This guide details the full process for migrating the Application Tier (middle tier) of Oracle EBS R12.2.x to a new Unix/Linux platform while retaining the Database Tier unchanged.

🎯 Objective
To enable the relocation of an Oracle EBS Application Tier to a different platform (Unix/Linux), maintaining:

Current patch levels
Customizations
Database untouched
This strategy simplifies migration and ensures stability by retaining technology stack consistency.

✅ Requirements & Restrictions
Only valid for Oracle EBS 12.2.3 or higher
Migration covers Application Tier only (Database remains)
Single-node target required initially (more nodes can be added post-migration)
Only Unix/Linux platforms supported as target
Source must be at AD-TXK Delta 7 or higher
FMW version 11.1.1.9 is mandatory

🛠️ Source System Preparation

Step-by-step:
Verify Active File System

echo $FILE_EDITION   # should return "run"

Apply Required Patches

adop phase=apply patches=21255247,22391154 apply_mode=hotpatch 
adop phase=apply patches=22259926 apply_mode=hotpatch

Run AutoConfig

sh $AD_TOP/bin/adconfig.sh contextfile=<RUN_CONTEXT_FILE>

Run adpreclone

cd $INST_TOP/admin/scripts perl adpreclone.pl appsTier

Update Snapshot via AD Administration

Menu: 
Maintain Applications Files
   → Maintain Snapshot Information 
       → Update Current View Snapshot 
            → Update Complete APPL_TOP

Shut Down Application Tier Services

adstpall.sh apps/apps

Capture Tech Stack Patch Inventory

perl $FND_TOP/patch/115/bin/TXKScript.pl \ 
-script=$FND_TOP/patch/115/bin/txkInventory.pl \ 
-txktop=$APPLTMP -contextfile=$CONTEXT_FILE \ 
-appspass=<apps password> -outfile=$APPLTMP/Report_Inventory.html

🔄 Migration Execution (Target System)

8.1 Generate & Upload Customization Manifest

cd $AD_TOP/bin
perl adgenpsf.pl
Upload adgenpsf.txt at: https://updates.oracle.com/PlatformMigration

8.2 Copy Files from Source (run and patch file systems)
Copy the following:

* $EBSapps/appl

* $COMMON_TOP/clone

* $COMMON_TOP/java

8.3 Install Prerequisites
Install on Target system:

* JDK 1.6+ (<COMMON_TOP>/util/jdk32 or jdk)

* InfoZip tools: zip ≥ 2.30, unzip ≥ 5.52

8.4 Clone Application Context
Generate run context file:

cd $COMMON_TOP/clone/bin
perl adclonectx.pl migrate java=<JDK_TOP> pairsfile=<RUN_PAIRSFILE> contextfile=<SOURCE_CONTEXT_FILE> stage=<STAGE_DIR>
Generate patch context file:

perl adclonectx.pl java=<JDK_TOP> pairsfile=<PATCH_PAIRSFILE> contextfile=<RUN_CONTEXT_FILE> stage=<STAGE_DIR> outfile=<PATCH_CONTEXT_FILE>

Update values:

s_jdktop, s_fmw_jdktop, s_apps_jdbc_connect_descriptor

8.5 Install Tech Stack Using Rapid Install
Run buildStage:

cd /u01/StageR122/startCD/Disk1/rapidwiz/bin
./buildStage.sh
Run Rapid Install (twice):

cd /u01/StageR122/startCD/Disk1/rapidwiz
./rapidwiz -techstack   # FMW install
./rapidwiz -techstack   # 10.1.2 ORACLE_HOME install

8.6 Configure Target System
Run AutoConfig Setup Phase:


sh $AD_TOP/bin/adconfig.sh contextfile=<RUN_CONTEXT_FILE> run=INSTE8_SETUP
Run Platform Migration Tasks:


cd $AD_TOP/patch/115/bin
perl txkPlatformMigrationTasks.pl <RUN_CONTEXT_FILE>

8.7 Apply Custom Migration Patch

Unzip patch and override adpatch:
unzip adpatchR12_AD_C.zip cp adpatch $AD_TOP/bin/

. Apply patch:

adop phase=apply apply_mode=bootstrap preinstall=yes patchtop=$PATCH_TOP/<patch_number>

8.8 Cleanup and AutoConfig Execution
Run cleanup:

cd $INST_TOP/admin/install
sh ./afcpclean.sh apps apps
Run AutoConfig on DB tier:

sh $RDBMS_ORACLE_HOME/appsutil/scripts//adautocfg.sh
Re-run AutoConfig on Apps:

sh $AD_TOP/bin/adconfig.sh contextfile=

8.9 Regenerate and Relink
Generate Signature and Compile:


cd $AD_TOP/bin
sh ./adgensgn.sh apps/apps
adadmin  # Compile forms, reports, messages, JARs, relink

8.10 Bug Fix (if needed — Bug 21212865)

begin
  AD_ZD_FIXER.FIX_ADOP_REPO_TABLES(<SRC_APPLTOP_ID>, <SRC_NODENAME>, <TGT_APPLTOP_ID>, <TGT_NODENAME>);
end;

8.11 Sync Patch FS with Run FS

adop phase=fs_clone

8.12 Start All Services

cd $INST_TOP/admin/scripts
./adstrtal.sh apps/apps

🧾 Post-Migration Tasks Apply third-party library patches:

iLog: Patch 10135606
RogueWave: Patch 10135608
SHT: Patch 10135610
Recompile custom code and extensions
Update:
Printer settings
Workflow URLs (WF_*, FND_*)
APPLCSF variable
SESSION_COOKIE_DOMAIN in ICX_PARAMETERS

📚 Additional Documentation
[Doc ID 1383621.1] — Cloning R12.2 with Rapid Clone
[Doc ID 1320300.1] — EBS 12.2 Release Notes
[Doc ID 1594274.1] — EBS Technology Codelevel Checker (ETCC)

📚 Thank you for reading!
I’m passionate about sharing real-world experiences in Oracle General, Oracle Cloud, Database Optimization, IT Innovation, and Enterprise Solutions.

🚀 Follow me here to stay updated with new articles, best practices, and actionable insights. Let’s grow together in the world of technology!

🚀 Oracle E-Business Suite R12.2: Adding and Removing Application Tier Nodes

Jose Carlos Moreira (Deco) — Fri, 02 May 2025 16:26:32 +0000

🧩 Oracle E-Business Suite R12.2

📌 Overview

Oracle E-Business Suite (EBS) Release 12.2 introduces a dual file system architecture with online patching, enabling high availability, modular maintenance, and horizontal scalability. Multi-node configurations help enterprises improve application responsiveness, ensure business continuity, and support failover strategies. The add-node and remove-node operations must be executed with strict adherence to Oracle standards to ensure service integrity and lifecycle manageability.
Key benefits include:
Consistent AutoConfig and context-driven configuration management
Shared application tier support via NFS or clustered storage
Dual file system support for run/patch file systems
Centralized and distributed load balancing
Full service enablement (OHS, WebLogic, NodeManager, Forms, Concurrent Managers)
Oracle officially documents this process via My Oracle Support (MOS) and in Rapid Clone tools.

🔧 Step-by-Step: Adding a Secondary Node to R12.2

🔹 Step 1: Prepare files from Primary Application Tier to send to another new server node.

# Start Admin Server on RUN file system
cd $ADMIN_SCRIPTS_HOME
./adadminsrvctl.sh start


# Start Admin Server on PATCH file system
cd $ADMIN_SCRIPTS_HOME
./adadminsrvctl.sh start forcepatchfs


# Execute Preclone on Primary Node (appsTier)
cd $ADMIN_SCRIPTS_HOME
perl adpreclone.pl appsTier

*🔹 Step 2: Create Tar Archive and Transfer
*

# Navigate to FS1 and compress application tier
cd /u01/appltier/R12PRD/fs1/

nohup tar -czvf EBSapps$(date +%m%d%y).tar.gz EBSapps &

# Secure copy tar file generated to new node
scp EBSapps$(date +%m%d%y).tar.gz user@newnode:/u01/appltier/R12PRD/fs1/

*🔹 Step 3: Unpack and Prepare the New Node
*

# Uncompress the application tier structure
cd /u01/appltier/R12PRD/fs1/

nohup tar -xzvf EBSapps$(date +%m%d%y).tar.gz &
Note: Ensure shared mount points, user groups, and directory structures are aligned across nodes. Examples:

/usr/tmp
/u01/oracle/ebshml/appltier/tmp/shared
/fs_shared/APPLPTMP

🔹 Step 4: Prepare Pairs File (Node-Specific)

Example values for /u01/appltier/R12PRD/pairsfiles/pairsfile.txt:

[Base]
s_base=/u01/appltier/R12PRD
s_current_base=/u01/appltier/R12PRD/fs1
s_other_base=/u01/appltier/R12PRD/fs2
s_ne_base=/u01/appltier/R12PRD/fs_ne

[General]
s_applptmp=/u01/appltier/R12PRD/tmp/shared
s_appsgroup=oinstall
s_appsuser=applprd
s_dbuser=oracle
s_dbgroup=dba
s_dbdomain=your_host_domain.com
s_at=/u01/appltier/R12PRD/fs1/EBSapps/appl
s_com=/u01/appltier/R12PRD/fs1/EBSapps/comn
s_tools_oh=/u01/appltier/R12PRD/fs1/EBSapps/10.1.2
s_weboh_oh=/u01/appltier/R12PRD/fs1/FMW_Home/webtier
s_fmw_home=/u01/appltier/R12PRD/fs1/FMW_Home
s_dbGlnam=R12PRD
s_dbSid=R12PRD
s_dbhost=scprd-scan
s_clonestage=/u01/appltier/R12PRD/fs1/EBSapps/comn/clone
s_dbport=1521
s_options_symlinks=Options -FollowSymLinks
s_proxyhost=
s_proxybypassdomain=your_host_domain.com
s_proxyport=
s_nonproxyhosts=
s_javamailer_imapdomainname=NoImapDomain
s_javamailer_imaphost=NoImapHost
s_javamailer_reply_to=NoReplyTo
s_javamailer_outbound_user=changeOnJavaMailerInstall
s_smtphost=ebsprdr12
s_smtpdomainname=your_host_domain.com
s_file_edition_type=run
s_port_pool=0
s_admhost=ebsprdr12
s_atName=ebsprdr12
s_shared_file_system=true
patch_s_port_pool=1

[Web Entry Point Configuration]
s_webentryurlprotocol=http
s_webentryhost=ebsprdr12
s_webentrydomain=your_host_domain.com
s_active_webport=8000
s_endUserMonitoringURL=http://ebsprdr12.your_host_domain.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
s_external_url=http://ebsprdr12.your_host_domain.com:8000
s_login_page=http://ebsprdr12.your_host_domain.com:8000/OA_HTML/AppsLocalLogin.jsp

[Instance Specific]
s_temp=/u01/appltier/R12PRD/fs1/inst/apps/R12PRD_ebsprdweb/temp
s_contextname=R12PRD_ebsprdweb
s_hostname=ebsprdweb
s_domainname=your_host_domain.com
s_cphost=ebsprdweb
s_webhost=ebsprdweb
s_config_home=/u01/appltier/R12PRD/fs1/inst/apps/R12PRD_ebsprdweb
s_inst_base=/u01/appltier/R12PRD
s_display=ebsprdweb:0.0
s_forms-c4ws_display=ebsprdweb:0.0
s_ohs_instance=EBS_web_R12PRD_OHS2
s_webport=8000
s_http_listen_parameter=8000
s_https_listen_parameter=4443

[Services To be Enabled on the Secondary Application Tier Node]
s_web_applications_status=enabled
s_web_entry_status=enabled
s_apcstatus=enabled
s_root_status=enabled
s_batch_status=enabled
s_other_service_group_status=enabled
s_adminserverstatus=disabled
s_web_admin_status=disabled

*🔹 Step 5: Clone Secondary Node
*

cd /u01/appltier/R12PRD/fs1/EBSapps/comn/clone/bin

perl adcfgclone.pl component=appsTier \
  pairsfile=/u01/appltier/R12PRD/pairsfiles/pairsfile.txt \
  addnode=yes dualfs=yes
This will instantiate the context, register WebLogic managed servers, and start relevant services.

*🗑️ Removing an Application Tier Node (R12.2)
*
*🔹 Step 1: Execute adProvisionEBS
*

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl \
  ebs-delete-node \
  -contextfile=$CONTEXT_FILE \
  -hostname=rnnhml01ebs03 \
  -logfile=delete.log

Optionally, to delete a specific managed server:

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl \
  ebs-delete-managedserver \
  -contextfile=$CONTEXT_FILE \
  -managedsrvname=oacore_server1 \
  -logfile=/tmp/oacore_server1_delete.txt

*🧾 Best Practices & Considerations
*

Always take a backup before cloning or removing nodes.
Validate context files with adchkcfg.sh post-clone.
Run AutoConfig on all nodes after changes.
Sync all tier clocks via NTP.
Monitor via EBS Cloud Control or custom dashboards.

📚 Thank you for reading!
I’m passionate about sharing real-world experiences in Oracle General, Oracle Cloud, Database Optimization, IT Innovation, and Enterprise Solutions.