Applying CPU JUL 2008 on RAC ( 11.1.0.6 ) ORACLE_HOME

• First you need to have OPatch 11.1.0.6.2 or higher to apply the CPU JUL 2008.You can download OPatch 11.1.0.6.3 from Patch 6880880.

[oracle@quartz Desktop]$ unzip p6880880_111000_Linux-x86-64.zip
Archive: p6880880_111000_Linux-x86-64.zip
creating: OPatch/
creating: OPatch/docs/
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
extracting: OPatch/docs/tmp
creating: OPatch/jlib/
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/opatchutil.jar
inflating: OPatch/jlib/opatchprereq.jar
inflating: OPatch/jlib/opatchactions.jar
creating: OPatch/opatchprereqs/
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
inflating: OPatch/opatchprereqs/prerequisite.properties
inflating: OPatch/opatch
inflating: OPatch/opatch.bat
inflating: OPatch/opatch.pl
inflating: OPatch/opatch.ini
inflating: OPatch/emdpatch.pl
inflating: OPatch/README.txt
creating: OPatch/ocm/
extracting: OPatch/ocm/ocm.zip
creating: OPatch/ocm/doc/
inflating: OPatch/ocm/doc/license.txt
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/emocmutl.jar
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp

• Remove the Old Opatch from $ORACLE_HOME

[oracle@quartz Desktop]$ rm -rf /u01/app/oracle/product/11.1.0/db_2/OPatch/

• Move new OPatch to $ORACLE_HOME

[oracle@quartz Desktop]$ mv OPatch/ $ORACLE_HOME

• Check the OPatch version

[oracle@quartz Desktop]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch version
Invoking OPatch 11.1.0.6.3

OPatch Version: 11.1.0.6.3

OPatch succeeded.

• Check the State of Resources

[oracle@quartz Desktop]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
———————————————————————-
ora….TZ.lsnr application 0/5 0/0 ONLINE ONLINE quartz
ora.quartz.gsd application 0/5 0/0 ONLINE ONLINE quartz
ora.quartz.ons application 0/3 0/0 ONLINE ONLINE quartz
ora.quartz.vip application 0/0 0/0 ONLINE ONLINE quartz

• Stop all application on the node where you are going to apply Patch.

[oracle@quartz Desktop]$ srvctl stop nodeapps -n quartz

• Check once again to make sure state if off line for all resources.

[oracle@quartz Desktop]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
———————————————————————-
ora….TZ.lsnr application 0/5 0/0 OFFLINE OFFLINE
ora.quartz.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.quartz.ons application 0/3 0/0 OFFLINE OFFLINE
ora.quartz.vip application 0/0 0/0 OFFLINE OFFLINE

• Move to directory where you have unzipped CPU JUL patch and apply it.

[oracle@quartz Desktop]$ cd 7150417/

[oracle@quartz 7150417]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch napply -skip_subset -skip_duplicate -local
Invoking OPatch 11.1.0.6.3

Oracle Interim Patch Installer version 11.1.0.6.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.

UTIL session

Oracle Home : /u01/app/oracle/product/11.1.0/db_2
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.3
OUI version : 11.1.0.6.0
OUI location : /u01/app/oracle/product/11.1.0/db_2/oui
Log file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/opatch2008-09-11_14-07-43PM.log

Invoking utility “napply”
Checking conflict among patches…
Checking if Oracle Home has components required by patches…
Skip patch 7155439 from list of patches to apply: This patch is not needed.
Checking skip_duplicate
Checking skip_subset
Checking conflicts against Oracle Home…
OPatch continues with these patches: 6650132 6650135 6731395 6871274 6871276 7150417 7155429 7155447 7155449 7155452 7155459 7155461 7155463 7155464 7158307

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks…

You selected -local option, hence OPatch will patch the local system only.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/11.1.0/db_2′)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch ‘NApply’ for restore. This might take a while…

***************************************************************************
Oracle Configuration Manager (OCM) is included with this release of OPatch.
***************************************************************************

The Oracle Configuration Manager is installed previously in the Oracle Home.

Removing previously installed Oracle Configuration Manager from the Oracle Home…
Uninstalling Oracle Configuration Manager…

OPatch will now install the Oracle Configuration Manager in the Oracle Home.

OPatch has successfully installed Oracle Configuration Manager in the Oracle Home.
Please refer log file for details.

OPatch will now configure the Oracle Configuration Manager in the Oracle Home.

Configuring Oracle Configuration Manager. This may take a while…

Oracle Configuration Manager enables Oracle to provide superior, proactive
support for our customers. Oracle strongly recommends customers configure OCM.

ORACLE CONNECTION TOOLS AGREEMENT
Introduction
————
Customer (hereafter “Customer” or “you”) agrees to the following conditions
regarding the use of Oracle’s live connection tools, including Oracle
Configuration Manager and Remote Diagnostic Agent, that you have either
downloaded from Oracle’s technical support web site or which you received from
Oracle, and the related services that Oracle provides in connection with those
tools (collectively, the “Tools”). The individual entering into this
agreement certifies that he/she has authority to enter into this agreement on
Customer’s behalf.
These terms supplement the terms of your licensing or distribution agreement
with Oracle and the terms of Oracle’s Technical Support Policies. In the
event of a conflict between your licensing or distribution agreement or the
Technical Support Policies and the following terms, the relevant terms below
will control your use of the Tools.
Description of Tools: What Data is Collected and How it is Stored and Used
————

[Press enter to continue, 'q' to stop displaying the license agreement.] q

I accept the License Agreement (Y/N) [Y]: n

OPatch failed to configure Oracle Configuration Manager in the Oracle Home. Please refer log file
for details.

*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************

Execution of ’sh /home/oracle/Desktop/7150417/6731395/custom/scripts/pre -apply 6731395 ‘:

Return Code = 0
Execution of ’sh /home/oracle/Desktop/7150417/7150417/custom/scripts/pre -apply 7150417 ‘:

Return Code = 0

Applying patch 6650132…

ApplySession applying interim patch ‘6650132′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6650132′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzia.o”
ApplySession adding interim patch ‘6650132′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6650132 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6650132 are present in Oracle Home.

Applying patch 6650135…

ApplySession applying interim patch ‘6650135′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6650135′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzsr.o”
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kzu.o”
ApplySession adding interim patch ‘6650135′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6650135 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6650135 are present in Oracle Home.

Applying patch 6731395…

ApplySession applying interim patch ‘6731395′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6731395′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/view_recompile/recompile_precheck_jan2008cpu.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/view_recompile/view_recompile_jan2008cpu.sql”
ApplySession adding interim patch ‘6731395′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6731395 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6731395 are present in Oracle Home.

Applying patch 6871274…

ApplySession applying interim patch ‘6871274′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6871274′ for rollback. This might take a while…

Patching component oracle.sdo.locator, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/md/admin/prvtpidx.plb”
ApplySession adding interim patch ‘6871274′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6871274 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6871274 are present in Oracle Home.

Applying patch 6871276…

ApplySession applying interim patch ‘6871276′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘6871276′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/rdbms/jlib/CDC.jar” with “/rdbms/jlib/CDC.jar/oracle/CDC/AdvanceChangeSet.class”
ApplySession adding interim patch ‘6871276′ to inventory

Verifying the update…
Inventory check OK: Patch ID 6871276 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 6871276 are present in Oracle Home.

Applying patch 7150417…

ApplySession applying interim patch ‘7150417′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7150417′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/catcpu.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/catcpu_rollback.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/rollback_all.lst”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/CPUJul2008/rollback_new.lst”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/bundledata_CPU.xml”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/catbundle.sql”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/cpu/scripts/sdo_jul2008.sql”
ApplySession adding interim patch ‘7150417′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7150417 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7150417 are present in Oracle Home.

Applying patch 7155429…

ApplySession applying interim patch ‘7155429′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155429′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/lib/env_rdbms.mk”
ApplySession adding interim patch ‘7155429′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155429 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155429 are present in Oracle Home.

Applying patch 7155447…

ApplySession applying interim patch ‘7155447′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155447′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/prvtdefr.plb”
ApplySession adding interim patch ‘7155447′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155447 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155447 are present in Oracle Home.

Applying patch 7155449…

ApplySession applying interim patch ‘7155449′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155449′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kupp.o”
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/prvtbpp.plb”
ApplySession adding interim patch ‘7155449′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155449 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155449 are present in Oracle Home.

Applying patch 7155452…

ApplySession applying interim patch ‘7155452′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155452′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Copying file to “/u01/app/oracle/product/11.1.0/db_2/rdbms/admin/catdef.sql”
ApplySession adding interim patch ‘7155452′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155452 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155452 are present in Oracle Home.

Applying patch 7155459…

ApplySession applying interim patch ‘7155459′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155459′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/ctc.o”
ApplySession adding interim patch ‘7155459′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155459 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155459 are present in Oracle Home.

Applying patch 7155461…

ApplySession applying interim patch ‘7155461′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155461′ for rollback. This might take a while…

Patching component oracle.rdbms, 11.1.0.6.0…
Updating archive file “/u01/app/oracle/product/11.1.0/db_2/lib/libserver11.a” with “lib/libserver11.a/kwqn.o”
ApplySession adding interim patch ‘7155461′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155461 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155461 are present in Oracle Home.

Applying patch 7155463…

ApplySession applying interim patch ‘7155463′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155463′ for rollback. This might take a while…

Patching component oracle.sdo.locator, 11.1.0.6.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$AlongEdgeComparator.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$AlongSegmentComparator.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$EdgeSplit.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$Int.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$PointStackEntry.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/md/jlib/sdotopo.jar” with “/md/jlib/sdotopo.jar/oracle/spatial/topo/TopoMap$SmartPoint.class”
ApplySession adding interim patch ‘7155463′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155463 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155463 are present in Oracle Home.

Applying patch 7155464…

ApplySession applying interim patch ‘7155464′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7155464′ for rollback. This might take a while…

Patching component oracle.sysman.plugin.db.main.oms, 11.1.0.5.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsg.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsgID.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/rsrcmgr/RsrcmgrMonController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emdb_emjsp.jar” with “/sysman/jlib/emdb_emjsp.jar/_database/_instance/_sitemap/_healthgif.class”
ApplySession adding interim patch ‘7155464′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7155464 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155464 are present in Oracle Home.

Applying patch 7158307…

ApplySession applying interim patch ‘7158307′ to OH ‘/u01/app/oracle/product/11.1.0/db_2′
Backing up files affected by the patch ‘7158307′ for rollback. This might take a while…

Patching component oracle.sysman.plugin.db.main.oms, 11.1.0.5.0…
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/MemoryController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SessionDetailsController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SitemapController.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emDB.jar” with “/sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/sesn/SessionDetails.class”
Updating jar file “/u01/app/oracle/product/11.1.0/db_2/sysman/jlib/emdb_emjsp.jar” with “/sysman/jlib/emdb_emjsp.jar/_database/_instance/_sitemap/_health.class”
ApplySession adding interim patch ‘7158307′ to inventory

Verifying the update…
Inventory check OK: Patch ID 7158307 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7158307 are present in Oracle Home.
Running make for target ioracle
Running make for target iextjob
Running make for target iextjobo

——————————————————————————–
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

——————————————————————————–

Execution of ’sh /home/oracle/Desktop/7150417/7150417/custom/scripts/post -apply 7150417 ‘:

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.
——————————————————————————–
The following warnings have occurred during OPatch execution:
1) OUI-67293:
OPatch failed to configure Oracle Configuration Manager in the Oracle Home. Please refer log file
for details.

2) OUI-67294:
*******************************************************************************************
Oracle Configuration Manager is installed but not configured. OCM enables Oracle to
provide superior, proactive support for our customers. Oracle strongly recommends customers
configure OCM. To complete the configuration of OCM, refer to the OCM Installation and
Administration Guide (http://www.oracle.com/technology/documentation/ocm.html).
*******************************************************************************************

——————————————————————————–
OPatch Session completed with warnings.

OPatch completed with warnings.

• Check whether patch has been applied and registered in inventory or not.

[oracle@quartz 7150417]$ /u01/app/oracle/product/11.1.0/db_2/OPatch/opatch lsinv
Invoking OPatch 11.1.0.6.3

Oracle Interim Patch Installer version 11.1.0.6.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.1.0/db_2
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.1.0.6.3
OUI version : 11.1.0.6.0
OUI location : /u01/app/oracle/product/11.1.0/db_2/oui
Log file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/opatch2008-09-11_14-26-45PM.log

Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_2/cfgtoollogs/opatch/lsinv/lsinventory2008-09-11_14-26-45PM.txt

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

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

Interim patches (15) :

Patch 7158307 : applied on Thu Sep 11 14:15:18 BST 2008
Created on 22 Jun 2008, 01:14:25 hrs PST8PDT
Bugs fixed:
7158307

Patch 7155464 : applied on Thu Sep 11 14:14:03 BST 2008
Created on 22 Jun 2008, 01:14:05 hrs PST8PDT
Bugs fixed:
7155464

Patch 7155463 : applied on Thu Sep 11 14:13:02 BST 2008
Created on 22 Jun 2008, 01:13:43 hrs PST8PDT
Bugs fixed:
7155463

Patch 7155461 : applied on Thu Sep 11 14:12:54 BST 2008
Created on 22 Jun 2008, 01:13:22 hrs PST8PDT
Bugs fixed:
7155461

Patch 7155459 : applied on Thu Sep 11 14:12:28 BST 2008
Created on 22 Jun 2008, 01:12:56 hrs PST8PDT
Bugs fixed:
7155459

Patch 7155452 : applied on Thu Sep 11 14:12:11 BST 2008
Created on 22 Jun 2008, 01:09:57 hrs PST8PDT
Bugs fixed:
7155452

Patch 7155449 : applied on Thu Sep 11 14:12:06 BST 2008
Created on 22 Jun 2008, 01:09:32 hrs PST8PDT
Bugs fixed:
7155449

Patch 7155447 : applied on Thu Sep 11 14:11:47 BST 2008
Created on 22 Jun 2008, 01:02:51 hrs PST8PDT
Bugs fixed:
7155447

Patch 7155429 : applied on Thu Sep 11 14:11:45 BST 2008
Created on 22 Jun 2008, 00:59:22 hrs PST8PDT
Bugs fixed:
7155429

Patch 7150417 : applied on Thu Sep 11 14:11:42 BST 2008
Created on 22 Jun 2008, 00:47:12 hrs PST8PDT
Bugs fixed:
7150417

Patch 6871276 : applied on Thu Sep 11 14:11:38 BST 2008
Created on 13 Mar 2008, 23:27:15 hrs PST8PDT
Bugs fixed:
6871276

Patch 6871274 : applied on Thu Sep 11 14:11:34 BST 2008
Created on 13 Mar 2008, 23:26:15 hrs PST8PDT
Bugs fixed:
6871274

Patch 6731395 : applied on Thu Sep 11 14:11:31 BST 2008
Created on 14 Mar 2008, 00:12:44 hrs PST8PDT
Bugs fixed:
6731395

Patch 6650135 : applied on Thu Sep 11 14:11:25 BST 2008
Created on 13 Mar 2008, 23:58:36 hrs PST8PDT
Bugs fixed:
6650135

Patch 6650132 : applied on Thu Sep 11 14:10:37 BST 2008
Created on 14 Mar 2008, 00:00:24 hrs PST8PDT
Bugs fixed:
6650132

——————————————————————————–

OPatch succeeded.

This article only explains about the how to patch Oracle Home and if you have DB also created then you need to follow post installation steps as per readme.

Disaster Recovery Planning For Oracle DB

Planning DR is essential for any DBA because DBA will be first one to get under the gun if something goes wrong with database and DBA is not able to recover from it.

You have two options available ,

1. Plan the DR
2. Look for new job

I will focus on first one only as i love to get paid.

Oracle provides number of DR solutions and you need to select few of them as per the business requirement.

DR Solutions are ,

1. Export & Import
   
2. RMAN conventional backups.
3. RMAN database copy
4. Flashback Database
5. Data Guard
6. SAN Snapshot
7. RAC

• Export & Import

Export & Import takes the logical backup means it takes backup of the database objects created but database fails then you need to re-create the database and you need to import it once again.

Consider a case wherein you have 2TB database then export and import would take plenty of hours so its not a feasible solution for business.

• RMAN conventional backups

This is most preferred method of taking the backup as RMAN does not require any downtime.The problem with this solution is if you have large database and then you need to restore the database from backup in case of crash and it will long time ,so this is good solution for small databases but not for large database.

• RMAN database copy

This is awesome solution for large database like 2TB.In this solution you need to keep updated database copy in flash_recovery_area and you can perform the switch to copied database anytime whenever you want.It will take few minutes ( 10 Min ) only as it does not need to restore the datafiles from backup hence only recovery is required not restore.

The problem with this solution is that you need to have double of database size disk space as this will be the copy of database not compressed conventional backup.

One more problem is that datafile location will be changed once you perform the switch ,so your business may not allow it.

Once you perform switch then you must take backup as you will not have anymore valid copies.

• Flashback Database

This is very useful solution in case of point in time recovery.You can do point in time recovery with RMAN conventional backup as well but RMAN need to restore all the files from backup and the perform point in time recovery.

In case of Flash Database enabled , Database can be forced back to point in time very easily and fast with the help of flash back logs.

The problem with solution is again disk space.

• Data Guard

This is the widely used option across the globe.With data guard you can maintain the copy of database on local or remote machine.Both databases will be in sync automatically using log shipping.

Data Guard provides two kind of standby.

Physical Standby

Physical standby will be block by block copy of your source database but it will always be in recovery mode or in read only mode ,so if you need standby database which is also getting updated simultaneously then this is not correct choice for you.

Logical Standby

Logical Standby will be in read write mode ,so it can be updated simulataneously but logical standby has lots of restrictions on datatypes ,so you need to see whether your source’s datatypes are supported or not.

• SAN Snapshot

This is feature of SAN providers like NetApp , EMC etc.In this you can create snapshot of database where database is stored.This is very useful solution for large database because you can put database in begin backup mode and you can create the snapshot without having any impact on OS from which database is running.

• RAC ( Real Application Cluster )

Last but not the least , RAC – RAC is very useful in case of instance failure ,so if the instance running on first machine goes down then you can access database from second instance.

RAC requires good numbers of resources like Private Interconnect , SAN etc.

All in all i would recommend to have RAC with Data Guard implemented for true DR solution.

SRVCTL Command ( RAC )

srvctl is the tool Oracle recommends that DBAs use to interact with CRS and the cluster registry. Oracle does provide several tools to interface with the cluster registry and CRS more directly, at a lower level .srvctl, in contrast, is well documented and easy to use.

Using srvctl

Even if you are experienced with 9i srvctl, it’s worth taking a look at this section; 9i and 10g srvctl commands are slightly different.

srvctl must be run from the $ORACLE_HOME of the RAC you are administering. The basic format of a srvctl command is

srvctl <command> <target> [options]

where command is one of

enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config

and the target, or object, can be a database, instance, service, ASM instance, or the nodeapps.

Examples
=======

Example 1. Bring up the ORCL1 instance of the ORCL database.

[oracle@newserver oracle]$ srvctl start instance -d ORCL -i O1RCL

Example 2. Stop the ORCL database: all its instances and all its services, on all nodes.

[oracle@newserver oracle]$ srvctl stop database -d ORCL

Example 3. Stop the nodeapps on the newserver node. NB: Instances and services also stop.

[oracle@newserver oracle]$ srvctl stop nodeapps -n newserver

Example 4. Add the ORCL3 instance, which runs on the newserver node, to the ORCL
clustered database.

[oracle@newserver oracle]$ srvctl add instance -d ORCL -i ORCL3 -n newserver

Example 4. Add a new node, the newserver node, to a cluster.

[oracle@newserver oracle]$ srvctl add nodeapps -n newserver -o $ORACLE_HOME -A 10.177.56.56/255.255.252.0/eth1

(The -A flag precedes an address specification.)

Example 5. To change the VIP (virtual IP) on a RAC node, use the command

[oracle@newserver oracle]$ srvctl modify nodeapps -A new_address

Example 6. Find out whether the nodeapps on newserver are up.

[oracle@newserver oracle]$ srvctl status nodeapps -n newserver
VIP is running on node: newserver
GSD is running on node: newserver
Listener is not running on node: newserver
ONS daemon is running on node: newserver

Example 7. Disable the ASM instance on newserver for maintenance.

[oracle@newserver oracle]$ srvctl disable asm -n newserver

Debugging srvctl

Debugging srvctl in 10g couldn’t be easier. Simply set the SRVM_TRACE environment variable.

[oracle@newserver bin]$ export SRVM_TRACE=true

Let’s repeat Example 6 with SRVM_TRACE set to true:

[oracle@newserver oracle]$ srvctl status nodeapps -n newserver
/u01/app/oracle/product/10.1.0/jdk/jre//bin/java -classpath /u01/app/oracle/product/10.1.0/jlib/netcfg.jar:/u01/app/oracle/product/10.1.0/jdk/jre//lib/rt.jar:
/u01/app/oracle/product/10.1.0/jdk/jre//lib/i18n.jar:/u01/app/oracle/product/10.1.0/jlib/srvm.jar:
/u01/app/oracle/product/10.1.0/jlib/srvmhas.jar:/u01/app/oracle/product/10.1.0/jlib/srvmasm.jar:
/u01/app/oracle/product/10.1.0/srvm/jlib/srvctl.jar
-DTRACING.ENABLED=true -DTRACING.LEVEL=2 oracle.ops.opsctl.OPSCTLDriver status nodeapps -n newserver
[main] [19:53:31:778] [OPSCTLDriver.setInternalDebugLevel:165] tracing is true at level 2 to file null
[main] [19:53:31:825] [OPSCTLDriver.<init>:94] Security manager is set
[main] [19:53:31:843] [CommandLineParser.parse:157] parsing cmdline args
[main] [19:53:31:844] [CommandLineParser.parse2WordCommandOptions:900] parsing 2-word cmdline
[main] [19:53:31:866] [GetActiveNodes.create:212] Going into GetActiveNodes constructor…
[main] [19:53:31:875] [HASContext.getInstance:191] Module init : 16
[main] [19:53:31:875] [HASContext.getInstance:216] Local Module init : 19 …
[main] [19:53:32:285] [ONS.isRunning:186] Status of ora.ganges.ons on newserver is true
ONS daemon is running on node: newserver
[oracle@newserver oracle]$

Pitfalls

A little impatience when dealing with srvctl can corrupt your OCR, ie, put it into a state where the information for a given object is inconsistent or partially missing. Specifically, the srvctl remove command provides the -f option, to allow you to force removal of an object from the OCR. Use this option judiciously, as it can easily put the OCR into an inconsistent state.