Patching the oracle

[Former Member]

Hello! I am trying to patch oracle 11.2.0.3.0 with opatch.

I downloaded 2 files - OPATCHP_5-20010497.ZIP and SAP11203P_1411-20009981.ZIP.

Also I unziped OPATCHP_5-20010497.ZIP into old 11203/OPatch.

What I should do with SAP11203P_1411-20009981.ZIP to install all patches from this archive instead of using

/opatch apply </OPatch/SBP_1120312_201411/19493736/13923374/> for each bugfix ? There is so many bugfixes:

19493736/    9458152/     9584028/     9656644/     MOPatch/     OPatch/      README.html*

and into 19493736/ :

13343438  13696216  13923374  14275605  14727310  16056266  16619892  16902043  17540582  18523757  18878603  19493736  README.html

MODERATOR: Next time take time to read the README.html file that comes with the bundle patch.

[ACE-SAP · Accepted solution]

Hi

You need to update both MOpatch & Opatch

unzip /tmp/Ora_Patch/OPATCHP_1-20010777.ZIP -d /oracle/<SID>/112_64

unzip /tmp/Ora_Patch/MOPATCHP_1-20010777.ZIP -d /oracle/<SID>/112_64

Then you can apply the bundle patch

$ORACLE_HOME/MOPatch/mopatch.sh -v -s /tmp/Ora_Patch/SAP11204P_1402-20010778.ZIP

Regards

1631931 - Oracle 11.2.0: Patches / Patch collections for 11.2.0.3

1027012 - MOPatch - Install Multiple Oracle Patches in One Run

[Former Member · Accepted solution]

Oh thanks Yves ! I patched oracle completely with your help !

[Former Member · Accepted solution]

But I see that the version of Oracle still 11.2.0.3.0 in sap gui > system > status

[ACE-SAP · Accepted solution]

Watch out, system status is not the best place for checking Oracle version and patch

You should instead check in DB02 (performance / Add functions / Bundle patches)

or at OS level => $ORACLE_HOME/OPatch/opatch lsinventory -all | grep "Patch Set"

[former_member207186 · Accepted solution]

Hi,

Please do not forget to perform the post installation steps described in the README. Please also refer to SAP note #1696147 - "How to determine the list of Oracle patches or SAP Bundle Patches (SBP) that are installed in SAP system".

Regards,

Bíborka

[Reagan · Accepted solution]

Igor Kostylev wrote:

But I see that the version of Oracle still 11.2.0.3.0 in sap gui > system > status 

This will not show you the version of the bundle patch installed on the system.

You need to run $ORACLE_HOME/OPatch/opatch lsinventory as ora<SID> to see that.

Make sure you run the catsbp.sql after installing the SBP package and after that query the dba_registry_history to see the version details.

Cheers

RB

[salome_szanto]

Please perform the post installation steps from the same README then check the dba_registory_history table.

[Former Member]

Hi!

Thats all what I see in README

          MOPatch - Install Multiple Oracle Patches in One Run

          ====================================================

This file is temporarily empty.  It will contain the text of SAP

note 1027012 again in the next MOPatch release.

Please refer to SAP note 1027012 directly for the time being.

[Former Member]

LSINVENTORY:

========================================================

GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY

========================================================

Oracle Interim Patch Installer version 11.2.0.3.7

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/EW1/112_64

Central Inventory : /oracle/oraInventory

   from           : /oracle/EW1/112_64/oraInst.loc

OPatch version    : 11.2.0.3.7

OUI version       : 11.2.0.3.0

Log file location : /oracle/EW1/112_64/cfgtoollogs/opatch/opatch2015-01-30_11-10-50AM_1.log

Lsinventory Output file location : /oracle/EW1/112_64/cfgtoollogs/opatch/lsinv/lsinventory2015-01-30_11-10-50AM.txt

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

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0

There are 1 product(s) installed in this Oracle Home.

Interim patches (4) :

Patch  9458152      : applied on Fri Jan 30 10:01:13 MSK 2015

Patch description:  "SBP 11.2.0.3.12 201411"

   Created on 12 Nov 2014, 12:57:00 hrs CET

   Bugs fixed:

     9458152

Patch  9584028      : applied on Fri Jan 30 10:01:00 MSK 2015

   Created on 3 May 2013, 10:41:07 hrs CEST

   Bugs fixed:

     9584028

Patch  9656644      : applied on Fri Jan 30 10:00:48 MSK 2015

   Created on 6 Jun 2012, 16:19:40 hrs CEST

   Bugs fixed:

     9656644

Patch  19493736     : applied on Fri Jan 30 10:00:24 MSK 2015

Unique Patch ID:  18072743

Patch description:  "SAPDBBP 11.2.0.3.3 BASED ON DATABASE PSU : 11.2.0.3.12 (19121548)"

   Created on 3 Nov 2014, 20:49:04 hrs PST8PDT

Sub-patch  18878603; "SAPDBBP 11.2.0.3.2 BASED ON DATABASE PSU : 11.2.0.3.11 (18522512)"

Sub-patch  18523757; "SAPDBBP 11.2.0.3.1 BASED ON DATABASE PSU : 11.2.0.3.10 (18031683)"

Sub-patch  17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"

Sub-patch  16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"

Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"

Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"

Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"

Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"

Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"

Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"

Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"

[Former Member]

SQL> select * from dba_registry_history;

no rows selected

[Former Member]

results of sqlplus /nolog @/oracle/EW1/11203/sapbundle/SBP_1120312_201411/catsbp.sql

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 30 11:24:05 2015

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

Connected.

SP2-0223: No lines in SQL buffer.

######################################################################

#  The following PL/SQL block will cause an ORA-20000 error and      #

#  terminate the current SQL*Plus session if this script is not      #

#  running as user SYS.                                              #

#                                                                    #

#  If that happens, reconnect as user SYS and restart this script.   #

######################################################################

PL/SQL procedure successfully completed.

######################################################################

#  The following PL/SQL block will cause an ORA-20000 error and      #

#  terminate the current SQL*Plus session if environment variable    #

#  ORACLE_HOME is not set.                                           #

#                                                                    #

#  If that happens, set environment variable ORACLE_HOME and         #

#  restart this script.                                              #

######################################################################

PL/SQL procedure successfully completed.

######################################################################

#  The following SQL*Plus statement will cause an SP2-0310 error     #

#  and terminate the current SQL*Plus session if SQL*Plus is         #

#  executing from a directory other than the Oracle Home.            #

#                                                                    #

#  If that happens, change the current working directory to the      #

#  Oracle Home and restart this script.                              #

######################################################################

SP2-0310: unable to open file "rdbms/admin/nothing.sql"

O/S Message: No such file or directory

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[former_member207186]

Hi,

Please review the SBP readme file and ensure that all post scripts/steps were executed sucessfully (catsbp.sql etc.). Please also refer to SAP notes:

1899453 - "dba_registry_history does not record SBP installed"

1696147 - "How to determine the list of Oracle patches or SAP Bundle Patches (SBP) that are installed in SAP system".

Regards,

Bíborka

[Former Member]

I found the proper readme file and executed

$ cd $OHRDBMS
$ env ORACLE_HOME=$OHRDBMS $OHRDBMS/bin/sqlplus / as sysdba
SQL> @sapbundle/SBP_1120312_201411/catsbp.sql
SQL> quit

Now dba_history contains:

SQL> select * from dba_registry_history;

ACTION_TIME

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

ACTION       NAMESPACE

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

VERSION        ID BUNDLE_SERIES

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

COMMENTS

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

30-JAN-15 12.06.05.930748 PM

APPLY       SERVER

11.2.0.3 3 SAPDBBP

SAPDBBP 11.2.0.3.3 BASED ON PSU 11.2.0.3.12

ACTION_TIME

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

ACTION       NAMESPACE

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

VERSION        ID BUNDLE_SERIES

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

COMMENTS

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

30-JAN-15 12.07.11.274310 PM

APPLY       SERVER

11.2.0.3   201411 SAP

SBP 11.2.0.3.12 201411 containing CPUOct2014

I think it's done now

[former_member182657]

Hi Igor,

Could you check once steps given under README.html file,As per me you'll be able to find necessary steps to patch the existing oracle version.

Regards,

Gaurav