Check for ORACLE Patches applied

as grid and 11g:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed  | grep -i 'PSU'

 

for database:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'DATABASE PSU'

 

for CRS:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'TRACKING BUG' | grep -i 'PSU'

 

For GI:

$ORACLE_HOME/OPatch/opatch lsinventory -bugs_fixed | grep -i 'GI PSU'

 

query the registry$history database object

select substr(action_time,1,30) action_time,

substr(id,1,10) id,

substr(action,1,10) action,

substr(version,1,8) version,

substr(BUNDLE_SERIES,1,6) bundle,

substr(comments,1,20) comments

from registry$history;

List CPU patch applied to database

List CPU patch applied to database 

1. sqlplus  as system

2. execute the following sql statement

  set linesize 90 

 

  col action format a7

  col version format a10

  col id format 99999

  col when format a20

  select d.name,to_char(r.action_time,'YYYY/MM/DD.hh24:mi')    when,r.action,r.version,r.id,r.bundle_series

  from v$database d left outer join dba_registry_history r

  on r.bundle_series in ('CPU','PSU');

Hope this helps. Regards Rupam

CPU Patch

CPU Patch Install  Process  

1. Follow the instructions  to apply the  patch using OPatch but do not start the instances or the listeners

Apply the Patch using Opatch

2. Apply the CPU sql script to each database from one node/instance only

   

    set your environment to the instance name
    cd  directory specified in README.txt of patch

    > cd $ORACLE_HOME/rdbms/admin

       sqlplus / as sysdba

       SQL>@catbundle.sql cpu apply

       SQL>@utlrp

       SQL>exit

3. After all databases have been updated, start the remaining instances(in RAC).

4. Start the listeners

5. Check connectibity

Hope this help. Regards Rupam

Install OPatch

Install OPatch

Refer : Metalink link Note # 274526.1 and 224346.1

1) Please download the latest OPatch version from My Oracle Support (MOS)

a) Click on the "Patches & Updates" tab

b) In the "Patch Name or Number" field type 6880880

c) In the "Platform" field select the relevant platform

d) Click the Search button.

e) Select the patch that corresponds to the Oracle release installed:

6880880 Universal Installer: Patch OPatch 9i, 10.1
6880880 Universal Installer: Patch OPatch 10.2
6880880 Universal Installer: Patch OPatch 11.1
6880880 Universal Installer: Patch OPatch 11.2

f) Click the Download button

2) Upload or move the ZIP file to ORACLE_HOME and unzip it:

    % cd OPatch
    % opatch version

3) Now you can set the OPatch directory in your PATH variable so you can execute the OPatch command from anywhere.

Example:

For Korn / Bourne shell
% export PATH=$PATH:$ORACLE_HOME/OPatch

For C Shell
% setenv PATH $PATH:$ORACLE_HOME/OPatch

Hope this help. Regards Rupam

OPatch

OPatch Apply

Pre-implementation

1.  download the patch  

2.  unzip

Outage

1. Stop the listener
2. Stop all instances on the ORACLE_HOME on which patch is going to be applied

4. Set your environment to the ORACLE_HOME.

5. cd   patch number directory

6. Set your path to include the OPatch directory

     export PATH=$ORACLE_HOME/OPatch:$PATH

     Note : Check the OPatch version. Get the latest Version from Metalink

7. Apply the patch  

  On linux  

     option # 1   

         opatch apply –local

     option # 2   

         opatch napply –local –skip_subset –skip_duplicate

 on solaris 

      opatch apply –local OPatch.SKIP_VERIFY=true

8. Verify that all is well

     opatch lsinventory

9. Start all the instances

10. Wait until all instances have started.

11. Start the listener

12. check connectivity

Hope this help. Regards Rupam

OPatch

Check Patch conflict

opatch prereq CheckConflictAgainstOH -ph $(pwd)