Monday, January 28, 2013

Oracle EBS Patch Management (Non-Interactive Mode)


- Applying patch in non-interactive mode:
                                File: $APPL_TOP/admin/<SID>/adalldefaults.txt
                                - Download the patch
                                - unzip the patch
                                - Go to patch dir & review README.txt doc
                                - Stop the appl services
                                - Enable Maintenance Mode
                                - Run adpatch
                                - Disable Maintenance Mode
                 Applying patch in non-interactive mode:
                                File: $APPL_TOP/admin/<SID>/adalldefaults.txt
                                - Download the patch
                                - unzip the patch
                                - Go to patch dir & review README.txt doc
                                - Stop the appl services
                                - Enable Maintenance Mode
                                - Run adpatch
                                - Disable Maintenance Mode
                                - Start the app services
                Patch History:
                                - We can check the patch history from
                (1) DB tables                                           (2) OAM
                - DB Tables:
                                (1) AD_BUGS: It contains the patches info that are applied by the installer &                                         also the patches info that are applied by user.
                                (2) AD_APPLIED_PATCHES: It contains the patches info that are applied by user.
                                (3) AD_PATCH_DRIVERS: It contains patch driver actions info(C,D,G).
                Note:
                                One-off   -> Kbs
                                Minipack -> mbs
                                Family pack -> mbs/gbs
                                Maintenance Pack -> gbs
                Saving Patch time:
                                - Apply the patch in non-interactive mode
                                Response file: $APPL_TOP/admin/<SID>/adalldefaults.txt
                                - Download & unzip the patch
                                - Review the README.txt doc
                                - Stop the app services
                                - Enable Maintenance Mode
                                - Run adpatch in non-int.. mode
                                                File: $APPL_TOP/admin/PROD/adalldefaults.txt
                                                Note:
                                                .lgi file contains informational messages
                                                (ie.. files copied, backed up)
                                - Check logfile & disable M.M
                                - Start the applcation services
                - Merging the patches (ex: NLS patches..)
                                Note: Patches are platfrom dependent & version dependent.
                                5 Languages
                                1 -base = US English
                                4 -(AR,UK,..)
                                ex: P12345
                                - Apply base lang patch (US English)
                                - Merge the NLS Patches...(4 patches)
                                utility :admrgpch
                                - Download the patches
                                - Create src & dest dir
                                - Go to src dir & unzip the patches
                                - Go to patch dir & review README.txt
                                - Merge the patches
                                - Stop the app services
                                - Enable Maintenance Mode
                                - Run adpatch in non-interactive mode
                                - Disable Maintenance Mode
                                - Start the app services
                - Skipping Patch driver actions:
                                Actions: C,D,G
                                $adpatch options=nodatabaseportion
                                $adpatch options=nocopyportion,nogenerateportion            // EBS Upgradation
                - Skipping Post patch activities:
                                Activities: Compiling invalid objects, compiling JSP, Running autoconfig ...
                                ex:
                                8457584  $adpatch options=nocompiledb,nocompilejsp,noautoconfig                (skip)
                                5474548 $adpatch options=nocompiledb,nocompilejsp,noautoconfig   (skip)
                                9589858 $adpatch options=compiledb,compilejsp,autoconfig             (Don't skip)
                - adpatch options:
                                                $adpatch preinstall=Yes  ( To upgrade ad utilites)
                                $adpatch options=hotpatch  (To apply hot patch. No downtime required)
                                                ex: Document Patches
                                $adpatch Apply=no (To run adpatch in testmode)
                - Checking Patch history using OAM:
                                - Login as SYSADMIN
                - Select "System Administrator" resp
                - nav: Oracle Applications Manager: Patching and Utilites
                ex:   codeline
                R12.0.x                    R12.A
                R12.1.x                    R12.B
                                                Product                    codelevel
                R12.0.4                    AD                           R12.AD.A.4
                R12.1.1                    AD                           R12.AD.B.1              --------->  R12.AD.B.3             
                Table: ad_trackable_entities
                -> Patch Wizard:
                                                It is a tool to create patch filters, download patches, analyze the patch impact ..
                                - nav: Oracle Applications Manager:DASHBOARD :

No comments: