dba: Oracle - Apply Oct PSU 24006111

Apply Oct RDBMS PSU on a 11.2.0.4 standalone Oracle database

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

-- Download PSU from support.oracle.com to your machine

[oracle@testing u02]$ ls -ltr /u02

-rwxr-xr-x 1 oracle oinstall 105489166 Oct 24 03:44 p24006111_112040_Linux-x86-64.zip

-- Extract the zip

unzip p24006111_112040_Linux-x86-64.zip

[oracle@testing u02]$ ls -ltr

drwxrwxr-x 14 oracle oinstall 4096 Aug 26 09:56 24006111

-rwxr-xr-x 1 oracle oinstall 105489166 Oct 24 03:44 p24006111_112040_Linux-x86-64.zip

-- Determine whether any currently installed one-off patches conflict with the PSU patch.

[oracle@testing u02]$ cd 24006111/

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle Interim Patch Installer version 11.2.0.3.4

PREREQ session

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_03-48-36AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

-- Check current list of applied patches

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_03-49-56AM_1.log

Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-10-24_03-49-56AM.txt

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

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

-- Check if current opatch version supports the PSU

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch prereq CheckMinimumOPatchVersion -ph ./

Oracle Interim Patch Installer version 11.2.0.3.4

PREREQ session

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.4

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_03-56-19AM_1.log

Invoking prereq "checkminimumopatchversion"

Prereq "checkMinimumOPatchVersion" failed.

The details are:

The OPatch being used has version 11.2.0.3.4 while the following patch(es) require higher versions:

Patch 17478514 requires OPatch version 11.2.0.3.5.

Patch 18031668 requires OPatch version 11.2.0.3.5.

Patch 18522509 requires OPatch version 11.2.0.3.5.

Patch 19121551 requires OPatch version 11.2.0.3.5.

Patch 19769489 requires OPatch version 11.2.0.3.5.

Patch 20299013 requires OPatch version 11.2.0.3.5.

Patch 20760982 requires OPatch version 11.2.0.3.5.

Patch 21352635 requires OPatch version 11.2.0.3.5.

Patch 21948347 requires OPatch version 11.2.0.3.5.

Patch 22502456 requires OPatch version 11.2.0.3.5.

Patch 23054359 requires OPatch version 11.2.0.3.5.

Patch 24006111 requires OPatch version 11.2.0.3.5.

Please download latest OPatch from My Oracle Support.

OPatch succeeded.

-- Since prerequisite failed, we need to download latest opatch before proceeding.

-- Download latest opatch from https://updates.oracle.com/download/6880880.html

[oracle@testing u02]$ ls -ltr /u02/*6880880*

-rwxr-xr-x 1 oracle oinstall 98352086 Oct 24 06:52 /u02/p6880880_112000_Linux-x86-64.zip

[oracle@testing u02]$ cp p6880880_112000_Linux-x86-64.zip $ORACLE_HOME/

-- Move the zip to Oracle Home and extract

[oracle@testing u02]$ cd $ORACLE_HOME

[oracle@testing db_1]$ mv OPatch OPatch_bkp

[oracle@testing db_1]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@testing db_1]$ cd -

/u02

-- Check the new Opatch version

[oracle@testing u02]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.15

OPatch succeeded.

-- Take the backup of Oracle Home and Oracle Inventory

tar -zcvf Oracle_Home.tar.gz /u02/app/oracle/product/11.2.0/db_1

tar -zcvf Oracle_Inventory.tar.gz /u02/app/oraInventory

-- Check if all components of registry are valid

col comp_name for a40

set pages 30 lines 80

col version for a20

select comp_name, version, status from dba_registry;

COMP_NAME VERSION STATUS

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

OWB 11.2.0.4.0 VALID

Oracle Application Express 3.2.1.00.12 VALID

Oracle Enterprise Manager 11.2.0.4.0 VALID

OLAP Catalog 11.2.0.4.0 VALID

Spatial 11.2.0.4.0 VALID

Oracle Multimedia 11.2.0.4.0 VALID

Oracle XML Database 11.2.0.4.0 VALID

Oracle Text 11.2.0.4.0 VALID

Oracle Expression Filter 11.2.0.4.0 VALID

Oracle Rules Manager 11.2.0.4.0 VALID

Oracle Workspace Manager 11.2.0.4.0 VALID

Oracle Database Catalog Views 11.2.0.4.0 VALID

Oracle Database Packages and Types 11.2.0.4.0 VALID

JServer JAVA Virtual Machine 11.2.0.4.0 VALID

Oracle XDK 11.2.0.4.0 VALID

Oracle Database Java Packages 11.2.0.4.0 VALID

OLAP Analytic Workspace 11.2.0.4.0 VALID

Oracle OLAP API 11.2.0.4.0 VALID

-- Check if all SYS objects are valid (if not, vaidate them before applying patch)

col object_name for a20

col object_type for a20

select object_name, object_type, status from dba_objects where status != 'VALID';

no rows selected

-- Apply the patch

[oracle@testing u02]$ cd 24006111/

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.15

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-08-47AM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active :

/u02/app/oracle/product/11.2.0/db_1/bin/oracle

/u02/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-08-47AM_1.log

OPatch failed with error code 73

-- opatch failed. Some files are getting used by other applications. Lets see who is using them.

-- There are 2 active files. We will check for them one by one.

/u02/app/oracle/product/11.2.0/db_1/bin/oracle

/u02/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

[oracle@testing 24006111]$ /sbin/fuser /u02/app/oracle/product/11.2.0/db_1/bin/oracle

/u02/app/oracle/product/11.2.0/db_1/bin/oracle: 5181e 5183e 5185e 5189e 5191e 5193e 5195e 5197e 5199e 5201e 5203e 5205e 5207e 5209e 5211e 5213e 5215e 11985e 11987e 11989e 11993e 11995e 11997e 11999e 12001e 12003e 12005e 12007e 12009e 12011e 12013e 12015e 12017e 12019e 12027e 12029e 12031e 12033e 12035e 12049e 12065e 12067e 12442e 12444e

-- Oracle database is active and needs to shutdown

[oracle@testing 24006111]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 24 07:14:04 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@testing 24006111]$ /sbin/fuser /u02/app/oracle/product/11.2.0/db_1/bin/oracle

[oracle@testing 24006111]$

-- Check for other active file

[oracle@testing 24006111]$ /sbin/fuser /u02/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

/u02/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1: 11942m

-- check for the spid

[oracle@testing 24006111]$ ps -ef |grep 11942

oracle 11942 1 0 06:32 ? 00:00:00 /u02/app/oracle/product/11.2.0/db_1/bin/tnslsnr listener -inherit

oracle 14827 10050 0 07:18 pts/1 00:00:00 grep 11942

-- listener is active. needs to be shutdown

[oracle@testing 24006111]$ lsnrctl stop listener

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 24-OCT-2016 07:19:01

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testing.localdomain)(PORT=1521)))

The command completed successfully

[oracle@testing 24006111]$ /sbin/fuser /u02/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

[oracle@testing 24006111]$

-- Now we are good to apply the patch

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.15

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-21-59AM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111

Do you want to proceed? [y|n]

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 = '/u02/app/oracle/product/11.2.0/db_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Backing up files...

...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Applying sub-patch '24006111' to OH '/u02/app/oracle/product/11.2.0/db_1'

Patching component oracle.sqlplus.ic, 11.2.0.4.0...

Patching component oracle.sqlplus, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Composite patch 24006111 successfully applied.

Log file location: /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-21-59AM_1.log

OPatch succeeded.

-- Verify Opatch inventory

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.15

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-31-46AM_1.log

Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-10-24_07-31-46AM.txt

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

Local Machine Information::

Hostname: testing.localdomain

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 (1) :

Patch 24006111 : applied on Mon Oct 24 07:27:41 EDT 2016

Unique Patch ID: 20508568

Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Created on 26 Aug 2016, 05:54:48 hrs PST8PDT

Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"

Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"

Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"

Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"

Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"

Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

Bugs fixed:

17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944

13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498

17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856

21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210

17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317

22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886

18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240

17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706

21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056

22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377

6599380, 17612828, 22092979, 22321756, 17040527, 17811438, 18641461

14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549

19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898

17546761, 18203835, 18964939, 18203838, 18203837, 17313525, 22195457

18139690, 22296366, 14106803, 16837842, 17842825, 22657942, 21352646

20657441, 16360112, 22195441, 17389192, 14565184, 17205719, 14354737

22195448, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436

18673342, 17027426, 19972569, 19972568, 19972566, 17282229, 19972564

16870214, 19615136, 17390431, 18762750, 16613964, 18098207, 17957017

18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719

18317531, 17852463, 17596908, 17655634, 20074391, 16228604, 19972570

18996843, 19854503, 16042673, 17835627, 20334344, 18000422, 20861693

17393683, 17551709, 20506699, 19006849, 18456514, 18277454, 17258090

17174582, 17242746, 16399083, 17824637, 17762296, 17397545, 16450169

12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897

17853456, 18673304, 20004021, 21668627, 16194160, 17477958, 16538760

12982566, 20296213, 18293054, 17610798, 19699191, 18135678, 17311728

16785708, 10136473, 17786518, 18315328, 18334586, 12747740, 19032867

18096714, 17390160, 17232014, 16422541, 18673325, 18155762, 14015842

19827973, 22683225, 17726838, 18554871, 23177648, 18051556, 20803583

18282562, 17922254, 15990359, 21972320, 16855292, 16668584, 21343838

20299015, 17446237, 18093615, 17694209, 17288409, 17274537, 13955826

16934803, 17634921, 17501491, 16315398, 22683212, 17006183, 13829543

18191164, 17655240, 19393542, 18384391, 21538567, 16198143, 21847223

17892268, 20142975, 19584068, 17165204, 18508861, 21756699, 16901385

18554763, 18189036, 17443671, 17385178, 17936109, 14829250, 20925795

17478514, 16850630, 13951456, 16595641, 15861775, 14054676, 16912439

17299889, 17297939, 18619917, 16833527, 17798953, 17816865, 18607546

17571306, 21286665, 17341326, 17851160, 20558005, 17586955, 19049453

21051840, 17587063, 16956380, 18328509, 14133975, 18061914, 21051833

18522509, 18765602, 18199537, 17332800, 13609098, 18384537, 22502493

14338435, 17945983, 21067387, 16392068, 17752995, 21051862, 17237521

16863422, 18244962, 19544839, 24433711, 17156148, 18973907, 17877323

17449815, 18180390, 17088068, 17037130, 20004087, 19466309, 11733603

18084625, 21051858, 18674024, 21051852, 18091059, 16306373, 18306996

19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015

17346091, 18228645, 17721717, 18436307, 11883252, 21756677, 17891943

22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719

17265217, 17071721, 16721594, 21756661, 18262334, 15913355, 17891946

17672719, 17602269, 17239687, 17042658, 17238511, 17811456, 17284817

17752121, 17394950, 16579084, 17011832, 22195465, 14602788, 18325460

24476265, 24476274, 12611721, 16903536, 17006570, 16043574, 18783224

16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 22195477

17865671, 19013183, 17343514, 18316692, 17325413, 16180763, 17348614

14368995, 21983325, 17393915, 16285691, 20331945, 17883081, 24316947

17705023, 17614227, 22195485, 14084247, 13645875, 16777840, 19727057

14852021, 18744139, 18674047, 17716305, 18482502, 19289642, 17622427

22195492, 14458214, 18723434, 17767676, 19258504, 17786278, 17082983

21351877, 13498382, 18331812, 16065166, 18031668, 22893153, 16943711

21517440, 17649265, 13866822, 18094246, 24528741, 14245531, 17783588

17082359, 20448824, 18280813, 23330119, 16268425, 17302277, 18018515

17215560, 19271443, 17016369, 20777150, 23330124, 20441797, 19769489

17545847, 18260550, 13853126, 23536835, 17227277, 9756271, 18868646

17614134, 17546973, 19680952, 18704244, 18828868, 18273830, 17050888

17360606, 16992075, 17375354, 12905058, 18362222, 17571039, 17468141

18436647, 17235750, 21168487, 16220077, 16929165

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

OPatch succeeded.

-- Execute catbundle to update registry

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

CONNECT / AS SYSDBA

STARTUP

@catbundle.sql psu apply

QUIT

-- Check the registy

SQL> select * from registry$history;

ACTION_TIME

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

ACTION NAMESPACE

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

VERSION ID

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

COMMENTS

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

BUNDLE_SERIES

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

24-AUG-13 12.03.45.119862 PM

APPLY SERVER

11.2.0.4 0

Patchset 11.2.0.2.0

PSU

20-OCT-16 12.45.55.843365 AM

APPLY SERVER

11.2.0.4 0

Patchset 11.2.0.2.0

PSU

24-OCT-16 07.35.22.221183 AM

APPLY SERVER

11.2.0.4 161018

PSU 11.2.0.4.161018

PSU

3 rows selected.

-- If you want to rollback, you need to revert catbundle and patch

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

SQL> CONNECT / AS SYSDBA

SQL> STARTUP

SQL> @catbundle_PSU_ORADB1_ROLLBACK.sql

SQL> QUIT

-- Rollback patch

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch rollback -id 24006111

Oracle Interim Patch Installer version 11.2.0.3.15

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-42-03AM_1.log

Patches will be rolled back in the following order:

24006111 23054359 22502456 21948347 21352635 20760982 20299013 19769489 19121551 18522509 18031668 17478514

The following patch(es) will be rolled back: 24006111 23054359 22502456 21948347 21352635 20760982 20299013 19769489 19121551 18522509 18031668 17478514

Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back.

The following bug fixes will be removed: 22243719,22148226,22657942,24316947,6599380,24476265,24476274,24528741,24433711,23330119,22507234,23177648,22380919,22296366,23330124,22507210,23536835,16596890,22502493,19721304,22683212,22353199,20596234,22893153,21756661,18093615,22683225,21756677,21286665,21868720,19258504,21983325,21387964,21343838,21756699,20861693,22195492,22321756,21787056,21330264,17655240,21847223,21517440,22195457,22195465,22195448,22195485,21526048,21668627,22195441,19032867,17551063,21343775,22321741,21972320,21168487,21453153,22092979,21343897,21351877,22195477,16065166,20925795,21538558,21538485,21352646,20448824,21538567,20441797,20004021,21067387,18260550,19699191,18331812,21179898,21051833,20004087,21051852,18440047,20331945,20657441,20334344,20803583,21051840,21051862,20558005,21051858,20067212,20777150,17348614,19788842,16870214,17346091,17082983,17957017,19013183,19358317,18619917,18316692,18317531,17649265,17816865,18856999,17634921,17889549,20296213,17852463,16571443,18000422,18868646,18084625,17201159,16194160,17848897,16903536,16668584,16091637,17798953,16579084,18607546,18193833,18384537,18325460,18430495,13829543,17877323,17811789,14015842,17360606,18456514,18723434,14692762,18362222,18091059,17246576,18384391,18704244,17889583,12982566,20506715,20631274,18331850,12611721,17945983,19393542,17156148,17694209,20506699,18765602,17762296,16306373,20299015,14368995,18762750,18051556,8322815,19915271,18155762,18783224,20506706,17853456,13837378,17853498,16384983,19972566,14034426,19972568,17835048,18471685,19972569,18508861,18244962,17258090,12816846,15990359,19615136,18235390,17274537,18098207,19854503,17922254,15913355,16595641,18334586,17282229,18441944,18315328,19309466,18202441,19972570,19769489,16901385,19680952,18828868,14354737,11883252,18282562,16777840,17936109,12364061,17835627,18641461,18306996,16538760,17912217,18482502,18554763,17184721,20074391,18614015,19197175,16934803,17851160,18092127,18356166,16422541,18436647,18674047,14106803,17302277,20142975,19006849,13558557,17891943,17308789,16344544,17025461,16833527,18273830,18641451,19827973,18228645,18189036,18339044,17215560,18964939,19730508,18135678,19972564,18293054,18747196,17571039,18674024,16042673,14245531,12747740,18264060,19211724,19121551,19727057,17449815,19544839,18673304,19554106,18436307,17982555,17586955,18673342,14657740,18009564,17232014,9756271,19271443,17842825,13955826,17237521,17042658,17040527,18262334,17951233,17267114,17390160,18641419,16494615,18191164,17570240,17787259,17299889,17036973,14764829,17891946,19463893,17587063,19289642,19463897,14084247,18230522,17343514,17824637,18973907,18280813,18328509,17242746,17705023,18673325,16198143,19584068,17006183,11733603,16524926,14285317,18199537,19466309,19458377,14829250,17037130,16692232,17596908,17174582,17648596,17011832,13645875,18096714,17752995,13951456,17655634,16992075,17786518,17393915,13498382,13609098,15861775,16360112,17571306,17477958,16392068,17006570,14458214,14602788,17397545,16268425,17165204,14565184,17883081,18522509,18018515,17672719,16315398,13853126,18554871,17767676,17588480,16542886,17227277,16855292,14054676,17786278,17311728,18247991,18277454,15979965,18681862,18996843,17754782,17892268,17614134,16314254,17478145,18061914,19049453,17238511,17600719,17381384,18744139,17297939,17783588,17716305,16180763,17545847,18203838,17393683,16863422,17389192,17394950,16731148,17761775,10136473,17726838,17186905,17441661,17325413,18203835,13364795,17050888,16472716,17622427,17546761,17468141,17040764,14010183,16837842,16228604,17205719,17284817,17346671,18180390,17235750,14133975,17721717,17082359,17602269,17071721,16613964,16929165,16043574,17080436,17265217,17865671,14852021,16399083,16943711,17375354,17546973,16785708,16956380,18094246,17614227,18031668,17313525,16912439,17385178,16618694,16220077,17016369,18203837,17027426,17341326,18139690,17437634,16875449,17465741,17752121,17344412,17296856,17390431,14338435,17323222,16850630,17551709,13944971,17811447,13866822,17811429,16069901,16721594,17443671,17478514,17612828,17610798,17239687,17501491,17446237,16450169,17811438,17288409,17811456,12905058,17088068,16285691,17332800

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u02/app/oracle/product/11.2.0/db_1')

Is the local system ready for patching? [y|n]

User Responded with: Y

Rolling back patch 24006111...

RollbackSession rolling back interim patch '24006111' from OH '/u02/app/oracle/product/11.2.0/db_1'

...

OPatch Session completed with warnings.

Log file location: /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-42-03AM_1.log

OPatch completed with warnings.

-- Check opatch inventory to confirm patch has been rolled back.

[oracle@testing 24006111]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.15

Oracle Home : /u02/app/oracle/product/11.2.0/db_1

Central Inventory : /u02/app/oraInventory

from : /u02/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version : 11.2.0.3.15

OUI version : 11.2.0.4.0

Log file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-10-24_07-50-52AM_1.log

Lsinventory Output file location : /u02/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-10-24_07-50-52AM.txt

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

Local Machine Information::

Hostname: testing.localdomain

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.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[oracle@testing 24006111]$

Hope that Helps.

dba

Views

Monday, October 24, 2016

Oracle - Apply Oct PSU 24006111

No comments:

Post a Comment

Subscribe

Search This Blog

Blogs I Follow