Applying Patch Set Update 11.2.0.3.3 to 11.2.0.3.0 on linux x86-64

Pentru a instala Patch Set Update-ul 11.2.0.3.3 este nevoie ca Oracle Home sa aibă instalată Oracle 11.2.0.3.0 (sau 11.2.0.3.2, 11.2.0.3.1) iar versiunea utilitarului OPatch sa fie minim 11.2.0.3.0.

Dacă condițiile de mai sus (ori cel puțin prima) sunt îndeplinite atunci putem începe:

Oracle recomanda ca întotdeauna  să utilizam ultima versiune a utilitarul OPatch, la ora la care scriu eu acest articol cea mai recenta versiune este 11.2.0.3.0. Pentru a o instala ne logam pe support.oracle.com cu credenţialele noastre si descarcam patch-ul 6880880. Pentru PSU-ul de 11.2.0.3.3 pentru Linux x64 descarcam 13923374.

Dupa ce le-am descarcam, le dezarhivam ca în exemplu de mai jos:

[oracle@OracleVM PSU]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@OracleVM PSU]$ unzip p13923374_112030_Linux-x86-64.zip

Oprim toate serviciile Oracle cu ajutorul scriptului de aici:

[root@OracleVM ~]# service dbora stop

Copiem noua versiune de OPatch fără a șterge versiunea veche:

[oracle@OracleVM PSU]$ mv $ORACLE_HOME/OPatch/ $ORACLE_HOME/OPatchOld

[oracle@OracleVM PSU]$ mv OPatch/ $ORACLE_HOME

După ce ne asiguram că variabila de sistem $ORACLE_HOME este setată, verificăm dacă mai exista și alte patch-uri instalate:

[oracle@OracleVM PSU]$ cd $ORACLE_HOME/OPatch/
[oracle@OracleVM OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-11-20_15-55-18PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-11-20_15-55-18PM.txt

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

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

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

Verificam dacă există conflicte între patch-urile care urmează să fie aplicate:

[oracle@OracleVM OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /u01/PSU/13923374/
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-11-20_15-58-45PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

Dacă nu există conflicte putem începe aplicarea patch-urilor:

[oracle@OracleVM OPatch]$ ./opatch apply /u01/PSU/13923374/
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-11-20_16-00-13PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374

Do you want to proceed? [y|n]
Y
[...]

Verifying the update...
Composite patch 13923374 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-11-20_16-00-13PM_1.log

OPatch succeeded.

După aplicarea de patch-uri, trebuie să încărcați fișierele modificate SQL în baza de date:

[oracle@OracleVM OPatch]$ cd $ORACLE_HOME/rdbms/admin
[oracle@OracleVM admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 20 16:06:04 2012

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  417546240 bytes
Fixed Size                  2228944 bytes
Variable Size             301993264 bytes
Database Buffers          109051904 bytes
Redo Buffers                4272128 bytes
Database mounted.
Database opened.
SQL> @catbundle.sql psu apply

[...]

Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2012Nov20_16_06_50.log
SQL> quit
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

Verificați log-ul menționat mai sus, iar în cazul în care exista erori contactați Oracle Support.

Dacă folosiți Oracle Recovery Manager Catalog mai trebuie sa rulat:

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

Verificam repository-ul OPatch

[oracle@OracleVM rdbms]$ cd $ORACLE_HOME/OPatch
[oracle@OracleVM OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-11-20_16-23-30PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-11-20_16-23-30PM.txt

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

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

Interim patches (1) :

Patch  13923374     : applied on Tue Nov 20 16:03:25 EET 2012
Unique Patch ID:  14847207
Patch description:  "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Created on 13 Jun 2012, 00:02:44 hrs PST8PDT
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)"
Bugs fixed:
13419660, 10350832, 13632717, 14063281, 12919564, 13467683, 13588248
13420224, 12646784, 12861463, 12834027, 13036331, 12880299, 13499128
12998795, 13492735, 12829021, 13503598, 10133521, 12718090, 13742433
12905058, 12401111, 13742434, 12849688, 13362079, 12950644, 13742435
12917230, 13923374, 12879027, 12535346, 12588744, 11877623, 13916709
12847466, 13340388, 13528551, 13366202, 12894807, 13981051, 13343438
12582664, 12748240, 12797765, 12923168, 13466801, 13772618, 11063191
13070939, 13035804, 12797420, 13041324, 12976376, 13742437, 14062795
13035360, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 13370330, 14062797, 13742436, 9873405, 14062794, 9858539
12960925, 12662040, 9703627, 12617123, 13338048, 12938841, 12658411
12620823, 12656535, 12845115, 14062793, 12764337, 12678920, 13354082
14062792, 12612118, 9761357, 13742464, 13457582, 13527323, 12780983
12780098, 13502183, 13696216, 11840910, 13903046, 13554409, 13657605
13103913, 14063280

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

OPatch succeeded.

Dacă log-ul nu conține nici o eroare atunci putem considera instalarea finalizată cu succes.