Applying patches - Revision history

Stuart: /* Patching both Grid and database ORACLE_HOMEs at the same time */

2018-11-02T08:39:52Z

‎Patching both Grid and database ORACLE_HOMEs at the same time

2018-11-01T17:29:49Z

‎Patching both Grid and database ORACLE_HOMEs at the same time

2018-10-31T16:13:30Z

2018-10-31T15:16:11Z

2018-10-31T15:15:19Z

2018-10-31T15:11:51Z

2018-10-31T15:11:23Z

2013-07-12T15:58:37Z

‎Opatch

2013-07-12T15:56:31Z

2013-02-01T09:55:16Z

@@ Line 11: / Line 11: @@
 ==Patching both Grid and database ORACLE_HOMEs at the same time==
 *[http://oradbapro.blogspot.com/2015/07/how-to-use-opatch-auto.html how to use opatch auto]
 ===opatch log report===
 Shows the steps involved in patching Grid and database ORACLE_HOMEs in auto mode.

@@ Line 10: / Line 10: @@
 ==Patching both Grid and database ORACLE_HOMEs at the same time==
 ===opatch log report===
 Shows the steps involved in patching Grid and database ORACLE_HOMEs in auto mode.

@@ Line 8: / Line 8: @@
 * If the patch is for a Grid Infrastructure ORACLE_HOME as well as a database ORACLE_HOME, the patch commands must be run as root.<br />
 If only a database ORACLE_HOME is patched, it will be run as the software owner (eg. oracle).<br />
 ===Opatch===

@@ Line 6: / Line 6: @@
 * Click on Download to download the patch.
 * Copy the zip file to a place accessible to the server to be patched. Could be directly to the server, an NFS mount etc.
-* If the patch is for a Grid Infrastructure ORACLE_HOME as well as a database ORACLE_HOME, the patch commands will be run as root. If only a database ORACLE_HOME is patched, it will be run as the software owner (eg. oracle).
+* If the patch is for a Grid Infrastructure ORACLE_HOME as well as a database ORACLE_HOME, the patch commands must be run as root.<br />
 ===Opatch===

@@ Line 6: / Line 6: @@
 * Click on Download to download the patch.
 * Copy the zip file to a place accessible to the server to be patched. Could be directly to the server, an NFS mount etc.
 ===Opatch===

@@ Line 2: / Line 2: @@
 I find it easier to click the "Recommended Patch Advisor" tab and fill in the 3 fields. This will then find all relevant patches.<br />
 <br />
-* After choosing the correct product, release and platform, click on the relevant patch.
+* After choosing the correct product, release and platform, click on the desired patch.
 * Click on and read the README to understand if there are any special circumstances.
 * Click on Download to download the patch.

@@ Line 1: / Line 1: @@
-Read the Document concerning the latest patch set release. Eg:
+* Find the patches on Metalink under the tab [https://support.oracle.com/epmos/faces/PatchHome "Patches & Updates"]
-*[[https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=788335430983062&_afrWindowMode=0&_adf.ctrl-state=1colrpvntu_4 Patch Set Update and Critical Patch Update January 2013 Availability Document [ID 1502461.1 ]]]
+I find it easier to click the "Recommended Patch Advisor" tab and fill in the 3 fields. This will then find all relevant patches.<br />
+<br />
-Scan down the document and find the database version...
+* After choosing the correct product, release and platform, click on the relevant patch.
-<pre>
+* Click on and read the README to understand if there are any special circumstances.
-Table 11 Patch Availability for Oracle Database 11.2.0.3
+* Click on Download to download the patch.
-Product Home	Patch	Advisory Number	Comments
+* Copy the zip file to a place accessible to the server to be patched. Could be directly to the server, an NFS mount etc.
 ===Opatch===

@@ Line 111: / Line 111: @@
 <pre>
 oracle@solax042:/oracle/product/11.2.0.3/OPatch/16294378> opatch napply -skip_subset -skip_duplicate -invPtrLoc $ORACLE_BASE/oraInst.loc
 </pre>

← Older revision		Revision as of 15:56, 12 July 2013
Line 78:		Line 78:

	</pre>		</pre>
−	[[https://updates.oracle.com/Orion/Services/download?type=readme&aru=15798633 README]]	+	[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>

@@ Line 57: / Line 57: @@
 Release	Oracle 11.2.0.3.0
 Platform	IBM AIX on POWER Systems (64-bit)
 Size	3.5 MB
@@ Line 81: / Line 78: @@
 </pre>