1 / 28

APPLYING INTEROPERABILITY PATCH FOR ORACLE APPLICATIONS 11.0.3

APPLYING INTEROPERABILITY PATCH FOR ORACLE APPLICATIONS 11.0.3. By Ramkumar Srinivasan DBA/System Administrator Dreyer’s Grand Ice Cream Inc. DISCLAIMER & COPY RIGHTS . Oracle and it’s respective tools are registered trade marks of Oracle Corporation.

tristana
Download Presentation

APPLYING INTEROPERABILITY PATCH FOR ORACLE APPLICATIONS 11.0.3

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. APPLYING INTEROPERABILITY PATCH FOR ORACLE APPLICATIONS 11.0.3 By Ramkumar Srinivasan DBA/System Administrator Dreyer’s Grand Ice Cream Inc.

  2. DISCLAIMER & COPY RIGHTS • Oracle and it’s respective tools are registered trade marks of Oracle Corporation. • Windows and it’s 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 DREYER’S 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_enabled=false, aq_tm_processes=0 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/pfile/initr11.ora

  8. Cd $ORACLE_HOME/rdbms/admin Sqlplus internal; Startup restrict; Set echo on Set feedback on Spool 8173upg.lst @u0800050.sql @utlconst.sql @catrep.sql @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 (don’t 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 => 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: -l:libcl.a -l:librt.sl -lpthread -l:libnss_dns.1 -l:libdld.sl –lgen If you don’t add –lgen you can’t 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; @addb817.sql (going to take at least 45 minutes) connect system/ @adsy817.sql Run the following script to create the Intermedia objects: oracle-[unknown]>more crtctx.sh sqlplus system/xxxx @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 force=y ranlib=y "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 force=y ranlib=y "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/patches/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 port=9000 log=f45ctlstop.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 force=y ranlib=y "fnd ar25run" • As applmgr in the middle tier do the following: adrelink force=y ranlib=y "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@r11 ADD \ GWYUID=$GWYUID FNDNAM=$FNDNAM \ SECURE_PATH=$FND_TOP/secure \ GUEST_USER_PWD=GUEST/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

More Related