Applying Patch 21555791: ORACLE JAVAVM COMPONENT 11.2.0.4.5 DATABASE PSU (OCT2015)

Few concerns for this patch:

  1. This patch is not Oracle RAC Rolling installable.
  2. This patch is not Data Guard Standby First Installable.
  3. This patch requires any one of the following Oct2014 or greater to be already installed prior to installing this patch:
    • Database PSU 11.2.0.4.4 (Oct2014)
    • Database SPU 11.2.0.4 (CPUOct2014)
    • Database patch for Exadata 11.2.0.4.12 (Oct2014)

Note: We have applied Database SPU/CPU 11.2.0.4 (CPUOCT2015) Patch in our previous post so we are good for now.

Patch Information:

The Oracle JavaVM Component 11.2.0.4.5 Database PSU is cumulative and includes the Database CPU program security content including Oracle JavaVM Component 11.2.0.4.1 Database PSU – Generic JDBC Patch 19852360 that was released as a standalone patch as part of CPUOct2014 cycle.

Prerequisites:

  1. Ensure that the Oracle Database on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release 2 (11.2.0.4.0).
  2. You must use the OPatch utility version 11.2.0.3.5 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available.
  3. Ensure that you set the ORACLE_HOME environment variable to the Oracle home of the Oracle Database.
  4. Ensure that the $PATH definition is configured correctly to call important utilities like opatch ( we have already discussed – hoe to get latest opatch utility in our previous posts)
  5. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. If the command displays some errors, then contact Oracle Support and resolve the issue: opatch lsinventory.

Installing of Patch – Applying on ORACLE_HOME:

Step 1: Configure OPATCH utility in PATH variable if its not there already:

[oracle@ora-linux ~]$ which opatch
/usr/bin/which: no opatch in (.:/usr/local/java/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oracle/bin:/u01/app/oracle/product/11.2.0.4/db_1/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:/u01/app/common/oracle/bin)
[oracle@ora-linux ~]$

Its not configured so we have to configure it to call opatch from anywhere:

[oracle@ora-linux ~]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@ora-linux ~]$
[oracle@ora-linux ~]$ which opatch
/u01/app/oracle/product/11.2.0.4/db_1/OPatch/opatch
[oracle@ora-linux ~]$

Now optach utility is being picked up:

Check the inventory of currently installed patches:

=============================================================

[oracle@ora-linux ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-12-08_14-48-37PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-08_14-48-37PM.txt

——————————————————————————–
Local Machine Information::
Hostname: ora-linux.oragyan.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (27) :

Patch 21538567 : applied on Mon Dec 07 23:51:17 IST 2015
Unique Patch ID: 19281142
Created on 14 Aug 2015, 11:06:40 hrs PST8PDT
Bugs fixed:
20441797, 21538567

Patch 21538558 : applied on Mon Dec 07 23:51:16 IST 2015
Unique Patch ID: 19281142
Created on 14 Aug 2015, 11:06:18 hrs PST8PDT
Bugs fixed:
21538558, 20925795

Patch 21538485 : applied on Mon Dec 07 23:51:07 IST 2015
Unique Patch ID: 19281142
Created on 28 Aug 2015, 12:15:47 hrs PST8PDT
Bugs fixed:
20448824, 21538485

Patch 21352646 : applied on Mon Dec 07 23:51:06 IST 2015
Unique Patch ID: 19281142
Created on 1 Sep 2015, 08:43:27 hrs PST8PDT
Bugs fixed:
20299015, 18681862, 19727057, 21352646, 20803583, 18139690, 17343514
19271443, 19854503, 17551709

Patch 21179898 : applied on Mon Dec 07 23:51:04 IST 2015
Unique Patch ID: 18970187
Created on 4 Jun 2015, 11:58:09 hrs PST8PDT
Bugs fixed:
21179898, 19699191

Patch 21051862 : applied on Mon Dec 07 23:50:56 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:38:06 hrs PST8PDT
Bugs fixed:
20004021, 20004087, 21051862

Patch 21051858 : applied on Mon Dec 07 23:50:39 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:37:23 hrs PST8PDT
Bugs fixed:
20334344, 21051858

Patch 21051852 : applied on Mon Dec 07 23:50:28 IST 2015
Unique Patch ID: 18970187
Created on 27 May 2015, 14:03:47 hrs PST8PDT
Bugs fixed:
20331945, 21051852

Patch 21051840 : applied on Mon Dec 07 23:50:27 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:36:14 hrs PST8PDT
Bugs fixed:
20558005, 21051840

Patch 21051833 : applied on Mon Dec 07 23:50:26 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 11:39:55 hrs PST8PDT
Bugs fixed:
21051833, 20657441

Patch 20631274 : applied on Mon Dec 07 23:50:24 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 10:25:35 hrs PST8PDT
Bugs fixed:
20296213, 17600719, 19458377, 19554106, 20631274, 16524926, 19466309

Patch 20506715 : applied on Mon Dec 07 23:50:10 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 10:23:10 hrs PST8PDT
Bugs fixed:
19049453, 19915271, 16450169, 17006570, 17811456, 18554871, 17786278
18096714, 18744139, 20506715, 18061914

Patch 20506699 : applied on Mon Dec 07 23:49:58 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 11:23:48 hrs PST8PDT
Bugs fixed:
20506699, 19358317, 19197175, 19972570, 17762296

Patch 20142975 : applied on Mon Dec 07 23:49:53 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:47:05 hrs PST8PDT
Bugs fixed:
19827973, 19463897, 19289642, 20142975

Patch 19972569 : applied on Mon Dec 07 23:49:52 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:21:09 hrs PST8PDT
Bugs fixed:
19972569, 19006849

Patch 19972568 : applied on Mon Dec 07 23:49:51 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:13:36 hrs PST8PDT
Bugs fixed:
19972568, 19309466

Patch 19972566 : applied on Mon Dec 07 23:49:49 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:03:20 hrs PST8PDT
Bugs fixed:
19972566, 18641461, 18641451

Patch 19972564 : applied on Mon Dec 07 23:31:09 IST 2015
Unique Patch ID: 18406185
Created on 21 Dec 2014, 23:54:58 hrs PST8PDT
Bugs fixed:
19972564, 18436647

Patch 19584068 : applied on Mon Dec 07 23:30:59 IST 2015
Unique Patch ID: 18084194
Created on 24 Sep 2014, 07:43:52 hrs PST8PDT
Bugs fixed:
18262334, 19584068

Patch 19544839 : applied on Mon Dec 07 23:30:58 IST 2015
Unique Patch ID: 18084194
Created on 11 Oct 2014, 01:43:34 hrs PST8PDT
Bugs fixed:
18673325, 19544839, 19211724, 18673304

Patch 19463893 : applied on Mon Dec 07 23:30:46 IST 2015
Unique Patch ID: 18084194
Created on 24 Sep 2014, 06:28:06 hrs PST8PDT
Bugs fixed:
19463893, 18641419

Patch 18203838 : applied on Mon Dec 07 23:30:38 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:57:58 hrs PST8PDT
Bugs fixed:
17865671, 18203838

Patch 18203837 : applied on Mon Dec 07 23:30:30 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:48:38 hrs PST8PDT
Bugs fixed:
17716305, 18203837

Patch 18203835 : applied on Mon Dec 07 23:30:16 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:43:04 hrs PST8PDT
Bugs fixed:
17721717, 18203835

Patch 17811447 : applied on Mon Dec 07 23:30:15 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:20:51 hrs PST8PDT
Bugs fixed:
17811447, 17088068

Patch 17811438 : applied on Mon Dec 07 23:30:13 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:37:11 hrs PST8PDT
Bugs fixed:
17811438, 16721594

Patch 17811429 : applied on Mon Dec 07 23:30:03 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:36:54 hrs PST8PDT
Bugs fixed:
17811429, 13944971

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

OPatch succeeded.
[oracle@ora-linux ~]$

=============================================================

Step 2: Determine whether any currently installed interim patches conflict with this patch 21555791 as shown as follows:

We can find that running the below command:

opatch prereq CheckConflictAgainstOHWithDetail -ph ./

We have to run this command being present in the patch directory.

[oracle@ora-linux 21555791]$ cd /tmp/oracle_patches/Patch_p21555791/21555791
[oracle@ora-linux 21555791]$
[oracle@ora-linux 21555791]$ ls -lrt
total 76
-rw-r–r–. 1 oracle oinstall 21 Oct 7 18:37 README.txt
drwxr-xr-x. 4 oracle oinstall 4096 Oct 7 18:37 etc
drwxr-xr-x. 2 oracle oinstall 4096 Oct 7 18:37 custom
drwxr-xr-x. 9 oracle oinstall 4096 Oct 7 18:37 files
-rw-r–r–. 1 oracle oinstall 5192 Oct 7 18:38 postinstall.sql
-rw-r–r–. 1 oracle oinstall 5201 Oct 7 18:38 postdeinstall.sql
-rw-r–r–. 1 oracle oinstall 2877 Oct 8 15:27 patchmd.xml
-rw-rw-r–. 1 oracle oinstall 37966 Oct 17 04:23 README.html
[oracle@ora-linux 21555791]$
[oracle@ora-linux 21555791]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-12-08_14-56-36PM_1.log

Invoking prereq “checkconflictagainstohwithdetail”

Prereq “checkConflictAgainstOHWithDetail” passed.

OPatch succeeded.
[oracle@ora-linux 21555791]$

=============================================================

Step 3: Apply the patch finally now:

Go to the patch directory and execute the below command:

opatch apply

=============================================================
[oracle@ora-linux ~]$ cd /tmp/oracle_patches/Patch_p21555791/21555791
[oracle@ora-linux 21555791]$
[oracle@ora-linux 21555791]$ ls
custom etc files patchmd.xml postdeinstall.sql postinstall.sql README.html README.txt
[oracle@ora-linux 21555791]$
[oracle@ora-linux 21555791]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/21555791_Dec_08_2015_15_21_12/apply2015-12-08_15-21-12PM_1.log

Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 21555791

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/app/oracle/product/11.2.0.4/db_1’)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘21555791’ to OH ‘/u01/app/oracle/product/11.2.0.4/db_1’
ApplySession: Optional component(s) [ oracle.sqlj, 11.2.0.4.0 ] , [ oracle.sqlj.companion, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.javavm.server, 11.2.0.4.0…

Patching component oracle.rdbms, 11.2.0.4.0…

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0…

Patching component oracle.dbjava.jdbc, 11.2.0.4.0…

Patching component oracle.dbjava.ic, 11.2.0.4.0…

Patching component oracle.javavm.client, 11.2.0.4.0…

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

*******************************************************************************************************
*******************************************************************************************************
** ATTENTION **
** **
** It is critical and essential to complete the post installation (if you are applying the patch) or **
** post deinstallation (if you are doing rollback of the patch) as per Readme to have a working **
** and functional Oracle JavaVM Component. **
** Failure to follow the instructions could lead to inconsistencies in the database. **
** **
*******************************************************************************************************
*******************************************************************************************************

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

Patch 21555791 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/21555791_Dec_08_2015_15_21_12/apply2015-12-08_15-21-12PM_1.log

OPatch succeeded.
[oracle@ora-linux 21555791]$

Check the inventory once again:

[oracle@ora-linux 21555791]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.12
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.12
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-12-08_16-36-09PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-08_16-36-09PM.txt

——————————————————————————–
Local Machine Information::
Hostname: ora-linux.oragyan.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (28) :

Patch 21555791 : applied on Tue Dec 08 16:17:01 IST 2015
Unique Patch ID: 19332276
Patch description: “ORACLE JAVAVM COMPONENT 11.2.0.4.5 DATABASE PSU (OCT2015)”
Created on 7 Oct 2015, 06:07:08 hrs PST8PDT
Bugs fixed:
19058059, 18933818, 19176885, 17201047, 19007266, 19554117, 14774730
17285560, 19153980, 18166577, 18458318, 19374518, 19006757, 17056813
21811517, 19909862, 19223010, 19895326, 20408829, 19852360, 17804361
21047766, 19231857, 17528315, 21566944

Patch 21538567 : applied on Mon Dec 07 23:51:17 IST 2015
Unique Patch ID: 19281142
Created on 14 Aug 2015, 11:06:40 hrs PST8PDT
Bugs fixed:
20441797, 21538567

Patch 21538558 : applied on Mon Dec 07 23:51:16 IST 2015
Unique Patch ID: 19281142
Created on 14 Aug 2015, 11:06:18 hrs PST8PDT
Bugs fixed:
21538558, 20925795

Patch 21538485 : applied on Mon Dec 07 23:51:07 IST 2015
Unique Patch ID: 19281142
Created on 28 Aug 2015, 12:15:47 hrs PST8PDT
Bugs fixed:
20448824, 21538485

Patch 21352646 : applied on Mon Dec 07 23:51:06 IST 2015
Unique Patch ID: 19281142
Created on 1 Sep 2015, 08:43:27 hrs PST8PDT
Bugs fixed:
20299015, 18681862, 19727057, 21352646, 20803583, 18139690, 17343514
19271443, 19854503, 17551709

Patch 21179898 : applied on Mon Dec 07 23:51:04 IST 2015
Unique Patch ID: 18970187
Created on 4 Jun 2015, 11:58:09 hrs PST8PDT
Bugs fixed:
21179898, 19699191

Patch 21051862 : applied on Mon Dec 07 23:50:56 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:38:06 hrs PST8PDT
Bugs fixed:
20004021, 20004087, 21051862

Patch 21051858 : applied on Mon Dec 07 23:50:39 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:37:23 hrs PST8PDT
Bugs fixed:
20334344, 21051858

Patch 21051852 : applied on Mon Dec 07 23:50:28 IST 2015
Unique Patch ID: 18970187
Created on 27 May 2015, 14:03:47 hrs PST8PDT
Bugs fixed:
20331945, 21051852

Patch 21051840 : applied on Mon Dec 07 23:50:27 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 10:36:14 hrs PST8PDT
Bugs fixed:
20558005, 21051840

Patch 21051833 : applied on Mon Dec 07 23:50:26 IST 2015
Unique Patch ID: 18970187
Created on 22 May 2015, 11:39:55 hrs PST8PDT
Bugs fixed:
21051833, 20657441

Patch 20631274 : applied on Mon Dec 07 23:50:24 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 10:25:35 hrs PST8PDT
Bugs fixed:
20296213, 17600719, 19458377, 19554106, 20631274, 16524926, 19466309

Patch 20506715 : applied on Mon Dec 07 23:50:10 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 10:23:10 hrs PST8PDT
Bugs fixed:
19049453, 19915271, 16450169, 17006570, 17811456, 18554871, 17786278
18096714, 18744139, 20506715, 18061914

Patch 20506699 : applied on Mon Dec 07 23:49:58 IST 2015
Unique Patch ID: 18695736
Created on 13 Mar 2015, 11:23:48 hrs PST8PDT
Bugs fixed:
20506699, 19358317, 19197175, 19972570, 17762296

Patch 20142975 : applied on Mon Dec 07 23:49:53 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:47:05 hrs PST8PDT
Bugs fixed:
19827973, 19463897, 19289642, 20142975

Patch 19972569 : applied on Mon Dec 07 23:49:52 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:21:09 hrs PST8PDT
Bugs fixed:
19972569, 19006849

Patch 19972568 : applied on Mon Dec 07 23:49:51 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:13:36 hrs PST8PDT
Bugs fixed:
19972568, 19309466

Patch 19972566 : applied on Mon Dec 07 23:49:49 IST 2015
Unique Patch ID: 18406185
Created on 22 Dec 2014, 00:03:20 hrs PST8PDT
Bugs fixed:
19972566, 18641461, 18641451

Patch 19972564 : applied on Mon Dec 07 23:31:09 IST 2015
Unique Patch ID: 18406185
Created on 21 Dec 2014, 23:54:58 hrs PST8PDT
Bugs fixed:
19972564, 18436647

Patch 19584068 : applied on Mon Dec 07 23:30:59 IST 2015
Unique Patch ID: 18084194
Created on 24 Sep 2014, 07:43:52 hrs PST8PDT
Bugs fixed:
18262334, 19584068

Patch 19544839 : applied on Mon Dec 07 23:30:58 IST 2015
Unique Patch ID: 18084194
Created on 11 Oct 2014, 01:43:34 hrs PST8PDT
Bugs fixed:
18673325, 19544839, 19211724, 18673304

Patch 19463893 : applied on Mon Dec 07 23:30:46 IST 2015
Unique Patch ID: 18084194
Created on 24 Sep 2014, 06:28:06 hrs PST8PDT
Bugs fixed:
19463893, 18641419

Patch 18203838 : applied on Mon Dec 07 23:30:38 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:57:58 hrs PST8PDT
Bugs fixed:
17865671, 18203838

Patch 18203837 : applied on Mon Dec 07 23:30:30 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:48:38 hrs PST8PDT
Bugs fixed:
17716305, 18203837

Patch 18203835 : applied on Mon Dec 07 23:30:16 IST 2015
Unique Patch ID: 17351342
Created on 26 Feb 2014, 23:43:04 hrs PST8PDT
Bugs fixed:
17721717, 18203835

Patch 17811447 : applied on Mon Dec 07 23:30:15 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:20:51 hrs PST8PDT
Bugs fixed:
17811447, 17088068

Patch 17811438 : applied on Mon Dec 07 23:30:13 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:37:11 hrs PST8PDT
Bugs fixed:
17811438, 16721594

Patch 17811429 : applied on Mon Dec 07 23:30:03 IST 2015
Unique Patch ID: 17066906
Created on 11 Dec 2013, 02:36:54 hrs PST8PDT
Bugs fixed:
17811429, 13944971

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

OPatch succeeded.
[oracle@ora-linux 21555791]$

=============================================================

Step 4: Post Installation Steps:

The following steps load modified SQL files into the database.

Install the SQL portion of the patch by running the following command for a single instance environment.

cd /tmp/oracle_patches/Patch_p21555791/21555791
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> startup upgrade
SQL> @postinstall.sql
SQL> shutdown
SQL> startup
After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
That’s it, patch has been applied on the Oracle Home and Instance too, Post Installation step needs to be done on all instances.

Hope it helps…

Advertisements

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