Latest Patch Upgrade 11.2.0.3.8 (PSU) on Database 11.2.0.3 64 bit on Linux 64 bit

First of check out the latest one what we have already:

SQL> select * from registry$history
2 /
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE
—————————— ———- ———- ———- ———- ——————– ——
17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0 PSU
10-OCT-13 09.17.07.046672 PM APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0 PSU

SQL>

So there is no patch updated yet on this database.

Now download the latest patch for Linux 64 bit released on 16th Oct, 2013 (p16902043_112030_Linux-x86-64.zip) from Oracle Support Site (I have a paid oracle account so i can download it from MOS directly).

Place this patch on Linux machine and unzip it, directory will be created with name 16902043.

Read the README.html and do step by step. There is nothing special skills required. Only make sure to have the backup ready with you in case something happens.

As per the read me file first step is:

Determine whether any currently installed one-off patches conflict with the PSU patch as follows, go to the unzipped directory and run the below command:

[oracle@OEL64 16902043]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-10-17_18-33-30PM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.
[oracle@OEL64 16902043]$

Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

[oracle@OEL64 16902043]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-10-17_18-35-03PM_1.log

Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043

Do you want to proceed? [y|n]
y

.
.
.                  <==Output Trimmed Here
.

OPatch found the word “warning” in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo’
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo’
/u01/app/oracle/product/11.2.0.3/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo’
/u01/app/oracle/product/11.2.0.3/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo’

Composite patch 16902043 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-10-17_18-35-03PM_1.log

OPatch completed with warnings.
[oracle@OEL64 16902043]$

There are few warning while running this, as per the metalink this errors does not reflect anywhere for this patch upgrade and can be safely ignored.

Loading Modified SQL Files into the Database

For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

The catbundle.sql execution is reflected in the dba_registry_history view by a row associated with bundle series PSU.

Below is the real step i executed, though i have trimmed the output coz it was too big to paste here.

[oracle@OEL64 16902043]$ cd $ORACLE_HOME/rdbms/admin
[oracle@OEL64 admin]$
[oracle@OEL64 admin]$
[oracle@OEL64 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 17 19:08:38 2013

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

Connected to an idle instance.

SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 835104768 bytes
Fixed Size 2232960 bytes
Variable Size 616566144 bytes
Database Buffers 213909504 bytes
Redo Buffers 2396160 bytes
Database mounted.
Database opened.
SQL>

SQL> @catbundle.sql psu apply

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Generating apply and rollback scripts…
Check the following file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_APEX_GENERATE_2013Oct17_19_12_48.log
Apply script: /u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_APEX_APPLY.sql
Rollback script: /u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/catbundle_PSU_APEX_ROLLBACK.sql

PL/SQL procedure successfully completed.
.
.
.                <=== Output Trimmed
.
.
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 8,
10 ‘PSU’,
11 ‘PSU 11.2.0.3.8’);

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_APEX_APPLY_2013Oct17_19_12_52.log
SQL>

Verify the patch upgrade:

SQL> select NAMESPACE,VERSION,ID,BUNDLE_SERIES from dba_registry_history
2 /

NAMESPACE VERSION ID BUNDLE
———- —————————— ———- ——
SERVER 11.2.0.3 0 PSU
SERVER 11.2.0.3 0 PSU
SERVER 11.2.0.3 8 PSU

SQL>
SQL> select VERSION,ACTION,COMMENTS from registry$history
2 /

VERSION ACTION COMMENTS
—————————— ———- ——————–
11.2.0.3 APPLY Patchset 11.2.0.2.0
11.2.0.3 APPLY Patchset 11.2.0.2.0
11.2.0.3 APPLY PSU         11.2.0.3.8

SQL>

This is done.

Thanks for viewing.

Advertisements

2 thoughts on “Latest Patch Upgrade 11.2.0.3.8 (PSU) on Database 11.2.0.3 64 bit on Linux 64 bit

  1. very good article and it helps me a lot…

    can u please post which are the bugs fixed with this PSU and what are the CPU does this PSU contains.

    thanks in advance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s