Tuesday, September 18, 2012

Oracle Version Displayed After Running opatch

Some of the print on this post is quite small so you may need to use your browser's zoom button to read it. I downloaded and installed Oracle 11.2.0.2. Then I downloaded and installed patch 13923804 to upgrade the Oracle home to 11.2.0.2.7. It included patch 13696224 (Oracle 11.2.0.2.6). I saw the following error in the opatch log:

[17-Sep-2012 17:08:25]       OUI-67215:
                             OPatch found the word "warning" in the stderr of the make command.
                             Please look at this stderr. You can re-run this make command.
                             Stderr output:
                             ld: warning: symbol `_start' has differing types:
                                (file /oracle/app/oracle/product/11.2.0.2.7/lib/prod/lib/v9/crt1.o type=FUNC; file /oracle/app/oracle/product/11.2.0.2.7/lib//libserver11.a(skds.o) type=OBJT);

According to article ID 1457270.1:

This warning message can be ignored, Oracle has sorted out this issue and future releases will include the fix.

After I had finished, SQL*Plus still displayed the old version number:

ORCL /oracle/app/oracle/product/11.2.0.2.7 > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 18 12:34:17 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

I raised this with Oracle. They referred me to article ID 861152.1, which states that patchset updates do not change the Oracle version number’s fifth digit. Instead, you should check that your opatch version is appropriate (this depends on which version of Oracle you are using):

ORCL /oracle/app/oracle/product/11.2.0.2.7/OPatch > ./opatch version
OPatch Version: 11.2.0.3.0

OPatch succeeded.
ORCL /oracle/app/oracle/product/11.2.0.2.7/OPatch >

Then you can check that patch set updates have been correctly installed as follows:

ORCL /oracle/app/oracle/product/11.2.0.2.7/OPatch > ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /oracle/app/oracle/product/11.2.0.2.7
Central Inventory : /oracle/app/oracle/oraInventory
   from           : /oracle/app/oracle/product/11.2.0.2.7/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.2.0
Log file location : /oracle/app/oracle/product/11.2.0.2.7/cfgtoollogs/opatch/opatch2012-09-18_12-52-06PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0.2.7/cfgtoollogs/opatch/lsinv/lsinventory2012-09-18_12-52-06PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  13923804     : applied on Mon Sep 17 17:06:58 BST 2012
Unique Patch ID:  14966057
Patch description:  "Database Patch Set Update : 11.2.0.2.7 (13923804)"
   Created on 19 Jun 2012, 05:21:56 hrs PST8PDT
Sub-patch  13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"
   Bugs fixed:
     10378005, 10115630, 9835264, 10422126, 10373381, 11818335, 10281887
     10035737, 11707302, 12737666, 11065646, 13769501, 12639234, 10317487
     12586488, 13386082, 10630870, 10151017, 9727147, 10322959, 12586495
     12880299, 9715581, 10245086, 10218814, 10332111, 10205230, 10158965
     11937253, 11733179, 10367188, 9829397, 12830339, 10278773, 14107387
     9651350, 11882425, 11683713, 12586489, 10419629, 12586494, 12337012
     14107388, 10097711, 10388660, 12950644, 9788588, 10113990, 12370722
     10239480, 12586491, 6523037, 9842573, 10417716, 9414040, 12879027
     11724916, 12586492, 10200404, 10232083, 13769503, 9578670, 12685431
     9881076, 10399808, 10285022, 11877623, 10248523, 10157402, 9709292
     12586493, 11830778, 9972680, 10207092, 10092858, 12586490, 12546006
     11800170, 9683047, 12797765, 12391602, 10417216, 10635701, 12586487
     11830777, 13769509, 10055063, 9869401, 10157249, 10131867, 10648873
     10419984, 10077191, 11063191, 13632725, 9970255, 10220033, 13468884
     11830776, 11858315, 11061775, 10633840, 12976376, 11695333, 11708510
     10127360, 10396041, 10190642, 10233732, 10200390, 10142909, 10209232
     10237773, 12366627, 11664046, 10019218, 12569737, 11666137, 10061015
     14107389, 13001379, 9672816, 11695416, 13099577, 9744252, 10222719
     9873405, 9858539, 10620808, 11694127, 9819805, 11872103, 10165083
     10193846, 13769502, 11894889, 10285394, 12827726, 9375300, 9382956
     10204358, 14040433, 11723722, 10264696, 10264680, 13769508, 11842991
     10080579, 11738259, 10084145, 9436324, 10358019, 10089333, 10363186
     12670165, 14038791, 10324294, 14107384, 10158493, 10013177, 10155605
     13343424, 8672862, 10013431, 9956713, 12586496, 11674485, 13476583
     12639177, 11853815, 10126822, 10180307, 10284570, 10048701, 10329146
    12828071, 10079168, 12423475, 10326338, 11064851, 13923804, 12655433
     10314582, 9771278, 10356782, 10051315, 12326246, 14127510, 10332589
     13769506, 10368698, 10229719, 12340939, 9966609, 12586486, 9724970
     11651810, 13769507, 11815753, 9905049, 9078442, 10053725, 10229886
     10137324, 13769504, 10219576, 12378147, 9735237, 9869287, 10217802
     10142788, 12846268, 10129643, 12539000, 12400751, 11724984, 10022980
     9735282, 13503598, 10040921, 11695285, 12595730, 9591812, 13343244
     9906422, 12371955, 12633340, 9746210, 13257247, 10039731, 12917230
     9770451, 10021022, 12846269, 11674898, 10110863, 13769505, 12579349
     11067567, 10411618, 11699057, 10425676, 13916709, 9824435, 12635537
     6892311, 11841309, 10031806, 11707699, 9895207, 11076894, 11890804
     10170431, 10018789, 10299224, 12748240, 9965655, 12323180, 11800854
     11866952, 12531263, 10636231, 10384285, 10219583, 11069199, 12417369
     9539440, 12419331, 11689702, 10324526, 10427260, 12543639, 13696224
     10622001, 14107385, 10227288, 11867127, 11814891, 10258337, 11690639
     9847634, 9285259, 10621169, 10284838, 10159846, 10142857, 10082277
     10187168, 10269503, 11785390, 10310299, 12596444, 10412247, 9564886
     12431716, 14107386, 10102506, 11785938, 10238786, 10132870, 11827088
     10302581, 12569482, 10278372, 12397410, 9953542, 9795214, 9707965
     9443361, 10126094, 10073683, 9572787, 11811073, 10230571, 12419321
     12656535, 10312847, 11800959, 9943960, 13769510, 10052141, 12408350
     10052956, 10040531, 9903826, 11056082, 10040035, 10026601, 12620422
     8685446, 8223165, 9401552, 10094823, 12780098, 11716621, 12589039
     10228151, 10623249, 11893621, 10249791, 10356513, 12345717, 11788856
     11057263, 11664719, 9748749, 11670161, 13554409, 11924400, 11889177, 10094201



--------------------------------------------------------------------------------

OPatch succeeded.
ORCL /oracle/app/oracle/product/11.2.0.2.7/OPatch >

This post has described one of my experiences with opatch. If you need to go into this in more detail, there is a whole chapter about it in the book advertised below:



The image below shows the contents of Chapter 13 of this book. As usual, click on it to enlarge it and bring it into focus:


No comments: