Tuesday, January 30, 2018

Step by Step procedure for applying PSU JAN18 Patch 26925576 - Database Patch Set Update 11.2.0.4.180116 in Linux Standalone


Apply Patch 26925576: DATABASE PATCH SET UPDATE 11.2.0.4.180116

Patch files required :


p6880880_112000_Linux-x86-64_2   - For Opatch utility
p26925576_112040_Linux-x86-64    - For DB



  1. Download required PSU (26925576) and unzip it
  2. Stop OEM, if running
  3. shut down  instances and listeners associated with the Oracle home that you are updating
  4. Take backup of oracle home 
  5. apply patch using opatch


This command use to take db home backup 
tar -zcvf   /u01/app/oracle/product/11.2.0/db_1/db_home_bkp_before_patch.tar.gz   /u01/app/oracle/product/11.2.0   

[oracle@localhost patch]$export opatch

[oracle@localhost patch]$export PATH=$PATH:$HOME:$ORACLE_HOME/OPatch:/bin
[oracle@localhost patch]$ opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@localhost patch]$
[oracle@localhost oracle_software]$ cd patch/
[oracle@localhost patch]$ ls -lrt
total 237844
drwxr-xr-x 19 oracle oinstall      4096 Dec  5 18:54 26925576
-rw-rw-r--  1 oracle oinstall     90387 Jan 16 19:25 PatchSearch.xml
-rw-r--r--  1 oracle oinstall 137382058 Jan 30 18:32 p26925576_112040_Linux-x86-64.zip
-rw-r--r--  1 oracle oinstall 106062116 Jan 30 18:56 p6880880_112000_Linux-x86-64_2.zip
[oracle@localhost patch]$
[oracle@localhost patch]$ cd 26925576/
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ pwd
/u01/app/oracle_software/patch/26925576
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_18-58-01PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@localhost 26925576]$

[oracle@localhost 26925576]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_19-04-00PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-30_19-04-00PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
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@localhost 26925576]$
[oracle@localhost 26925576]$ opatch lsinventory -details
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_19-04-26PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-30_19-04-26PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
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.
Installed Products (136):
Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Database Configuration and Upgrade Assistants                        11.2.0.4.0
Database SQL Scripts                                                 11.2.0.4.0
Database Workspace Manager                                           11.2.0.4.0
Deinstallation Tool                                                  11.2.0.4.0
Enterprise Edition Options                                           11.2.0.4.0
Enterprise Manager Agent                                             10.2.0.4.5
Enterprise Manager Agent Core Files                                  10.2.0.4.5
Enterprise Manager Common Core Files                                 10.2.0.4.5
Enterprise Manager Common Files                                      10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support                  11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support             11.2.0.4.0
Enterprise Manager Grid Control Core Files                           10.2.0.4.5
Enterprise Manager plugin Common Files                               11.2.0.4.0
Enterprise Manager Repository Core Files                             10.2.0.4.5
Exadata Storage Server                                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
Generic Connectivity Common Files                                    11.2.0.4.0
HAS Common Files                                                     11.2.0.4.0
HAS Files for DB                                                     11.2.0.4.0
Installation Common Files                                            11.2.0.4.0
Installation Plugin Files                                            11.2.0.4.0
Installer SDK Component                                              11.2.0.4.0
JAccelerator (COMPANION)                                             11.2.0.4.0
Java Development Kit                                                1.5.0.51.10
LDAP Required Support Files                                          11.2.0.4.0
OLAP SQL Scripts                                                     11.2.0.4.0
Oracle 11g Warehouse Builder Required Files                          11.2.0.4.0
Oracle Advanced Security                                             11.2.0.4.0
Oracle Application Express                                           11.2.0.4.0
Oracle Call Interface (OCI)                                          11.2.0.4.0
Oracle Clusterware RDBMS Files                                       11.2.0.4.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.3.8.1.0
Oracle Configuration Manager Client                                  10.3.2.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.4.0
Oracle Core Required Support Files                                   11.2.0.4.0
Oracle Data Mining RDBMS Files                                       11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Multimedia Files                                 11.2.0.4.0
Oracle Database Deconfiguration                                      11.2.0.4.0
Oracle Database Gateway for ODBC                                     11.2.0.4.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.4.0
Oracle Database Vault J2EE Application                               11.2.0.4.0
Oracle Database Vault option                                         11.2.0.4.0
Oracle DBCA Deconfiguration                                          11.2.0.4.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Enterprise Manager Console DB                                 11.2.0.4.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Help for the  Web                                             2.0.14.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.4.0
Oracle Java Client                                                   11.2.0.4.0
Oracle JDBC Server Support Package                                   11.2.0.4.0
Oracle JDBC/OCI Instant Client                                       11.2.0.4.0
Oracle JDBC/THIN Interfaces                                          11.2.0.4.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.4.0
Oracle Label Security                                                11.2.0.4.0
Oracle LDAP administration                                           11.2.0.4.0
Oracle Locale Builder                                                11.2.0.4.0
Oracle Message Gateway Common Files                                  11.2.0.4.0
Oracle Multimedia                                                    11.2.0.4.0
Oracle Multimedia Annotator                                          11.2.0.4.0
Oracle Multimedia Client Option                                      11.2.0.4.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.4.0
Oracle Multimedia Locator                                            11.2.0.4.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.4.0
Oracle Net                                                           11.2.0.4.0
Oracle Net Listener                                                  11.2.0.4.0
Oracle Net Required Support Files                                    11.2.0.4.0
Oracle Net Services                                                  11.2.0.4.0
Oracle Netca Client                                                  11.2.0.4.0
Oracle Notification Service                                          11.2.0.3.0
Oracle Notification Service (eONS)                                   11.2.0.4.0
Oracle ODBC Driver                                                   11.2.0.4.0
Oracle ODBC Driverfor Instant Client                                 11.2.0.4.0
Oracle OLAP                                                          11.2.0.4.0
Oracle OLAP API                                                      11.2.0.4.0
Oracle OLAP RDBMS Files                                              11.2.0.4.0
Oracle One-Off Patch Installer                                       11.2.0.3.4
Oracle Partitioning                                                  11.2.0.4.0
Oracle Programmer                                                    11.2.0.4.0
Oracle Quality of Service Management (Client)                        11.2.0.4.0
Oracle RAC Deconfiguration                                           11.2.0.4.0
Oracle RAC Required Support Files-HAS                                11.2.0.4.0
Oracle Real Application Testing                                      11.2.0.4.0
Oracle Recovery Manager                                              11.2.0.4.0
Oracle Security Developer Tools                                      11.2.0.4.0
Oracle Spatial                                                       11.2.0.4.0
Oracle SQL Developer                                                 11.2.0.4.0
Oracle Starter Database                                              11.2.0.4.0
Oracle Text                                                          11.2.0.4.0
Oracle Text Required Support Files                                   11.2.0.4.0
Oracle UIX                                                           2.2.24.6.0
Oracle Universal Connection Pool                                     11.2.0.4.0
Oracle Universal Installer                                           11.2.0.4.0
Oracle USM Deconfiguration                                           11.2.0.4.0
Oracle Wallet Manager                                                11.2.0.4.0
Oracle XML Development Kit                                           11.2.0.4.0
Oracle XML Query                                                     11.2.0.4.0
Parser Generator Required Support Files                              11.2.0.4.0
Perl Interpreter                                                     5.10.0.0.2
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.4.0
PL/SQL Embedded Gateway                                              11.2.0.4.0
Platform Required Support Files                                      11.2.0.4.0
Precompiler Common Files                                             11.2.0.4.0
Precompiler Required Support Files                                   11.2.0.4.0
Provisioning Advisor Framework                                       10.2.0.4.3
RDBMS Required Support Files                                         11.2.0.4.0
RDBMS Required Support Files for Instant Client                      11.2.0.4.0
RDBMS Required Support Files Runtime                                 11.2.0.4.0
regexp                                                                2.1.9.0.0
Required Support Files                                               11.2.0.4.0
Sample Schema Data                                                   11.2.0.4.0
Secure Socket Layer                                                  11.2.0.4.0
SQL*Plus                                                             11.2.0.4.0
SQL*Plus Files for Instant Client                                    11.2.0.4.0
SQL*Plus Required Support Files                                      11.2.0.4.0
SQLJ Runtime                                                         11.2.0.4.0
SSL Required Support Files for InstantClient                         11.2.0.4.0
XDK Required Support Files                                           11.2.0.4.0
XML Parser for Java                                                  11.2.0.4.0
XML Parser for Oracle JVM                                            11.2.0.4.0
There are 136 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ which opatch
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ which opatch
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_19-08-59PM_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  24732075  25869727  26609445  26392168  26925576
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/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sdo, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.crs, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 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.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.util, 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.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms.dv, 11.2.0.4.0...
Patching component oracle.rdbms.oci, 11.2.0.4.0...
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.sysman.common, 10.2.0.4.5...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.common.core, 10.2.0.4.5...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.sysman.console.db, 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.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.5...
Applying sub-patch '22502456' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.tfa, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.olap, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '23054359' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms.dv, 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.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/u01/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...
Applying sub-patch '24732075' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.sysman.plugin.db.main.agent, 11.2.0.4.0...
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.util, 11.2.0.4.0...
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Patching component oracle.ordim.server, 11.2.0.4.0...
Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/db_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ]  not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.client, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.network.listener, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26925576' to OH '/u01/app/oracle/product/11.2.0/db_1'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
OPatch found the word "error" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
chmod: changing permissions of `/u01/app/oracle/product/11.2.0/db_1/bin/extjobO': Operation not permitted
make: [iextjob] Error 1 (ignored)
Composite patch 26925576 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_19-08-59PM_1.log
OPatch completed with warnings.
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
Due to root owned file
-------------------------------
[oracle@localhost ~]$ ls -lrt $ORACLE_HOME/bin/extjobO
-rwsr-x--- 1 root oinstall 1254244 Dec 20 19:13 /u01/app/oracle/product/11.2.0/db_1/bin/extjobO
[oracle@localhost ~]$


Applying Proactive Bundle / PSU Patch fails with Error: "chmod: changing permissions of '$ORACLE_HOME/bin/extjobO': Operation not permitted" (Doc ID 2265726.1)

CAUSE
This is due to the defect for which an internal bug is raised.

SOLUTION

The Issue / Warning "chmod: changing permissions of '$ORACLE_HOME/bin/extjobO'': Operation not permitted" can be ignored safely.
If you do not wish to see the above issue / warning, we need to change the permission of file '$ORACLE_HOME/bin/extjobO' before application of the patch.
This is also mentioned in Read Me of the Proactive Bundle Patches.



[oracle@localhost 26925576]$
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.18
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.18
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-30_19-19-57PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-30_19-19-57PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
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  26925576     : applied on Tue Jan 30 19:17:18 IST 2018
Unique Patch ID:  21773885
Patch description:  "Database Patch Set Update : 11.2.0.4.180116 (26925576)"
   Created on 5 Dec 2017, 05:23:24 hrs PST8PDT
Sub-patch  26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Sub-patch  26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch  25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch  24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch  24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
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:
     21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965
     20671094, 16731148, 16314254, 13837378, 18441944, 17835048, 13558557
     17008068, 17201159, 25427662, 17853498, 20717359, 17246576, 18356166
     18681862, 18440047, 20569094, 20031873, 16875449, 20387265, 19788842
     17296856, 21330264, 14010183, 17648596, 17551063, 17025461, 24719736
     17267114, 22507210, 17912217, 17889583, 18202441, 17040764, 17478145
     25655390, 16524926, 19358317, 22148226, 18747196, 26544823, 18641419
     17036973, 18948177, 17811789, 16542886, 14285317, 18009564, 16618694
     8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092
     24624166, 17848897, 17441661, 14034426, 17465741, 16596890, 17437634
     21343897, 20506706, 21453153, 18339044, 21795111, 22321741, 17951233
     18430495, 21787056, 22380919, 19469538, 20506715, 17811429, 17903598
     19721304, 18230522, 19554106, 19458377, 21281607, 17612828, 6599380
     22092979, 22321756, 17040527, 17811438, 18641461, 14657740, 13364795
     21387964, 19490948, 17346671, 17588480, 18235390, 26474853, 18849970
     17889549, 19309466, 16472716, 20596234, 18331850, 18641451, 17344412
     21179898, 19461270, 17546761, 24842886, 14521849, 18203835, 18203838
     18964939, 18203837, 17313525, 22195457, 18139690, 16837842, 22296366
     14106803, 17842825, 21352646, 22657942, 16360112, 20657441, 22195441
     17389192, 26198926, 14565184, 17205719, 18440095, 22195448, 14354737
     14764829, 13944971, 16571443, 21868720, 17186905, 17080436, 18673342
     22905130, 17027426, 19972569, 19972568, 20144308, 19972566, 17282229
     19972564, 16870214, 21629064, 19615136, 21354456, 17390431, 18762750
     23007241, 16613964, 17957017, 18098207, 18471685, 19730508, 21538485
     18264060, 17323222, 17754782, 17600719, 18317531, 17852463, 17596908
     17655634, 27053456, 16228604, 20074391, 19972570, 18090142, 18996843
     19854503, 16042673, 17835627, 20334344, 17393683, 18000422, 20861693
     17551709, 26575788, 23315889, 20506699, 19006849, 18277454, 18456514
     19174430, 17258090, 17174582, 25654936, 17242746, 16399083, 21132297
     17824637, 22465352, 17762296, 22168163, 17397545, 16450169, 12364061
     20067212, 18856999, 19211724, 19463893, 21343775, 19463897, 17853456
     18673304, 20004021, 26030218, 21668627, 16194160, 17477958, 16538760
     12982566, 24570598, 20828947, 20296213, 18259031, 18293054, 17610798
     19699191, 23065323, 17311728, 18135678, 23294548, 16785708, 10136473
     19777862, 22551446, 24560906, 17786518, 18315328, 18334586, 12747740
     18096714, 19032867, 21641760, 18899974, 17390160, 17232014, 20598042
     16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
     18554871, 23177648, 18051556, 20803583, 21972320, 15990359, 17922254
     18282562, 16855292, 16668584, 21343838, 20299015, 17446237, 18093615
     18043064, 23713236, 17694209, 17288409, 20475845, 17274537, 13955826
     16934803, 17634921, 17501491, 16315398, 22683212, 17006183, 13829543
     18191164, 22809871, 17655240, 26746894, 18384391, 19393542, 21538567
     16198143, 21847223, 25823754, 17892268, 20142975, 19584068, 25165496
     17165204, 21756699, 18508861, 16901385, 18554763, 21532755, 18189036
     17443671, 17385178, 17936109, 14829250, 20925795, 20509482, 17478514
     16850630, 13951456, 16595641, 14054676, 15861775, 21142837, 16912439
     17299889, 23003979, 17297939, 18619917, 16833527, 17798953, 17816865
     18607546, 17571306, 21286665, 17341326, 26910644, 17851160, 20558005
     17586955, 19049453, 21051840, 17587063, 16956380, 18328509, 25423453
     14133975, 18061914, 18522509, 21051833, 18765602, 20860659, 20324049
     18199537, 17332800, 13609098, 22502493, 18384537, 14338435, 17945983
     16392068, 21067387, 17752995, 21051862, 16863422, 25505382, 17237521
     18244962, 19544839, 24433711, 24717859, 17156148, 18973907, 23026585
     17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 21422580
     19466309, 25505371, 11733603, 18084625, 21051858, 18674024, 21051852
     18091059, 25369547, 16306373, 18306996, 18193833, 19915271, 17787259
     20513399, 20631274, 25879656, 16344544, 14692762, 18614015, 17346091
     18228645, 17721717, 18436307, 21756677, 19888853, 11883252, 17891943
     19475971, 22353199, 16384983, 19121551, 12816846, 17982555, 17761775
     22243719, 17265217, 25505394, 17071721, 16721594, 21756661, 18262334
     15913355, 17891946, 17672719, 17602269, 17239687, 17042658, 17238511
     17811456, 17284817, 17752121, 20879889, 21380789, 17394950, 16579084
     17011832, 22195465, 14602788, 18325460, 26569225, 24476265, 24476274
     12611721, 16903536, 17006570, 19689979, 16043574, 18783224, 24662775
     16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 24835538
     22195477, 17865671, 19013183, 17343514, 17325413, 18316692, 16180763
     17348614, 14368995, 21983325, 17393915, 16285691, 19211433, 20331945
     17883081, 24316947, 17705023, 17614227, 19578350, 22195485, 14084247
     13645875, 16777840, 19727057, 14852021, 18744139, 18674047, 17716305
     19285025, 18482502, 17622427, 19289642, 22195492, 25947799, 14458214
     20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504
     17082983, 21351877, 17365043, 13498382, 18331812, 16065166, 25489607
     16685417, 18031668, 22893153, 16943711, 19272701, 21517440, 25897615
     17649265, 13866822, 18094246, 24528741, 17783588, 14245531, 17082359
     20448824, 18280813, 23330119, 16268425, 25600421, 18018515, 17302277
     17215560, 24411921, 19271443, 25764020, 17016369, 20777150, 16756406
     23330124, 20441797, 19769489, 17545847, 25093656, 18260550, 13853126
     17227277, 23536835, 25957038, 24652769, 19207117, 9756271, 18868646
     17614134, 26667023, 17546973, 18704244, 19680952, 26667015, 17050888
     18828868, 18273830, 17360606, 16992075, 17375354, 12905058, 18362222
     21429602, 17571039, 17468141, 18436647, 17235750, 21168487, 16220077
     16929165
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@localhost 26925576]$



Post-patch work:


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.
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost 26925576]$
[oracle@localhost 26925576]$ cd $ORACLE_HOME/rdbms/admin
[oracle@localhost admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 30 19:26:46 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected.
SQL> @catbundle.sql psu apply


Verify the Ppatch applied or not?


SQL> SET linesize 200 pagesize 200

col action_time FOR a28
col version FOR a10
col comments FOR a35
col action FOR a25
col namespace FOR a12
SELECT * FROM registry$history;SQL> SQL> SQL> SQL> SQL> SQL>
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-DEC-17 07.23.32.986530 PM APPLY                     SERVER       11.2.0.4            0 Patchset 11.2.0.2.0                 PSU
30-JAN-18 07.28.54.687175 PM APPLY                     SERVER       11.2.0.4       180116 PSU 11.2.0.4.180116                 PSU
3 rows selected.
SQL>
SET linesize 200 pagesize 200
col action_time FOR a28
col version FOR a10
col comments FOR a35
col action FOR a25
col namespace FOR a12
select  *   from  dba_registry_history   order  by  action_time  desc ;
ACTION_TIME                    ACTION                    NAMESPACE    VERSION            ID BUNDLE_SERIES                  COMMENTS
------------------------------ ------------------------- ------------ ---------- ---------- ------------------------------ -----------------------------------
30-JAN-18 07.28.54.687175 PM   APPLY                     SERVER       11.2.0.4       180116 PSU                            PSU 11.2.0.4.180116
20-DEC-17 07.23.32.986530 PM   APPLY                     SERVER       11.2.0.4            0 PSU                            Patchset 11.2.0.2.0
24-AUG-13 12.03.45.119862 PM   APPLY                     SERVER       11.2.0.4            0 PSU                            Patchset 11.2.0.2.0

[oracle@localhost ~]$ opatch lspatches
26925576;Database Patch Set Update : 11.2.0.4.180116 (26925576)
OPatch succeeded.
[oracle@localhost ~]$

No comments:

Post a Comment