DBA Hub

📋Steps in this guide1/2

Steps for applying jdk patch on  standalone database:

In this below example we will show how to apply the jdk patch on both oracle db home and grid_home. download the patch from metalink -584628.1

oracle configurationintermediate
by OracleDba
14 views
1

Steps for applying jdk patch on  standalone database:

For standalone database, we need to apply only to the database_home i.e is the rdbms home. 1. Check the existing jdk version: 2. Shutdown database 3. unzip the patch: 4. Apply the patch: > Note –  > Please ensure that latest opatch utility installed. Note –  > Please ensure that latest opatch utility installed. 5. Start the database: 6. Now check the jdk version again: We can see JDK has version has been change from 1.8.0_271 to 1.8.0_281

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
[oracle@dbhost-1 bin]$ /u01/app/oracle/product/12.2/dbhome_1/jdk/bin/java -version
java version "<span style="color: #800000;"><strong>1.8.0_271</strong></span>"
Java(TM) SE Runtime Environment (build 1.8.0_271-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.271-b09, mixed mode)

SQL> SHUTDOWN IMMEDIATE;

cd /backup/software/
unzip 32162748_patch.zip
cd 32162748

export ORACLE_HOME=/u01/app/oracle/product/12.2/dbhome_1
cd /backup/software/32162748


[oracle@dbhost-1 32162748]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.2/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2/dbhome_1//oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2/dbhome_1/cfgtoollogs/opatch/opatch2021-03-25_12-57-53PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32162748

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '32162748' to OH '/u01/app/oracle/product/12.2/dbhome_1'

Patching component oracle.jdk, 1.8.0.91.0...
Patch 32162748 successfully applied.
Log file location: /u01/app/oracle/product/12.2/dbhome_1/cfgtoollogs/opatch/opatch2021-03-25_12-57-53PM_1.log

OPatch succeeded.

SQL> startup
ORACLE instance started.

Total System Global Area 1.6267E+11 bytes
Fixed Size                 29864856 bytes
Variable Size            3.4897E+10 bytes
Database Buffers         1.2724E+11 bytes
Redo Buffers              507002880 bytes
Database mounted.
Database opened.
SQL>

[oracle@dbhost-1 32162748]$  /u01/app/oracle/product/12.2/dbhome_1/jdk/bin/java -version
java version "<span style="color: #800000;"><strong>1.8.0_281</strong></span>"
Java(TM) SE Runtime Environment (build 1.8.0_281-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.281-b09, mixed mode)
2

Steps for Applying JDK patch on GRID /RAC database:

In case of RAC database, we need to apply jdk patch on both RDBMS home and GRID home. First we will start with GRID_HOME on node 1: 1. Unlock the crs: [ from root] > NOTE –  > In case of standalone grid , use roothas.sh – prepatch command NOTE –  > In case of standalone grid , use roothas.sh – prepatch command 2. Apply the patch on grid_home: 3. Now lock the CRS: [ from root ] NOTE –  > In case of standalone grid , use roothas.sh – postpatch command 4. Now on RDBMS HOME on node 1: Once both grid_home and rdbms_home patching is done, we need to do the same steps on other node also.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
<span style="color: #800000;"><span style="color: #000000;">[root@dbhost-1]#</span> <strong>cd $GRID_HOME/crs/install</strong></span>
<span style="color: #800000;"><span style="color: #000000;">[root@dbhost-1 install]</span><strong><span style="color: #000000;">#</span> ./rootcrs.sh -prepatch</strong></span>
Using configuration parameter file: /u01/app/12.2/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/dbhost-1/crsconfig/crspatch_2021-03-25_01-02-53PM.log
2021/03/25 13:03:14 CLSRSC-347: Successfully unlock /u01/app/12.2/grid

[oracle@dbhost-1 32162748]$ cd /backup/software/32162748
[oracle@dbhost-1 32162748]$
[oracle@dbhost-1 32162748]$ <span style="color: #800000;"><strong>$ORACLE_HOME/OPatch/opatch apply</strong></span>
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.2/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.2/grid/oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.1.4
Log file location : /u01/app/12.2/grid/cfgtoollogs/opatch/opatch2021-03-25_13-04-13PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32162748

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '32162748' to OH '/u01/app/12.2/grid'

Patching component oracle.jdk, 1.8.0.91.0...
Patch 32162748 successfully applied.
Log file location: /u01/app/12.2/grid/cfgtoollogs/opatch/opatch2021-03-25_13-04-13PM_1.log

OPatch succeeded.

<span style="color: #800000;"><span style="color: #000000;">[root@dbhost-1]#</span><strong> cd $GRID_HOME/crs/install</strong></span>
[root@dbhost-1 install]# <span style="color: #800000;"><strong>./rootcrs.sh -postpatch</strong></span>
Using configuration parameter file: /u01/app/12.2/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/dbhost-1/crsconfig/crspatch_2021-03-25_01-04-55PM.log
2021/03/25 13:04:57 CLSRSC-329: Replacing Clusterware entries in file '.....'

SQL>shutdown immediate
SQL> exit


export ORACLE_HOME=/u01/app/oracle/product/12.2/dbhome_1
cd /backup/software/32162748


[oracle@dbhost-1 32162748]$ <span style="color: #800000;"><strong>$ORACLE_HOME/OPatch/opatch apply</strong></span>
Oracle Interim Patch Installer version 12.2.0.1.23
Copyright (c) 2021, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.2/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2/dbhome_1//oraInst.loc
OPatch version    : 12.2.0.1.23
OUI version       : 12.2.0.1.4
Log file location : /u01/app/oracle/product/12.2/dbhome_1/cfgtoollogs/opatch/opatch2021-03-25_12-57-53PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   32162748

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '32162748' to OH '/u01/app/oracle/product/12.2/dbhome_1'

Patching component oracle.jdk, 1.8.0.91.0...
Patch 32162748 successfully applied.
Log file location: /u01/app/oracle/product/12.2/dbhome_1/cfgtoollogs/opatch/opatch2021-03-25_12-57-53PM_1.log

OPatch succeeded.


SQL> startup
ORACLE instance started.

Total System Global Area 1.6267E+11 bytes
Fixed Size                 29864856 bytes
Variable Size            3.4897E+10 bytes
Database Buffers         1.2724E+11 bytes
Redo Buffers              507002880 bytes
Database mounted.
Database opened.
SQL>

Comments (0)

Please to add comments

No comments yet. Be the first to comment!