APPLYING INTEROPERABILITY PATCH FOR ORACLE APPLICATIONS 11.0.3

1
APPLYING INTEROPERABILITY PATCH FOR ORACLE
APPLICATIONS 11.0.3

• By
• Ramkumar Srinivasan
• DBA/System Administrator
• Dreyers Grand Ice Cream Inc.

2
DISCLAIMER COPY RIGHTS

• Oracle and its respective tools are registered
  trade marks of Oracle Corporation.
• Windows and its respective tools are registered
  trade marks of Microsoft Corporation.
• These presentation steps may or may not work with
  your present environment.
• The statements and opinions expressed here are my
  own and do not necessarily represent any company.

3
APPLYING PATCHES FOR ORACLE APPLICATIONS 11.X
DREYERS GRAND ICE CREAM CASE STUDY

• In this presentation, I will detail the
  techniques used and offer real-life experiences
  while applying the interoperability patch for
  Oracle Applications 11.0.3. I will also review my
  experience while installing patches in Oracle 8i
  on HPUX running Oracle application 11.0.3 with
  server partitioning (Oracle 8.0.6.3). A detailed
  explanation of installing Oracle 8i, adpatch and
  how to use adpatch, adctrl and adadmin Oracle
  application utilities will also be covered.

4
PATCH INSTALL STEPS

• Install Oracle 8.1.7.3
• Upgrade Oracle database to 8.1.7.3
• Upgrade Database tier applications to 8.0.6
• Upgrade Middle tier applications to 8.0.6
• Apply interoperability patch in Database tier
• Apply interoperability patch in Middle tier
• Patch Install

5
ORACLE APPLICATIONS LAYOUT

• Three Tier Architecture
• Database Tier Oracle 8.1.7.3 running on
  HPUX11.0, Concurrent Manager, Reports
• Middle Tier Oracle 8.0.6.3 and forms server,
  Dev. 1.6.1 OWS 3.0.2.0
• Client Thin Client Jinitiator 1.1.8.16

6
ORACLE 8.1.7.3 INSTALL

• Install Oracle 8.1.7 in a different ORACLE_HOME.
• Apply the 8.1.7.3 patch.
• Make sure you are pointing the ORACLE_BASE to
  ORACLE_HOME.
• Before upgrading the existing 8.0 database to
  8.1.7.3 comment all the obsolete parameters in
  your init.ora. Add the following also to
  init.ora
• _system_trig_enabledfalse, aq_tm_processes0
• Comment out the compatibility parameter

7

• Select custom install.
• Do not create any database from the install
  actions.
• Run root.sh from ORACLE_HOME as root.
• Upgrading to 8.1.7.3 using scripts estimated
  time around 45-60 minutes
• Create a link for initr11.ora in ORACLE_HOME/dbs
  directory.
• Cd ORACLE_HOME/dbs
• ln s initr11.ora /home/apps/oracle/admin/r11/pfil
  e/initr11.ora

8

• Cd ORACLE_HOME/rdbms/admin
• Sqlplus internal
• Startup restrict
• Set echo on
• Set feedback on
• Spool 8173upg.lst
• _at_u0800050.sql
• _at_utlconst.sql
• _at_catrep.sql
• _at_utlrp.sql
• Spool off

9
UPGRADING DATABASE TIER TO 8.0.6 (SERVER
PARTITIONING)

• Login to the database tier as oracle owner.
• Shutdown the instances that share the oracle home
  .
• Login as oracle and run resource your environment
  (for fnd portion).
• Mount the cdrom and run the installer orainst.
• Choose custom installation. Select Install
  Software (dont create database) once the install
  is completed run the root.sh as root.
• Unset ORACLE_SID and set TWO_TASK to your 8.1.7.3
  instance name.

10
APPLYING PATCHES

• Copy bug1337111 to ORACLE_HOME/patches/
• Cd bug1337111
• sh README.bug1337111
• Please make sure ORACLE_HOME is set.
• Run ar tv libnetwork.a grep nautab.0
• Check for the file size and time stamp form the
  bug directory
• Cd ORACLE_HOME/bin
• ./genclntsh gt recreates the client libraries.

11

• Copy bug973709.tar to ORACLE_HOME.
• Untar using tar xvf.
• It will create a directory bug973709 in
  ORACLE_HOME.
• Cd to bug973709. Run ./install.sh
• Add the following -lgen to the end of
  sysliblist located in
• ORACLE_HOME/lib. The file should look like this
• -llibcl.a -llibrt.sl -lpthread -llibnss_dns.1
  -llibdld.sl lgen
• If you dont add lgen you cant recompile the
  executables.

12
APPLYING DEV 1.6.1 PATCHES

• Once you have upgraded the database tier to
  8.0.6.3 you have to reapply patch set 16 for Dev
  1.6.1.
• Login as oracle and resource the environment.
• Cd ORACLE_HOME/dev2000r161_patch16.
• ./ patch_install.sh
• Relinking Database Tier Executables
• cd ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk
  install
• cd ORACLE_HOME/sqlplus/lib make -f
  ins_sqlplus.mk install
• cd ORACLE_HOME/network/lib make -f
  ins_network.mk install
• cd ORACLE_HOME/reports25/lib make -f
  ins_reports25wv8.mk install
• cd ORACLE_HOME/procbuilder/lib make -f
  ins_procbuilderv8.mk install

13
MIDDLE TIER PATCHES

• Follow the same steps for 8.0.6.3 patch install
  from the database tier.
• Reapply the patchset 16 for Dev 1.6.1.
• Relinking Middle Tier Executables
• cd ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk
  install
• cd ORACLE_HOME/sqlplus/lib make -f
  ins_sqlplus.mk install
• cd ORACLE_HOME/network/lib make f
  ins_network.mkinstall
• cd ORACLE_HOME/forms45/lib
• make -f ins_forms45wv8.mk install
• cd ORACLE_HOME/graphics25/lib
• make f ins_graphics25wv8.mk install

14
PRE-INTEROPERABILITY STEPS

• Add the following to initr11.ora file
• event"10929 trace name context forever"
• event"10932 trace name context level 2"
• Resource your environment .
• Start the listener appslisterner
• Sqlplus internal
• Startup restrict
• Create a new tablespace for ctxsys as follows
• create tablespace ctxsys datafile
  '/appsp09/oracle/r11/ctxsys01.dbf' size 50M
• Cd /apps/finapps/product/11.0/patches/817sqls

15

• Sqlplus internal
• _at_addb817.sql
• (going to take at least 45 minutes)
• connect system/
• _at_adsy817.sql
• Run the following script to create the Intermedia
  objects
• oracle-unknowngtmore crtctx.sh
• sqlplus system/xxxx _at_addbctx.sql \
• TRUE CTXSYS TEMP ORACLE_HOME/ctx/lib/libctxx8.
  sl
• (TRUE Removes the old context objects
• CTXSYS Default tablespace for ctxsys

16

• Apply 1239901 patch (Interoperability Patch -
  applmgr)
• Apply 1244775 patch (applmgr)
• As oracle (applmgr.env) relink all
• As applmgr make f ins_rdbms.mk install
• As applmgr do the following adrelink forcey
  ranliby "fnd ar25run"
• Run adadmin and relink all modules and compile
  all objects.
• As applmgr make f ins_rdbms.mk install
• As applmgr do the following adrelink forcey
  ranliby "fnd f45webm"
• Run adadmin and relink all modules and compile
  all objects.

17
adpatch

• Adpatch is the applications utility to install
  patches for oracle
• applications. Oracle provides a patch list from
  time to time or you
• might ask for site specific patches.
• Adpatch can be run on both the tiers.
• Running adpatch on the database tier
• Shutdown the concurrent manager before starting
  the adpatch
• Login as the application user eg., applmgr.
• cd to the desired patch directory or where the
  patch is residing.

18

• adpatch
• APPL_TOP is set to /apps/finapps/product/11.0/r11
• adpatch will make sure the APPL_TOP directory
• You can be notified by email if a failure occurs.
• Do you wish to activate this feature Yes ? No
• Please enter the batchsize 1000 1000

19

• 1. Do you currently have files used for
  installing or upgrading the database
• installed in this APPL_TOP Yes ? Yes
• 2. Do you currently have Java and HTML files for
  Self-Service Applications
• installed in this APPL_TOP Yes ? No
• 3. Do you currently have Oracle Applications
  forms files installed
• in this APPL_TOP Yes ? No
• (On the database side there are no forms
  installed so say no to this option and you have
  to say Yes to this option in the middle tier)
• 4. Do you currently have concurrent program files
  installed in this APPL_TOP Yes ? Yes

20

• You are about to apply a patch to the
  installation of Oracle Applications
• in your ORACLE database r11'
• using ORACLE executables in '/apps/oracle/product/
  8.0.6.3'.
• 5. Is this the correct database Yes ? Yes
• AutoPatch needs the password for your 'SYSTEM'
  ORACLE
• schema
• adpatch will ask for all the schema user
  passwords hit enter, since
• the default password was not changed.

21

• Connecting to APPLSYS......Connected
  successfully.
• Enter the directory where your Oracle
  Applications patch has been unloaded
• The default directory is /apps/finapps/product/11
  .0/patches/731338 /apps/finapps/product/11.0/pa
  tches/731338
• (this is were the patch was copied or downloaded.
  After downloading the patch unzip the patch in
  the patch directory.)
• Always apply c driver first then d driver and
  finally g driver. in the middle tier no need to
  apply d driver. So c driver first and then g
  driver
• Please enter the name of your AutoPatch driver
  file patch.drv g731338.drv
• Enter the number of parallel workers 6 4
• After the patch was done check for the log files
  for any errors.

22

• APPLYING PATCH ON MIDDLE TIER
• Shutdown the forms server for the particular
  instance as the applmgr using
• f45ctl stop port9000 logf45ctlstop.log.
• Run adpatch.
• Follow the same steps from 1 to 5. You have to
  say Yes for 2,3,5 and No to 1,4 (since concurrent
  manager is running on the database side).
• As applmgr in the database tier do the following
  adrelink forcey ranliby "fnd ar25run"
• As applmgr in the middle tier do the following
  adrelink forcey ranliby "fnd f45webm"

23
adadmin

• AD Administration Main Menu in database tier
• -----------------------------------------------
  ---
• 1. Maintain Applications Database Objects
  menu
• 2. Maintain Applications Files menu
• 3. Exit AD Administration
• Enter your choice 2
• Maintain Applications Files
• ----------------------------------------
• 1. Create Applications environment file
• 2. Relink Applications programs
• 3. Copy files to destinations
• 4. Verify files necessary for runtime
• 5. Generate message files
• 6. Generate report files
• 7. Return to Main Menu

24

• Adadmin in the middle tier
• AD Administration Main Menu
• -----------------------------------------------
  ---
• 1. Maintain Applications Files menu
• 2. Exit AD Administration
• Enter your choice 1
• Maintain Applications Files
• ----------------------------------------
• 1. Create Applications environment file
• 2. Relink Applications programs
• 3. Copy files to destinations
• 4. Verify files necessary for runtime
• 5. Generate message files
• 6. Generate form files
• 7. Return to Main Menu

25
adctrl

• AD Controller Menu
• --------------------------------------------------
  -
• 1. Show worker status
• 2. Tell worker to restart a failed job
• 3. Tell worker to shutdown/quit
• 4. Tell manager that a worker failed its
  job
• 5. Tell manager that a worker
  acknowledges quit
• 6. Tell manager to start a worker that
  has shutdown
• 7. Exit

26
POST INSTALL STEPS

• Make sure you revalidate all the objects in your
  database.
• You can either run utlrp.sql or your own
  customized scripts.

27
SOME USE FULL COMMANDS

• Admrgpch To merge different patches
• Echo APPLSHAR, echo APPLFULL
• To create a dbc file
• /apps/oracle/product/8.0.6.3/jre/bin/jre
  oracle.apps.fnd.security.AdminAppServer
  apps/apps_at_r11 ADD \
• GWYUIDGWYUID FNDNAMFNDNAM \
• SECURE_PATHFND_TOP/secure \
• GUEST_USER_PWDGUEST/guest

28

• Ipcs bmop ( to find all the memory segments used
  by the processes)
• Ipcrm m-s
• Tstshm (provided by oracle)
• Orabebug ipc invoked from svrmgrl or sqlplus
• Swapinfo tam