Oracle Apps DBA stuff: Application Tier Platform Migration with Oracle E-Business Suite Release 12

Application Tier Platform Migration with Oracle E-Business Suite Release 12 [ID 438086.1]

		Modified 23-FEB-2012 Type BULLETIN Status PUBLISHED

This document describes the process of migrating an Oracle application (middle) tier to any platform that is supported with Oracle E-Business Suite Release 12.x Rapid Install.
The content applies to all Release 12.x.x versions, such as 12.0, 12.0.4, and 12.1.x. Where applicable, 12.0.x releases will in general be referred to as Release 12.0, and 12.1.x releases as Release 12.1.
The most current version of this document can be obtained as My Oracle Support Knowledge Document 438086.1.
There is a change log at the end of this document.

Benefits

The process described provides a way to quickly and easily move an existing Oracle E-Business Suite application tier to a different platform, allowing you to utilize different hardware for the application tier.
The migration utility retains the exact Oracle E-Business Suite patch level, so that no APPL_TOP/Database synchronization is necessary; this also allows you to retain many customizations.
The Source System can remain up and running until the last step of the migration process.

Restrictions

This migration methodology requires Oracle E-Business Suite Release 12.0.4 or higher for all platforms except IBM:Linux on System z
This migration methodology requires Oracle E-Business Suite Release 12.1.3 or higher for IBM:Linux on System z platform(Source or Target)
This document applies to the application tier only. Refer to My Oracle Support Knowledge Document 454616.1 for instructions on database tier migration.
The instructions in this document are for migration to a target UNIX/Linux platform. At present, Windows is only supported as a source platform.

Terminology

Term	Meaning
Application tier	The Oracle tier that runs Concurrent Processing, Forms and Web Services. Sometimes called the middle tier.
Source System	Oracle E-Business Suite system being migrated.
Target System	Oracle E-Business Suite system being created as a copy of the Source System.
applmgr	Operating system account that owns the Oracle E-Business Suite file system (APPL_TOP and application tier technology stack)
Monospace Text	Represents command line text. Type this command exactly as shown.
[]	Text enclosed in brackets represents a variable. Substitute a value for the variable text. Do not type the angle brackets.

Section 1: Prerequisites: Must be completed prior to using the migration utility.
Section 2: Migration Tasks : Tasks to migrate an application tier to a new platform.
Section 3: Finishing Tasks: Tasks that need to be performed after the migration.

Note: This document typically uses UNIX/Linux syntax when specifying directories. If using Windows as a Source System, substitute the appropriate syntax for that platform.

Section 1: Prerequisites

Prepare the Source System before migrating to a new platform. If your system uses multiple application tier nodes, the following prerequisite steps must be performed on all nodes.

Verify operating system requirements on Target SystemBefore migrating to the new platform, ensure the Target System meets all the requirements for Oracle E-Business Suite Release 12.0.4 or 12.1.1 posted in the Oracle E-Business Suite Release Notes (available as My Oracle Support Knowledge Documents 549389.1 and 798258.1), and in the Oracle E-Business Suite Installation and Upgrade Notes for each platform (available as My Oracle Support Knowledge Documents 394692.1 and 790942.1).
For the latest installation guidelines, refer to My Oracle Support Knowledge Document 405565.1.

Verify Source and Target nodes software versions
In addition to the usual Oracle E-Business Suite operating system requirements, the following software component versions must exist on the Source and Target nodes.

Software	Minimum Version	Details
Zip	2.3 (or Higher)	Download from InfoZip. Zip must be in your $PATH. If using files bigger than 2Gb, you should use InfoZip ZIP 3.0 or higher.
Unzip	5.52 (or higher)	Download from InfoZip. Unzip must be in your $PATH. If using files bigger than 2Gb, you should use InfoZip UNZIP 5.52 or higher.
Operating System utilities	N/A	The required operating system utilities for your platform must be in your $PATH when running adcfgclone.pl. For example, make, ld, and ar on UNIX. Refer toOracle Applications Installation Guide: Using Rapid Install (see Footnote 1)
JDK	1.5.x or higher	Use the JDK shipped with OracleAS 10.1.3 if available or download it fromjava.sun.com.
Perl	5.x	Use the Perl shipped with OracleAS 10.1.3 if available or download it fromPerl.com. Perl must be in the PATH and PERL5LIB must be correctly set before migrating.

Footnote 1 This is the Release 12.1.1 version; versions for earlier releases are also available from the Oracle E-Business Suite Online Documentation Library

Apply the latest AD patch
Update the Oracle E-Business Suite file system with Patch 6510214 the latest AD patch. At the time of this note, the following patches were available. Refer to My Oracle Support to obtain the latest AD patch available in case they are superseded.
- For Release 12.0:
  
  Patch
  Description
  
  R12.AD.A.DELTA.4 AD.A Minipack Delta 4

Patch	Description
R12.AD.A.DELTA.4	AD.A Minipack Delta 4

For Release 12.1:

Patch
Description

R12.AD.B.DELTA.3 AD.B Minipack Delta 3

Upgrade Oracle E-Business Suite to Release 12.0.4 (or Higher)
If not already applied, update the Oracle E-Business Suite file system with Patch 6435000 (Oracle E-Business Suite RUP4). Refer to My Oracle Support Knowledge Document 465776.1for the latest instructions on applying this patch.

Note: This step only applies to 12.0 code line.
Apply the latest AutoConfig Template patch
Update the Oracle E-Business Suite file system with the latest AutoConfig template files by applying the TXK AutoConfig Template rollup patch to all application tier server nodes. Refer to My Oracle Support Knowledge Document 387859.1 for details of the latest Autoconfig Template rollup patch.
Apply the latest Rapid Clone patchesUpdate the Oracle E-Business Suite file system with the latest Patches required by Rapid Clone. Refer to My Oracle Support Knowledge Document 406982.1 for details of the latest required patches.
Apply Platform Migration PatchesUpdate the Oracle E-Business Suite file system with the following patches:
- For Release 12.0:
  
  Patch
  Description
  
  6903505:R12.AD.A QRMP:NOT ABLE TO APPLY R12 PLATFORM SPECIFIC PATCH DURING PLATFORM MIGRATION
  
  6156498:R12.OAM.A MIGRATION: CHANGES NEEDED TO ADCLONECTX.PL SCRIPT

Patch	Description
R12.AD.B.DELTA.3	AD.B Minipack Delta 3

Patch	Description
6903505:R12.AD.A	QRMP:NOT ABLE TO APPLY R12 PLATFORM SPECIFIC PATCH DURING PLATFORM MIGRATION
6156498:R12.OAM.A	MIGRATION: CHANGES NEEDED TO ADCLONECTX.PL SCRIPT

For Release 12.1:
No patches required at this time.

Apply Additional Patches (Conditional)If not already applied, update the Oracle E-Business Suite file system with the following patches:
- For Release 12.0:

Patch
Description

6767273:R12.AD.A INSTALLING R12.AD.A.DELTA.4 FAILS FOR OFF-CYCLE PRODUCTS (AD)

6742236:R12.TXK.A FORMS FAILS TO LAUNCH USING FIREFOX AND MOZILLA (TXK)

Patch	Description
6767273:R12.AD.A	INSTALLING R12.AD.A.DELTA.4 FAILS FOR OFF-CYCLE PRODUCTS (AD)
6742236:R12.TXK.A	FORMS FAILS TO LAUNCH USING FIREFOX AND MOZILLA (TXK)

For Release 12.1: No patches required at this time.

Run AutoConfig on the Source System
Follow the steps under section "Run AutoConfig on the Application Tiers" in My Oracle Support Knowledge Document 387859.1 to Run AutoConfig on all application tier nodes.
Run adpreclone on the Source System
Execute adpreclone.pl on all the application tiers. Refer to My Oracle Support Knowledge Document 406982.1 for details on how to run adpreclone.
Maintain Snapshot InformationLog in to each application tier node as the applmgr user, and run "Maintain Snapshot information" in AD Administration (adadmin). See Oracle E-Business Suite Maintenance Utilities for more information.

Identify Technology Stack Updates
If you have applied any patches on the Oracle E-Business Suite Technology Stack you must apply them on the Target System after the migration. At this point, you must identify all the patches applied to the Oracle Application Server 10.1.2 and 10.1.3 ORACLE_HOMEs on the Source System, so they can be applied to the Target System in a later step.

Verify the patch level on the ORACLE_HOMEs by executing the Technology Stack Inventory Utility. This utility will produce an HTML report (or text report if desired). Review any required actions before proceeding with the Applications Technology updates.
Establish the needed environment parameters by sourcing the Applications environment file as the owner of the application tier file system.
Ensure the "APPLRGF" variable is set in environment. If not, set it to the same value as "APPLTMP".

Navigate to [FND_TOP]/patch/115/bin. Run the utility as follows:

Operating System	Command Line
UNIX/Linux	`$ perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$APPLTMP/Report_Inventory.html`
Windows	`C:\>perl %FND_TOP%\patch\115\bin\TXKScript.pl -script=%FND_TOP%\patch\115\bin\txkInventory.pl -txktop=%APPLTMP% -contextfile=%CONTEXT_FILE% -appspass=apps -outfile=%APPLTMP%/Report_Inventory.html`

Where:

Parameter	Usage
txktop	Temporary working directory use by Perl Modules. Should not be an empty string.
contextfile	Location of the context file. If not passed, default is picked from the environment.
appspass	APPS schema password. If not passed, default password is used.
outfile	Location for the report being generated. If not passed, the default location is [APPLTMP]/TXK.

To generate the report in text format, the parameter -reporttype=text needs to be passed to the above commands. For example:

$ outfile=$APPLTMP/Report_Inventory.html -reporttype=text

Note: If you upgraded the Technology Stack components to higher versions than those included with the Oracle E-Business Suite Release 12.0.4 or 12.1.1 install media, they will have to be upgraded on the Target System after the migration. Examples could include Oracle Application Server 10.1.3.3 or JDK 1.6. Refer to My Oracle Support Knowledge Document 380482.1 for a list of relevant documents.

Section 2: Migration Tasks

Generate and upload the manifest of customer-specific files
1. Generate customer-specific manifest file:
  Log in to your Source System application tier node as the applmgr user and Source the APPL_TOP environment file. Execute the following command to generate the customer-specific file manifest:
  
  $ cd [AD_TOP]/bin $ perl adgenpsf.pl
  The above command will generate the file adgenpsf.txt under [APPL_TOP]/admin/[TWO_TASK]/out. This step should take about a minute.
2. Upload Manifest File for generation to target UNIX/Linux platform:
  Go to https://updates.oracle.com/PlatformMigration, log in with your My Oracle Support username and password, then follow the instructions on the screen to upload the manifest file previously generated.
Copy the Source System to the Target System
Copy the application tier file system from the Source Oracle E-Business Suite system to the Target Node by executing the following steps in the order listed. Make sure the applmgr user owns the files copied to the Target System.

[APPL_TOP]
[COMMON_TOP]/clone
[COMMON_TOP]/java
[COMMON_TOP]/_pages
[COMMON_TOP]/webapps
[COMMON_TOP]/util

Copy only the directories listed, not the full COMMON_TOP.
If you want the migrated system to have a new digital signature, remove the file [APPL_TOP]/admin/appltop.cer from the Target System.

Install JDK and InfoZip utilities on the Target System
If not already installed, the following utilities must be installed on the Target System:
- JDK 1.5 or higher, in the JDK_HOME
- InfoZip UNZIP version 5.52
- InfoZip ZIP version Zip 2.30
Copy the Source System Context File to the Target System

Clone the Applications Context File on the Target SystemLog in to the Target System as the applmgr user and run the following commands:

Create a pairsfile (text file) with the following values:

s_systemname=[SID] s_dbSid=[SID] s_jdktop=[JDK_HOME] s_jretop={JDK_HOME]

Generate the Target System Context File:

cd [COMMON_TOP]/clone/bin

perl adclonectx.pl migrate \

java=[JDK_HOME] \

pairsfile=[pairsfile] \

contextfile=[Source Applications Context File]

Where:

Parameter	Meaning
[SID]	Database Name
[JDK_HOME]	Complete $PATH where JDK is installed
[pairsfile]	Complete $PATH to the pairsfile created in Step a.
[Source Applications Context File]	Complete $PATH to the Source System Context File copied to the Target System

.

Note: The Clone Context tool will ask for all the new mount points on the Target System migration node.

Note: If SQL*Net security is being used, the Target System should be allowed to make incoming connections to the database before running the Clone Context utility.

Install the Application Tier Technology Stack
Run the Rapid Install Wizard with the -techstack option to install the Oracle E-Business Suite Technology Stack. Use the Target System context file created in the previous step:

$ cd [Stage12]/startCD/Disk1/rapidwiz $ ./rapidwiz -techstack
Refer to the Oracle E-Business Suite Installation Guide for more details.

Note: Use the latest startCD available. Patch 6796703 For details of the latest startCD Patch for Release 12.0.4 or 12.1.1, refer to the "Current Version of Rapid Install" section in the relevant Oracle E-Business Suite Release Notes available My Oracle Support Knowledge Documents 549389.1 (12.0.4) and 798258.1 (12.1.1).
Run AutoConfig setup phase on the Target System
Execute the INSTE8_SETUP phase of AutoConfig with the new context file. This will create the environment files required for the AutoPatch session:

$ cd [AD_TOP]/bin $ ./adconfig.sh run=INSTE8_SETUP contextfile=[Target System Context File]
Note: This command does not require the environment to be sourced.

Note: If you have chosen to create a new digital signature for the Target System, the above AutoConfig session may complete with errors: specifically, the adgenjky.sh script fails to generate the appltop.cer file. This can occur because the adjkey executable that this script calls is still specific to Source system. However, the adgenjky script will be executed correctly on the last step of the migration.
Download and apply the customer-specific update with AutoPatch
Within 30 minutes from the time you uploaded the manifest file at Step 1b you should receive a notification email stating that your customer-specific update patch is ready. Follow the instructions in the email to download it from My Oracle Support.
The patch should be applied on all Target System Application Nodes. Source the APPL_TOP environment file before applying the patch. AutoPatch will automatically relink the executables.

Note: In order to execute AutoPatch successfully on the new platform, you must use the adpatch executable included in this patch instead of the one located in [AD_TOP]/bin.
A compiled adpatch executable for all the supported platforms is included in the ZIP file Patch Directory/ad/patch/115/etc/adpatchR12_AD_A.zip for 12.0 and Patch Directory/ad/patch/115/etc/adpatchR12_AD_B.zip for 12.1. Refer to the README.txt file located in these ZIP files for details on the directory locations for the adpatch executable for your platform.

This patch must be applied as follows:

$ adpatch options=hotpatch,phtofile
Note: Executables dependent on third party products (such as ilog, Roguewave, Quantum, SHT) may fail during relinking. This is expected and is addressed in "Section 3: Finishing Tasks". In such a case, answer "yes" when adpatch asks whether to "Continue as if it were successful".
Apply IBM:Linux on System z compatibility patch (Conditional)
If target platform is IBM:Linux on System z then download and apply the following Patch:
- For Release 12.1.3 (or higher)

Patch
Description

10126780:12.1.0 MERGE PATCH FOR PLATFORM MIGRATION ON IBM:LOZ(209)

Patch	Description
10126780:12.1.0	MERGE PATCH FOR PLATFORM MIGRATION ON IBM:LOZ(209)

Note: If you have languages other than American English already installed in your Release 12.1 system, apply the translated version(s) of Patch 10126780:12.1.0 for each active language.

Review Component Versions and Technology Stack patch level
In Section 1, Step 11 you identified updates applied to your Source System Technology Stack. If any, apply these patches to the Target System technology stack now.

Note: If you upgraded the Technology Stack components to higher versions than those included with the Oracle E-Business Suite Release 12.0.4 or 12.1.1 install media, they should be upgraded on the Target System now. Examples could include Oracle Application Server 10.1.3.3 or JDK 1.6. Refer to My Oracle Support Knowledge Document 380482.1 for a list of relevant documents.

Regenerate File System Objects
Source the APPL_TOP environment file and perform the following tasks to regenerate the platform dependent files on the Target System:
1. If migrating an application tier that starts Forms, run the following commands:
  
  $ cd [AD_TOP]/bin $ ./adgensgn.sh [Apps User]/[Apps Password]
2. Run adadmin to generate messages, forms, reports and product jar files.

Clean Nodes (Conditional)
If you are migrating into a different machine name, you will need to recreate the Node configuration by completing the following two steps:
1. Run afcpclean.sh in the Target Application Tier.
  
  $ cd [INST_TOP]/admin/install $ ./afcpclean.sh [Apps User] [Apps Password]
  Warning: This step will remove the Nodes from the current system. It only applies if the source and target hostnames have changed. Before running this step, shut down all the application tier service processes.
2. Log into the Source Database Tier and run Autoconfig
Run AutoConfig to complete the Target System configuration

$ cd [AD_TOP]/bin $ ./adconfig.sh contextfile=[Target System Context File]
Note: On this last step, the database will be updated to reflect the new Target System profile. Ensure any users log off the system, then shut down the Source System application tier service processes. After this, the Source System application tier will no longer be available.

Section 3: Finishing Tasks

This section lists tasks that may be necessary, depending on your implementation and the intended use of the migrated system.

Update Third Party Extensions
If your Oracle E-Business Suite system is implementing any products which use ilog, RogueWave, Quantum or SHT, you will need to update the Target System with the objects for the third party extensions, then relink any dependent products.

Third Party Software	Action Needed
ilog	Apply Patch 10135606 and relink dependent executables.
RogueWave	Apply Patch 10135608 and relink dependent executables.
Quantum	Follow instructions in My Oracle Support Knowledge Document 224273.1 Document 224273.1.
Application Shared Technology (SHT)	Apply Patch 10135610 and relink dependent executables

Review and update Target System Application Tier Settings and Customizations
Recompile any custom code (forms, C) in the Target System APPL_TOP.

If you were using Oracle Discoverer 10.1.2, OID, SSO or Portal 10g on the Source System, refer to the corresponding documentation to complete the migration:

Product	Documentation
Oracle Discoverer 10.1.2	My Oracle Support Knowledge Document 373634.1.
Oracle Internet Directory (OID) and Oracle Single Sign-On (SSO)	My Oracle Support Knowledge Document 376811.1.
Oracle Portal 10g	My Oracle Support Knowledge Document 380484.1.

Note: Refer to My Oracle Support Knowledge Document 380482.1 for documents relating to other Technology Stack components.

Update printer settings
If the newly migrated system needs to utilize different printers, update the target system with the new printer settings now.

Update Oracle Workflow configuration settings
Migrating an Oracle E-Business Suite instance will not update the host and instance specific information used by Oracle Workflow. Review the following tables and columns to verify there is no instance specific data in the Workflow configuration on the Target System.

Table Name	Affected Column(s)	Column Value Action Needed
WF_NOTIFICATION_ATTRIBUTES	TEXT_VALUE	Value starts with http://[old web host] : Update to new web host
WF_ITEM_ATTRIBUTE_VALUES	TEXT_VALUE	Value starts with http://[old web host] : Update to new web host
WF_SYSTEMS	GUID	Create a new system defined as new global database name, via Workflow Administrator Web Applications responsibility.
WF_SYSTEMS	NAME	Replace value with database global name
WF_AGENTS	ADDRESS	Update database link with new database global name.
FND_FORM_FUNCTIONS	WEB_HOST_NAME	Update with new web host name
FND_FORM_FUNCTIONS	WEB_AGENT_NAME	Update to point to new PL/SQL listener name
FND_CONCURRENT_REQUESTS	LOGFILE_NAME	Update with the correct path to logfile directory
FND_CONCURRENT_REQUESTS	OUTFILE_NAME	Update with the new directory path on Target System

Verify the APPLCSF variable setting
Source the APPS environment and review that the variable APPLCSF (identifying the top-level directory for concurrent manager log and output files) points to a suitable directory. To modify it, change the value of the s_applcsf variable in the context file and then run AutoConfig.
Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
If the Target System is in a different domain name than the Source System and SESSION_COOKIE_DOMAIN was not null in the Source System, update that value to reflect the new domain name.
Start all services on the Target System
Start all services by running the script:

$ cd [INST_TOP]/admin/scripts $ ./adstrtal.sh [Apps User] / [Apps Password]

Change Log

Date	Description
Jan 03, 2011	Corrected URLs for updates.oracle.com
Oct 28, 2010	Added support for Linux running on IBM System z Updated patches in Third Party Extensions Section
Sep 02, 2010	Made Document Generic for all Release 12 versions Added restriction for Linux running on IBM System z
Feb 01, 2010	Recreated document in standard format. Also amended document title, slightly reworded introductory section, changed document references from OracleMetaLink to My Oracle Support, and changed product references from Oracle Applications to Oracle E-Business Suite.
May 15, 2008	Split required patches and additional patches on a separate conditional step to avoid confusions.
May 12, 2008	Added additional Patches on Section 1, Step 7.
Mar 29, 2008	Publishing Review.
Aug 04, 2007	Initial document created.

References

NOTE:380482.1 - Oracle E-Business Suite Release 12 Technology Stack Documentation Roadmap
NOTE:387859.1 - Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12
NOTE:405293.1 - Oracle Applications Release Notes Release 12
NOTE:406982.1 - Cloning Oracle Applications Release 12 with Rapid Clone

Related

Products

Oracle E-Business Suite > Applications Technology > Technology Components > Oracle Applications Utilities

Keywords

ADCFGCLONE.PL; ADCLONECTX.PL; ADCONFIG.SH; ADPRECLONE.PL; APPLICATION INSTALLATIONS; AUTOCONFIG; CLONE; DOMAIN NAME; E-BUSINESS; INSTALL & CONFIGURE; MIGRATE; MIGRATION; MIGRATION PROCESS; OPERATING SYSTEM; R12; RAPID INSTALL; RAPIDWIZ; SOURCE; UTILITY; WIZARD

Rate this document

Oracle Apps DBA stuff

Thursday, April 12, 2012

Application Tier Platform Migration with Oracle E-Business Suite Release 12

Benefits

Restrictions

Terminology

Contents

Section 1: Prerequisites

Section 2: Migration Tasks

Section 3: Finishing Tasks

Change Log

References

No comments:

Post a Comment

Search This Blog

Blog Archive