patching 11
TRANSCRIPT
-
8/3/2019 Patching 11
1/37
AuthorA.Kishore/Sachin
http://appsdba.info
1
PATCHING
Patch is a program (set of instructions) to fix a particular problem or enhance/
add a particular feature in existing program/product/software.
Patching is one of Jobs Apps DBA do frequently, so we should clear with patch
basics and process. Like Database patch, we apply using opatch, similarly for
Apps patch we will use adpatch. AD Utility & executables relating to patching
reside under product AD and is also called as Application DBA product.
There are different types of Patches.The major application patches are as follows:
Standalone/One-off Patch - This patch is created to fix/resolve aparticular bug.
Minipack Patch - This patch is the collection of one-off patches.It meansit contains group of patches to fix bug in a particular group like GL, AP.
The alphabetic characters implies the version of minipack version for the
module.For an example 11i.GL.E means E version of GL product is
released.Minipack patch is cumulative that means 11i.GL.E includes
11i.GL.A, 11i.GL.B.11i.GL.D,11i.GL.E. Family Pack Patch - This patch is the collection of minipack patches for a
particular family group of application modules.These are usually named
as 11i_PF. For an example 11i.SCM_PF.G ,here PF indicates product
family pack.
Maintenance Pack This patch is the collections of family packs thatserves as point level release upgrade. Oracle Application 11.5.10 is an
example of a Maintenance pack.
-
8/3/2019 Patching 11
2/37
AuthorA.Kishore/Sachin
http://appsdba.info
2
PATCHING STEPS
Step 1 : Set Environment Variables by executing APPSORA.env
Login as Oracle user.
In R11i we will do as follows:
$ cd /d01/oracle/prodappl
$. ./APPSORA.env
Step 2 : Stop Apps Services
In R11i we will do as follows:$ cd /d01/oracle/prodcomn/admin/scripts/PROD_erp
Execute the following script
$./adstpall.sh apps/appspassword
The script prompts are shown below for 11i
Please Note : Database and Database Listener Should be up.
-
8/3/2019 Patching 11
3/37
AuthorA.Kishore/Sachin
http://appsdba.info
3
-
8/3/2019 Patching 11
4/37
AuthorA.Kishore/Sachin
http://appsdba.info
4
-
8/3/2019 Patching 11
5/37
AuthorA.Kishore/Sachin
http://appsdba.info
5
-
8/3/2019 Patching 11
6/37
AuthorA.Kishore/Sachin
http://appsdba.info
6
Step 3 - Enable Maintenance Mode
We need to run adadmin to change maintenance mode as shown
below.
In R11i we will do as follows:
$ cd /d01/oracle/prodappl/ad/11.5.0/bin
$./adadmin
-
8/3/2019 Patching 11
7/37
AuthorA.Kishore/Sachin
http://appsdba.info
7
After running adadmin, below screen will appear
-
8/3/2019 Patching 11
8/37
AuthorA.Kishore/Sachin
http://appsdba.info
8
-
8/3/2019 Patching 11
9/37
AuthorA.Kishore/Sachin
http://appsdba.info
9
Enter Password Of SYSTEM and APPS:
-
8/3/2019 Patching 11
10/37
AuthorA.Kishore/Sachin
http://appsdba.info
10
ADADMIN main screen will appear now ,as shown below
-
8/3/2019 Patching 11
11/37
AuthorA.Kishore/Sachin
http://appsdba.info
11
Select option 5 and press Enter Key to change maintenance mode
-
8/3/2019 Patching 11
12/37
AuthorA.Kishore/Sachin
http://appsdba.info
12
Select option 1 and press Enter key to enable maintenance mode
-
8/3/2019 Patching 11
13/37
AuthorA.Kishore/Sachin
http://appsdba.info
13
Select option 3 and press Enter key to return to main menu as shown
below
-
8/3/2019 Patching 11
14/37
AuthorA.Kishore/Sachin
http://appsdba.info
14
Select option 6 and press Enter to exit ADADMIN
-
8/3/2019 Patching 11
15/37
AuthorA.Kishore/Sachin
http://appsdba.info
15
Step 4 - Patching using adpatch
Unzip the downloaded patch from metalink. Open readme.html file from unzipped patch folder. Read the following readme.html of patch # 6502082 for 11i.
We need to follow the steps mentioned in readme.html of the patchwe are going to apply.
Here we have the patch contains the u6502082.drv.Oracle haschanged the patch files and now only one file is included that has
prefixed as u .drv, previously patch had three files to
apply with prefixes (c, d, g).
-
8/3/2019 Patching 11
16/37
AuthorA.Kishore/Sachin
http://appsdba.info
16
In R11i we will do as follows: Change directory $ cd /do1/oracle/prodappl/ad/11.5.0/bin
$./adpatch
Run adpatch as shown below
-
8/3/2019 Patching 11
17/37
AuthorA.Kishore/Sachin
http://appsdba.info
17
-
8/3/2019 Patching 11
18/37
AuthorA.Kishore/Sachin
http://appsdba.info
18
-
8/3/2019 Patching 11
19/37
AuthorA.Kishore/Sachin
http://appsdba.info
19
-
8/3/2019 Patching 11
20/37
AuthorA.Kishore/Sachin
http://appsdba.info
20
-
8/3/2019 Patching 11
21/37
AuthorA.Kishore/Sachin
http://appsdba.info
21
-
8/3/2019 Patching 11
22/37
AuthorA.Kishore/Sachin
http://appsdba.info
22
The status is showing AutoPatch is complete, as shown above meansthe patch applied successfully.If there are more than one patches then
all patches should be applied before proceeding to the next disabling
maintenance mode step.
Step 5 - Disabling Maintenance Mode
The disabling steps are just same as enabling maintenance mode asshown above. Just we need to select 2 instead of 1 to disablemaintenance mode, while all other steps are same.Check the below
slide.
Step 6 - Start Apps Services
In R11i we will do as follows:$ cd /d01/oracle/prodcomn/admin/scripts/PROD_erp
$./adstrtal.sh apps/appspassword
-
8/3/2019 Patching 11
23/37
AuthorA.Kishore/Sachin
http://appsdba.info
23
-
8/3/2019 Patching 11
24/37
AuthorA.Kishore/Sachin
http://appsdba.info
24
-
8/3/2019 Patching 11
25/37
AuthorA.Kishore/Sachin
http://appsdba.info
25
-
8/3/2019 Patching 11
26/37
AuthorA.Kishore/Sachin
http://appsdba.info
26
-
8/3/2019 Patching 11
27/37
AuthorA.Kishore/Sachin
http://appsdba.info
27
-
8/3/2019 Patching 11
28/37
AuthorA.Kishore/Sachin
http://appsdba.info
28
Now status showing all application services are up, we can now
access oracle apps.
-
8/3/2019 Patching 11
29/37
AuthorA.Kishore/Sachin
http://appsdba.info
29
Verify Oracle Apps After PatchingLogin as sysadmin as shown below
Click on System Administrator as shown below
-
8/3/2019 Patching 11
30/37
AuthorA.Kishore/Sachin
http://appsdba.info
30
-
8/3/2019 Patching 11
31/37
AuthorA.Kishore/Sachin
http://appsdba.info
31
Click on Concurrent : Manager -> Administer
Above screen showing Internal Manager is up.
-
8/3/2019 Patching 11
32/37
AuthorA.Kishore/Sachin
http://appsdba.info
32
Now We need to run a request to verify that Internal Managers are working.
Click on Concurrent -> Request as shown below
-
8/3/2019 Patching 11
33/37
AuthorA.Kishore/Sachin
http://appsdba.info
33
Below Screen wil be displayed, Select the request button to select the request
Active Users.
-
8/3/2019 Patching 11
34/37
AuthorA.Kishore/Sachin
http://appsdba.info
34
Search for Active Users Request and click on Find button as shown below
-
8/3/2019 Patching 11
35/37
AuthorA.Kishore/Sachin
http://appsdba.info
35
Select Active Users Request ,as shown below and click on OK button
Click on Submit button as shown below
-
8/3/2019 Patching 11
36/37
AuthorA.Kishore/Sachin
http://appsdba.info
36
Click on OK button to Continue
Below Screen will appear and click on Refresh Button
-
8/3/2019 Patching 11
37/37
AuthorA.Kishore/Sachin
http://appsdba.info
Now Request is completed, click the View Output button to check the output
of the request
We checked that Internal Managers are up and working well.