Difference between revisions of "Applying patches"
From dbawiki
| Line 78: | Line 78: | ||
</pre> | </pre> | ||
| − | + | [https://updates.oracle.com/Orion/Services/download?type=readme&aru=15798633 README] | |
| + | |||
| + | |||
| + | ===Opatch=== | ||
| + | As Oracle software owner:<br /> | ||
| + | <pre> | ||
| + | export ORACLE_BASE=/oracle/product | ||
| + | export PATH=$ORACLE_HOME/OPatch/bin:$PATH | ||
| + | </pre> | ||
| + | Get the patch zip file and unzip it to the OPatch directory | ||
| + | <pre> | ||
| + | cd /oracle/stage/112_64/11203 | ||
| + | oracle@solax042:/oracle/stage/112_64/11203> ll | ||
| + | total 15232 | ||
| + | drwxr-xr-x 12 oracle dba 1024 May 04 00:49 . | ||
| + | drwxrwxr-x 11 oracle dba 1024 Jun 25 17:38 .. | ||
| + | drwxr-xr-x 4 oracle oinstall 512 Jan 13 2012 13443029 | ||
| + | drwxr-xr-x 4 oracle oinstall 512 May 21 2012 13947840 | ||
| + | drwxrwxr-x 29 oracle oinstall 1024 Dec 27 2012 14841409 | ||
| + | drwxrwxr-x 33 oracle oinstall 1024 Mar 20 08:52 16294378 | ||
| + | oracle@solax042:/oracle/stage/112_64/11203> cp -rp 16294378 $ORACLE_HOME/OPatch | ||
| + | oracle@solax042:/oracle/stage/112_64/11203> cd $ORACLE_HOME/OPatch | ||
| + | </pre> | ||
| + | Test the patch installation | ||
| + | <pre> | ||
| + | oracle@solax042:/oracle/product/11.2.0.3/OPatch> cd 16294378 | ||
| + | oracle@solax042:/oracle/product/11.2.0.3/OPatch/16294378> opatch napply -skip_subset -skip_duplicate -report -invPtrLoc $ORACLE_BASE/oraInst.loc | ||
| + | Invoking OPatch 11.2.0.1.7 | ||
| + | ... | ||
| + | </pre> | ||
| + | Install the patch for real | ||
| + | <pre> | ||
| + | oracle@solax042:/oracle/product/11.2.0.3/OPatch/16294378> opatch napply -skip_subset -skip_duplicate -invPtrLoc $ORACLE_BASE/oraInst.loc | ||
| + | </pre> | ||
Revision as of 15:56, 12 July 2013
Read the Document concerning the latest patch set release. Eg:
Scan down the document and find the database version...
Table 11 Patch Availability for Oracle Database 11.2.0.3 Product Home Patch Advisory Number Comments Oracle Database home [[https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=14841409 Database 11.2.0.3 SPU Patch 14841409]], or Database 11.2.0.3.5 PSU Patch 14727310, or GI 11.2.0.3.5 PSU Patch 14727347, or Quarterly Database patch for Exadata - January 2013 11.2.0.3.14 BP Patch 15835102, or Quarterly Full Stack download for Exadata (January 2013) BP Patch 16038715, or Microsoft Windows (32-Bit) BP 15 Patch 16042647, or later Microsoft Windows x64 (64-Bit) BP 15 Patch 16042648, or later CVE-2012-3219, CVE-2012-3220, CVE-2012-5062, CVE-2013-0352, CVE-2013-0353, CVE-2013-0354, CVE-2013-0355, CVE-2013-0358, CVE-2013-0372, CVE-2013-0373, CVE-2013-0374 Oracle Database home CPU Patch 13705478 Released April 2012 OC4J 10.1.3.4 one-off patch (Special OPatch needed, see README)
After choosing the correct platform on the right hand side, click and read the README
Patch Details Add Patch to Favorites Patch 14841409: DATABASE SECURITY PATCH UPDATE 11.2.0.3.0 (CPUJAN2013) Last Updated Jan 14, 2013 1:25 PM (17 days ago) Product Oracle Database Family Release Oracle 11.2.0.3.0 Platform IBM AIX on POWER Systems (64-bit) Size 3.5 MB Download Access Software Classification Security Patch Tag All Database
Release 11.2.0.3.0 Platform Language American English Download Add to Plan
Opatch
As Oracle software owner:
export ORACLE_BASE=/oracle/product export PATH=$ORACLE_HOME/OPatch/bin:$PATH
Get the patch zip file and unzip it to the OPatch directory
cd /oracle/stage/112_64/11203 oracle@solax042:/oracle/stage/112_64/11203> ll total 15232 drwxr-xr-x 12 oracle dba 1024 May 04 00:49 . drwxrwxr-x 11 oracle dba 1024 Jun 25 17:38 .. drwxr-xr-x 4 oracle oinstall 512 Jan 13 2012 13443029 drwxr-xr-x 4 oracle oinstall 512 May 21 2012 13947840 drwxrwxr-x 29 oracle oinstall 1024 Dec 27 2012 14841409 drwxrwxr-x 33 oracle oinstall 1024 Mar 20 08:52 16294378 oracle@solax042:/oracle/stage/112_64/11203> cp -rp 16294378 $ORACLE_HOME/OPatch oracle@solax042:/oracle/stage/112_64/11203> cd $ORACLE_HOME/OPatch
Test the patch installation
oracle@solax042:/oracle/product/11.2.0.3/OPatch> cd 16294378 oracle@solax042:/oracle/product/11.2.0.3/OPatch/16294378> opatch napply -skip_subset -skip_duplicate -report -invPtrLoc $ORACLE_BASE/oraInst.loc Invoking OPatch 11.2.0.1.7 ...
Install the patch for real
oracle@solax042:/oracle/product/11.2.0.3/OPatch/16294378> opatch napply -skip_subset -skip_duplicate -invPtrLoc $ORACLE_BASE/oraInst.loc
