Tuesday, June 30, 2015

Patching RAC (Grid Plus Database) / Bundle Patch not full release


Environment: 11gRAC/DB (11.2.0.3) , Windows Server 2008 R2 x64 Edition
Patch:13965211 - 11.2.0.3 Patch 6 for Windows 64 bit, download patch from metalink.
This patch is RAC rolling upgradable for GRID, and RDBMS homes. 
You should administer one Oracle product, one Oracle home at a time, for its particular Bundle Patch Update.

DB 11.2.0.3 Patch 6 includes all bugs fixed in 11.2.0.3 Patch 1 to Patch 5. It must be applied on top of the 11.2.0.3 base release or on top of any earlier bundle patch from 11.2.0.3 Patch 1 to Patch 5.
The order of patching in RAC install is GRID_HOME, then RDBMS_HOME 
OPatch Info:
Oracle recommends that you use OPatch utility release 11.2.0.1.9 or later. You can download it fromMy Oracle Support with patch 6880880.

Patch Installation Instructions
Patching GRID Home

  1. Before Patching GRID_HOME, stop OCR related resources, Oracle HASD Services (OHASD) Services and all Oracle Services:
    > srvctl stop service -d  
             -s  -i 
> srvctl stop instance -d DBNAME -i INSTANCE -o abort
> crsctl stop crs
make the backup of the Oracle Home being patached (eg; d:\app...)
  2. To verify all resources have been oved to the other nodes, run the following command from another node with GRID running:
    > crsctl status resource -t
     
  3. Then use the Computer Management Services GUI or the net stop command to stop ALL Oracle services running on that node:
        net stop OracleService
        net stop OracleTNSListenerLISTENER_
        net stop OracleTNSListenerLISTENER_SCANn
        net stop OracleDBConsole
        net stop OracleASMService
        net stop "Oracle VSS Writer Service"
        net stop OracleREMExecService
        net stop OracleOHService
        net stop "Oracle Object Service"
        net stop OracleClusterVolumeService
        net stop ocfs (required only for OCFS installation)
        net stop orafenceservice
        Note: An explicit 'srvctl start listener -n ' should be issued after patching
  4. Set the ORACLE_HOME environment variable properly
    D:\Sources\11.2.0.3\Patches\p6880880_112000_MSWIN-x86-64_optach\OPatch>set ORACLE_HOME=D:\app\11.2.0.3\grid
  5. Go to the directory where you downloaded the patch:
    D:\Sources\11.2.0.3\Patches\p6880880_112000_MSWIN-x86-64_optach\OPatch>cd D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64
    First check the inventory for the existing patches
    D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64>D:\Sources\11.2.0.3\Patches\p6880880_112000_MSWIN-x86-64_optach\OPatch\opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : D:\app\11.2.0.3\grid
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : D:\app\11.2.0.3\grid\cfgtoollogs\opatch\opatch2012-05-26_10-47-13AM_1.log

Lsinventory Output file location : D:\app\11.2.0.3\grid\cfgtoollogs\opatch\lsinv\lsinventory2012-05-26_10-47-13AM.txt

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

Oracle Grid Infrastructure                                           11.2.0.3.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
  Local node = P-HQ-CL-OR-11
  Remote node = P-HQ-CL-OR-12

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

OPatch succeeded.

  1. D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64>cd 13965211
  2. D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64\13965211>D:\Sources\11.2.0.3\Patches\p6880880_112000_MSWIN-x86-64_optach\OPatch\opatch apply -local
  1. opatch will attempt to apply the patch on all the nodes in the cluster sequentially. However will prompt for user input to start patching other nodes. At this time ensure that the Oracle services on target node are stopped before proceeding to patch. Once the opatch session completes patching this node, start the services and proceed applying patch to the next node.
  2.  Once the opatch session completes patching GRID_HOME on a node, run the following before proceeding to patch GRID_HOME on the next node. %ORACLE_HOME%\bin\acfsroot installD:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64\13965211>%ORACLE_HOME%\bin\acfsroot install
    ACFS-9300: ADVM/ACFS distribution files found.
    ACFS-9307: Installing requested ADVM/ACFS software.
    ACFS-9308: Loading installed ADVM/ACFS drivers.
    ACFS-9327: Verifying ADVM/ACFS devices.
    ACFS-9157: Detecting driver 'oracle oks'.
    ACFS-9157: Detecting driver 'oracle advm'.
    ACFS-9157: Detecting driver 'oracle acfs'.
    ACFS-9309: ADVM/ACFS installation correctness verified.

  3. After this you can start the CRS or go for the RDBMS home patch without starting it, I started.
    D:\app\11.2.0.3\grid\BIN>crsctl start crs
    CRS-4123: Oracle High Availability Services has been started.

    D:\app\11.2.0.3\grid\BIN>crsctl check crs
    CRS-4638: Oracle High Availability Services is online
    CRS-4537: Cluster Ready Services is online
    CRS-4529: Cluster Synchronization Services is online
    CRS-4533: Event Manager is online
     
  4. Verify the patch installation
    5. opatch lsinventory 

    Patching RDBMS Home

    1. Before Patching RDBMS_HOME, the GRID and ASM services can be running.
      Stop OCR related resources and Oracle Services on the current node as listed below:
      > srvctl stop service -d -s -i > srvctl stop instance -d -i -o abort
      D:\app\11.2.0.3\grid\BIN>srvctl stop instance -d rac -i rac1
    2. Set ORACLE_HOME
      D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64\13965211>set ORACLE_HOME=D:\app\farif\product\11.2.0.3\dbhome_1
    3.  Apply patch
      D:\Sources\11.2.0.3\Patches\p13965211_112030_MSWIN-x86-64\13965211>D:\Sources\11.2.0.3\Patches\p6880880_112000_MSWIN-x86-64_optach\OPatch\opatch apply 
    4. Start the DB instances
D:\app\11.2.0.3\grid\BIN>srvctl start instance -d rac -i rac1

D:\app\11.2.0.3\grid\BIN>

      5. Post installation steps

      After installing the patch, perform the following actions:
      For each database instance running out of the ORACLE_HOME being patched, connect to the database using SQL*Plus as SYSDBA and run catwinbundle.sql as follows:


      d %ORACLE_HOME%\Bundle\Patch6
> sqlplus /nolog 
SQL> CONNECT / AS SYSDBA 
SQL> STARTUP
SQL> @catwinbundle.sql
SQL> QUIT
C:\Users\farif>cd D:\app\farif\product\11.2.0.3\dbhome_1\bundle\patch6


D:\app\farif\product\11.2.0.3\dbhome_1\bundle\patch6>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun May 27 11:30:19 2012

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options

SQL>

SQL> @catwinbundle.sql

...
...
...
SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '11.2.0.3',
  9     6,
 10     'WINBUNDLE',
 11     '11.2.0.3 BP 6');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
D:\app\farif\cfgtoollogs\catbundle\catbundle_WINBUNDLE_RAC_APPLY_2012May27_11_31_37.log
SQL>

Check all dependent objects are valid and if not then compile them by using 
utlrp.sql
SQL> select count(*) from dba_objects where status ='INVALID';

  COUNT(*)
----------
     20083

Note: 
You must execute the steps in "Post Installation Steps" for any new database that was created by any of the following methods:
  • Using DBCA (Database Configuration Assistant) to select a sample database (General, Data Warehouse, Transaction Processing)
  • Using a script that was created by DBCA that creates a database from a sample database
  • Cloning a database that was created by either of the two preceding methods, and if "Post Installation Steps"   was not executed after Bundle Patch6 was applied
Posted by at
Labels: , ,

No comments:

Post a Comment