Covert to Shared appltop.

Covert to Shared appltop. : This was tested on 11.5.10, Please check the Oracle documentations for the latest patches and updates. (Ref: metalink note : Sharing the Application Tier File System in Oracle Applications Release 11i [ID 233428.1] )



1 Verify the pre-requisites
1.1 Software Requirements:
Ensure that these minimum versions are present in your system.

• 5035661 to each iAS ORACLE_HOME in the application tier.
• TXK AutoConfig Templates RUP O or higher (Apply patch 5478710 to each APPL_TOP in the application tier)
• TXK Technology Stack Minipack B (Apply patch 3219567 to each APPL_TOP in the application tier)
• AD Mini-pack I or higher (Apply patch 4038964)
• iAS Oracle HTTP Server Rollup 5 or higher (Apply the latest critical patch update available for Oracle E-Business Suite 11i. Refer to section
"Oracle HTTP Server Patches for Oracle E-Business Suite 11i" for instructions)
• Discoverer 4.1.48.08 (See OracleMetaLink Doc ID: 139516.1 OracleMetaLink Doc ID: 139516.1)
• Reports 6i Developer 6i PS 17 or higher (Please refer to Oracle MetaLink Note 125767.1 for instructions)
• Zip 2.3 (Zip Utility is available for download from
http://www.info-zip.org/Zip.html, Unzip utility is available for download from http://www.info-zip.org/UnZip.html )

1.2 Other Requirements:

New File system mount point (with around 65GB disk space or equivalent with existing APPL_TOP of of the ERP environment


2 Implement Shared Application file system
2.1 Pre-Merge Tasks

For Clarity
Admin Node = Concurrent Manager node
Application Node = Application (Web) Tier Node
2.1.1 Shutdown all the services

Reference:
• Concurrent managers / Forms / Web servers and others using adstpall.sh from

$COMMON_TOP/admin/scripts/$CONTEXT_NAME on each node.
2.1.2 Bounce the database

Reference:
• after modifying the utl file parameter in the init.ora file to include new $COMMON_TOP/temp directory as

the first parameter in the utl file parameter)

2.1.3 Enable maintenance mode
Run adadmin to enable maintenance mode

2.1.4 Apply template patch 5478710
Reference:
• Run validation script from /fnd/patch/115/bin by giving the command:
./txkprepatchcheck.pl -script=ValidateRollup
-outfile=$APPLTMP/txkValidateRollup.html
-appspass=

• Apply the patch using adpatch on all tiers. On the Application Tier (as the APPLMGR user), Source the

environment file. (ensure zip version2.3 is in the current PATH)
• Create the appsutil.zip file by executing:
$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
This will create appsutil.zip in $APPL_TOP/admin/out

• On the Database Tier (as the ORACLE user, Source the environment file.
Copy the appsutil.zip file to the
cd
unzip -o appsutil.zip
Run AutoConfig by executing:
/appsutil/scripts//
adautocfg.sh (On Windows use adautocfg.cmd).
2.1.5 Clean FND_NODES and AD_APPL_TOPS tables.

Note:
(Perform these steps ONLY if there are more than required entries in FND_NODES or AD_APPL_TOPS tables)


Reference:
• Take a backup of AD_APPL_TOPS table and truncate ad_appl_tops table (Ref. Metalink Note ID 372758.1).

sqlplus apps/apps
exec FND_CONC_CLONE.SETUP_CLEAN;

conn applsys/apps
create table ad_appl_tops_bak as (select * from ad_appl_tops);
truncate table ad_appl_tops;

run afcpnode.sql script from $COMMON_TOP/admin/install/$CONTEXT_NAME directory after editing

following two lines to have correct physical host name and domain name for CM Tier Node
DEFINE HOST_NAME=" "
DEFINE DOMAIN_NAME=" "

Run autoconfig

select applications_system_name from ad_appl_tops;
col snapshot_name for a33
select SNAPSHOT_ID, APPL_TOP_ID, snapshot_name, LAST_UPDATE_DATE from ad_snapshots;
select appl_top_id, name from ad_appl_tops;
update ad_snapshots set appl_top_id = '106' where appl_top_id = '86' ;
commit;


2.1.6 Apply Latest AD.I Patch

Note:
Apply the patch on all App Tiers using following adpatch options:
adpatch options=nocopyportion,nodatabaseportion,nogenerateportion

Alert:
If this step is not performed there will be issues in step 13 and all the steps from 6 to 12 will be required to be repeated.

2.1.7 Run adconfig on App Tiers

Reference:
• Run adautocfg.sh from $COMMON_TOP/admin/scripts/$CONTEXT_NAME on all nodes first on DB

tier (on DB Tier you need to run it from $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME directory) and then the APPS Tiers

2.1.8 Backup the configuration files

2.1.9 Run maintain snapshot
Reference:
• Run adadmin utility to "Maintain snapshot information" using "Maintain Applications Files menu" ==>

"Maintain snapshot information" ==> "Update current view snapshot" from all nodes (30 to 45 min on each node)

2.1.10 Run missing files report
Reference:
• Run adadmin utility to “Check for missing files” using “Maintain Applications Files menu" ==> "Check

for missing files” from all nodes. This would be later used to compare the same report.

2.1.11 Rename Clone directory on all App Tiers

2.1.12 Run Preclone
Run "perl adpreclone.pl appsTier" from all applications tiers (APPL_TOPS) from $COMMON_TOP/admin/scripts/$CONTEXT_NAME

2.1.13 Verify 8.0.6 & iAS_HOME are in sync
8.0.6 and iAS_HOMe should be at the same patch level on the admin and the app tier servers.
If these are not, you need to bring them in sync by applying the latest security patches.
This issue is caused by not applying all the forms/reports CPU/oneoff patches on both the tier servers.


3 Perform the Merge

Outage Starts

Stop all application services

Ensure correct version (2.3) of zip executable in the path (usually under $COMMON_TOP/util
Reference:
• Run "perl adpreclone.pl appsTier merge"
on admin (primary) tier from $COMMON_TOP/admin/scripts/$CONTEXT_NAME
• Creates the Manifest file and upload it to the database using current snapshot. (~45 min)
• Run "perl adpreclone.pl appltop merge" on application tier nodes from $COMMON_TOP/admin/scripts/$CONTEXT_NAME
• This command needs to be run on EACH of the application tier node
• This command can be started in parallel after the previous command has displayed a message on the screen. Then this can be run in parallel on all the app tier nodes
• Messgage displayed –
“You can now go ahead and run the preparation on the subsequent node(s) while this process completes.”



4 Copy Files to New File System

4.1 Mount shared application file system on secondary node
4.2 Files from ADMIN node
• Copy following directories including contents from the existing directory structure of ADMIN node to the new directory structure -
• $APPL_TOP,
• $OA_JAVA,
• $COMMON_TOP/util,
• $COMMON_TOP/clone,
• $COMMON_TOP/_pages,
• $ORACLE_HOME (8.0.6 Oracle Home)
• $IAS_ORACLE_HOME directories

4.3 Files from ANY of the App tier Node
• Copy $OA_HTML directoty from any of the application tier node to the new directory structure
4.4 Files from ALL of the App tier nodes
• copy $COMMON_TOP/clone/appl directory from original secondary node file system to the newly mounted NFS file system
4.5 Synchronize custom_top’s
• Manually synchronize/merge custom_tops from app tier and admin tier nodes to the new file system
4.6 Run adcfgclone on ADMIN Node
1.
Reference:
• Open a new unix window to connect to the primary node without sourcing any environment file (2 min)
• Set minimum environment variables as following by modifying it to point to the correct new directory structure

export PERLBIN=//erpapp/iAS/Apache/perl/bin

export PATH=//erpapp/iAS/Apache/perl/bin:/mountpoint/apps/cp/ora/8.0.6/bin:
/mountpoint/apps/cp/r11.5.10/fnd/11.5.0/bin://erpapp/appl/ad/11.5.0/bin:
//erpapp/comn/java/1.5.0_09/bin://erpapp/comn/util/unzip/unzip
export PATH=$PATH:/usr/bin:/usr/ccs/bin:/usr/sbin:/bin:/usr/afsws/bin:/usr/xpg4/bin:/sbin:/usr/openwin/bin:/
usr/ucb:/usr/local/bin:/export/home/appcp/local/scripts:/usr/dt/bin:/etc:/opt/EMCpower/bin/64:/etc/emc/bin
export PERL5LIB=/mountpoint/apps/cp/ora/iAS/Apache/perl/lib/5.00503:
/mountpoint/apps/cp/ora/iAS/Apache/perl/lib/site_perl/5.005:/mountpoint/apps/cp/r11.5.10/au/11.5.0/perl
export ADPERLPRG=/mountpoint/apps/cp/ora/iAS/Apache/perl/bin/perl

(Note: replace the above example with appropriate values)

• execute the following commands to configure the apps tier :
[applmgr]/appcp $ cd //erpapp/comn/java
[applmgr]/appcp $ chmod -R u+w *
(Note: This step is required because some of the files under this directory are with just read permission, which causes problem during the merge process when the files are overwritten)

• ensure that /var/opt/oracle/oraInst.loc file is pointing to the correct oraInventory file and this file has proper permissions.
[applmgr]/appcp $ cd /mountpoint/apps/cp/comn/clone/bin
[applmgr]/bin $ perl adcfgclone.pl appsTier

4.7 Perform adadmin tasks on admin node
Reference:
From New APPL_TOP source the APPS_.env file and run adadmin utility to perform following actions:
• Generate JAR files
• Generate message files
• Relink executables
• Check for missing files

Compare the report generated from “Check for missing files” option of adadmin with the same report generated


4.8 Enable shared application file system
On the Admin node enable the shared file system support.

Reference:
$ cd /patch/115/bin
$ perl -I /perl txkSOHM.pl
• This script ask response for following prompts:
Absolute path of the context file
Type of Instance
Absolute path of 8.0.6 shared Oracle Home – new path
Absolute path of iAS shared Oracle Home – new path
Absolute path of Configuration top – new path
Oracle Applications APPS Schema password

4.9 Enable shared application file system on ALL application tier nodes

Run this command on all the application tier nodes.

Reference:
Rename existing context file and run the following commands: (ensure that directory structure is same like the new one)
• Create a new unix session on secondary node and perform following tasks
cd /bin
$ perl adclonectx.pl sharedappltop \
contextfile=
$ cd /patch/115/bin
$ perl -I /perl txkSOHM.pl
• The script will ask response for following prompts:
Absolute path of the context file
Type of Instance
Absolute path of 8.0.6 shared Oracle Home
Absolute path of iAS shared Oracle Home
Absolute path of configuration top
Oracle Applications APPS Schema password

4.10 Run adconfig on all tiers
 Edit the context file on ALL the nodes (Admin and Application tier nodes) to reflect your Load-balanced URL.

 Run adconfig on all tiers starting with DB Tier first


******This is not applicable for R12*********

Ref:  metalink note : Sharing the Application Tier File System in Oracle Applications Release 11i [ID 233428.1]