PSU PATCH on 11.2.0.4 Enterprise (Edition Primary and Standby server)
eg:
OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
#######################################################################
### Window Path set ###
set ORACLE_HOME=C:\app\varunyadav\product\12.1.0\dbhome_1
set PATH=%ORACLE_HOME%\OPatch;%PATH%
set PATH=%ORACLE_HOME%\perl\bin;%PATH%
### Linux Path Set ####
12c
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
11g
export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
############################## PSU Patch applied on Standby server #################################
STEP 1:
1. Download patch from oracle support
STEP 2 :
Transfer patch to primary and DR server
STEP 3 :
check optach version and opatch lsinventory
STEP 4 : FOR VERSION SUPPORT BEFORE APPLYING PATCH CHECK IT
unzip p6880880_112000_Linux-x86-64.zip (for version support)
mv OPatch OPatch_old
unzip p6880880_112000_Linux-x86-64.zip
make backup copy of oracle home
STEP 5 : AFTER COPYING AND UNZIP p6880880 RECHECK USING OPATCH LSINVENTORY
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
STEP6 :stop database and listener
STEP 7 : MAKE TAR FILE OF ORACLE HOME
cd /database/app/oracle/
tar -cvzf product.tar.gz product
STEP 8: GO TO PATCH LOCATION
cd /db02/patching_may17 and unzip the patch
STEP 9: set oracle home and path before patch
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
STEP 9: Run precheck opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
STEP 10 : APPLY PATCH
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
STEP 11 : AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
STEP 12 : (startup standby database server) and listener
--> sqlplus
--> startup mount
######################################################## APPLY PATCH ON PRODUCTION SERVER #################################################
GO TO PRODUCTION DATABASE AND FOLLOW THESE STEPS :
[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
STEP 1: STOP DATABASE AND LISTENER and agent , stop backup from oem12c or 13c (if it is scheduled from crontab than disable it)
[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
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> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop
cd /database/app/agent12c/agent_inst/bin
[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
STEP 2 : GO TO PATCH LOCATION AND CHECK PRE- REQUESTORIES
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
STEP 3 : APPLY PATCH
$ opatch apply
STEP 4 :
START DATABASE
[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> set head off
SQL> select * from registry$history order by id;
STEP 5: AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
./opatch lspatches
./opatch version
############################ Brief Summary #######################################
First apply patch on standby than apply it on production database.
Database : OWCSPROD
Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html -- Always read everthing written over there
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033 (OJVM)
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075(PSU)
Physical Standby Database
###########################################################################
1. Download patch from oracle support
2. Transfer patch to primary and DR server
3. check optach version and opatch lsinventory
4. unzip p6880880_112000_Linux-x86-64.zip (for version support)
mv OPatch OPatch_old
unzip p6880880_112000_Linux-x86-64.zip
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
4.stop database and listener
cd /database/app/oracle/
tar -cvzf product.tar.gz product
3. cd /db02/patching_may17 and unzip the patch
[914495421@731089-GCULUSRS01APP01 patching_may17]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 patching_may17]$ sqlplus / as sysdba
shutdown immediate;
[914495421@750960-GCBLUSRS02CCS01 24732075]$ ps -ef |grep lsnr
512 4492 3330 0 06:43 pts/1 00:00:00 grep lsnr
512 64905 1 0 06:29 ? 00:00:00 /database/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
[914495421@750960-GCBLUSRS02CCS01 24732075]$ lsnrctl stop
4. ls -lrt
drwxr-xr-x 4 914495421 oinstall 4096 Apr 17 05:41 25440428
-rw-rw-r-- 1 914495421 oinstall 80522 Apr 18 14:29 PatchSearch.xml
-rw-r--r-- 1 914495421 oinstall 152664496 May 26 12:43 p25440428_112040_Linux-x8
-rw-r--r-- 1 914495421 oinstall 99065778 May 27 07:33 p6880880_112000_Linux-x86
cd 25440428
5. set oracle home and path before patch
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_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
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$
###################################################
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_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 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log
Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.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 (2) :
Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944
Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
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:
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
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 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, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 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, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 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, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 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, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 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.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$
(startup standby database server)
sqlplus
startup mount
##################### Apply patch on production database ####################
production
[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
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> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop
cd /database/app/agent12c/agent_inst/bin
[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-46AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_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
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
or
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
########################################################################################################
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_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 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log
Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.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 (2) :
Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944
Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
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:
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
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 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, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 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, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 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, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 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, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 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.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$
Install the SQL portion of the patch by running the following command for a single instance environment.
cd $ORACLE_HOME/sqlpatch/25434033
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
SQL> set head off
SQL> select * from registry$history order by id;
24-AUG-13 12.03.45.119862 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU
16-DEC-15 03.52.59.628370 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU
28-MAY-17 03.21.23.641574 AM
APPLY SERVER
11.2.0.4.170418OJVMPSU 0
OJVM PSU post-install
28-MAY-17 03.21.23.591024 AM
jvmpsu.sql SERVER
11.2.0.4.170418OJVMPSU 0
RAN jvmpsu.sql
28-MAY-17 03.14.03.231179 AM
APPLY SERVER
11.2.0.4 170418
PSU 11.2.0.4.170418
PSU
28-MAY-17 03.21.23.644209 AM
APPLY
25434033
Patch 25434033 applied
6 rows selected.
SQL>
eg:
OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
#######################################################################
### Window Path set ###
set ORACLE_HOME=C:\app\varunyadav\product\12.1.0\dbhome_1
set PATH=%ORACLE_HOME%\OPatch;%PATH%
set PATH=%ORACLE_HOME%\perl\bin;%PATH%
### Linux Path Set ####
12c
export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
11g
export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
export PATH=$ORACLE_HOME/perl/bin:$PATH
############################## PSU Patch applied on Standby server #################################
STEP 1:
1. Download patch from oracle support
STEP 2 :
Transfer patch to primary and DR server
STEP 3 :
check optach version and opatch lsinventory
STEP 4 : FOR VERSION SUPPORT BEFORE APPLYING PATCH CHECK IT
unzip p6880880_112000_Linux-x86-64.zip (for version support)
mv OPatch OPatch_old
unzip p6880880_112000_Linux-x86-64.zip
make backup copy of oracle home
STEP 5 : AFTER COPYING AND UNZIP p6880880 RECHECK USING OPATCH LSINVENTORY
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
STEP6 :stop database and listener
STEP 7 : MAKE TAR FILE OF ORACLE HOME
cd /database/app/oracle/
tar -cvzf product.tar.gz product
STEP 8: GO TO PATCH LOCATION
cd /db02/patching_may17 and unzip the patch
STEP 9: set oracle home and path before patch
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
STEP 9: Run precheck opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
STEP 10 : APPLY PATCH
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
STEP 11 : AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
STEP 12 : (startup standby database server) and listener
--> sqlplus
--> startup mount
######################################################## APPLY PATCH ON PRODUCTION SERVER #################################################
GO TO PRODUCTION DATABASE AND FOLLOW THESE STEPS :
[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
STEP 1: STOP DATABASE AND LISTENER and agent , stop backup from oem12c or 13c (if it is scheduled from crontab than disable it)
[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
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> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop
cd /database/app/agent12c/agent_inst/bin
[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
STEP 2 : GO TO PATCH LOCATION AND CHECK PRE- REQUESTORIES
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
STEP 3 : APPLY PATCH
$ opatch apply
STEP 4 :
START DATABASE
[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> set head off
SQL> select * from registry$history order by id;
STEP 5: AFTER APPLYING PATCHES GO TO OPATCH LSINVENTORY AND CHECK THE SAME.
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
./opatch lspatches
./opatch version
############################ Brief Summary #######################################
First apply patch on standby than apply it on production database.
Database : OWCSPROD
Version : Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
OJVM +PPSU Patch April : p25440428_112040_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
p6880880_112000_Linux-x86-64.zip
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html -- Always read everthing written over there
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033 (OJVM)
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075(PSU)
Physical Standby Database
###########################################################################
1. Download patch from oracle support
2. Transfer patch to primary and DR server
3. check optach version and opatch lsinventory
4. unzip p6880880_112000_Linux-x86-64.zip (for version support)
mv OPatch OPatch_old
unzip p6880880_112000_Linux-x86-64.zip
cd /database/app/oracle/product/11.2.0/dbhome_1/OPatch
./opatch lsinventory
4.stop database and listener
cd /database/app/oracle/
tar -cvzf product.tar.gz product
3. cd /db02/patching_may17 and unzip the patch
[914495421@731089-GCULUSRS01APP01 patching_may17]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 patching_may17]$ sqlplus / as sysdba
shutdown immediate;
[914495421@750960-GCBLUSRS02CCS01 24732075]$ ps -ef |grep lsnr
512 4492 3330 0 06:43 pts/1 00:00:00 grep lsnr
512 64905 1 0 06:29 ? 00:00:00 /database/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
[914495421@750960-GCBLUSRS02CCS01 24732075]$ lsnrctl stop
4. ls -lrt
drwxr-xr-x 4 914495421 oinstall 4096 Apr 17 05:41 25440428
-rw-rw-r-- 1 914495421 oinstall 80522 Apr 18 14:29 PatchSearch.xml
-rw-r--r-- 1 914495421 oinstall 152664496 May 26 12:43 p25440428_112040_Linux-x8
-rw-r--r-- 1 914495421 oinstall 99065778 May 27 07:33 p6880880_112000_Linux-x86
cd 25440428
5. set oracle home and path before patch
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@750960-GCBLUSRS02CCS01 patching_may17]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ ls -lrt
total 28
-rw-r--r-- 1 914495421 oinstall 19578 Apr 17 05:41 README.html
drwxr-xr-x 5 914495421 oinstall 4096 Apr 17 05:41 25434033
drwxr-xr-x 15 914495421 oinstall 4096 Apr 17 05:41 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 24732075
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-42-51AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_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
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-44-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 24732075]$
###################################################
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_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 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log
Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.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 (2) :
Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944
Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
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:
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
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 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, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 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, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 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, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 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, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 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.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$
(startup standby database server)
sqlplus
startup mount
##################### Apply patch on production database ####################
production
[914495421@731089-GCULUSRS01APP01 ~]$ ps -ef |grep pmon
784 8386 1 0 2016 ? 00:39:20 ora_pmon_owcsprod
784 45714 44571 0 03:01 pts/1 00:00:00 grep pmon
[914495421@731089-GCULUSRS01APP01 ~]$ . oraenv
ORACLE_SID = [914495421] ? owcsprod
The Oracle base has been set to /database/app/oracle
[914495421@731089-GCULUSRS01APP01 ~]$ sqlplus sys@owcsprod as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:01:47 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
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> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
OWCSPROD READ WRITE PRIMARY
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[914495421@731089-GCULUSRS01APP01 ~]$ lsnrctl stop
cd /database/app/agent12c/agent_inst/bin
[914495421@731089-GCULUSRS01APP01 bin]$ ./emctl stop agent
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
[914495421@731089-GCULUSRS01APP01 OPatch]$ export ORACLE_HOME=/database/app/oracle/product/11.2.0/dbhome_1
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/OPatch:$PATH:$ORACLE_HOME/bin
[914495421@731089-GCULUSRS01APP01 OPatch]$
[914495421@731089-GCULUSRS01APP01 OPatch]$ export PATH=$ORACLE_HOME/perl/bin:$PATH
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-46AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_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
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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 '/database/app/oracle/product/11.2.0/dbhome_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...
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$
Composite patch 24732075 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_03-07-54AM_1.log
OPatch succeeded.
[914495421@731089-GCULUSRS01APP01 24732075]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 28 03:11:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> CONNECT / AS SYSDBA
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3290345472 bytes
Fixed Size 2257720 bytes
Variable Size 1828719816 bytes
Database Buffers 1442840576 bytes
Redo Buffers 16527360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catbundle.sql psu apply
or
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
########################################################################################################
[914495421@750960-GCBLUSRS02CCS01 25440428]$ cd 25434033
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-53-47AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ ./opatch apply
-bash: ./opatch: No such file or directory
[914495421@750960-GCBLUSRS02CCS01 25434033]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25434033
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 = '/database/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '25434033' to OH '/database/app/oracle/product/11.2.0/dbhome_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 25434033 successfully applied.
Log file location: /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-54-10AM_1.log
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$
OPatch succeeded.
[914495421@750960-GCBLUSRS02CCS01 25434033]$ cd $ORACLE_HOME
[914495421@750960-GCBLUSRS02CCS01 dbhome_1]$ cd OPatch
[914495421@750960-GCBLUSRS02CCS01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.16
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /database/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /database/app/oraInventory
from : /database/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.16
OUI version : 11.2.0.4.0
Log file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2017-05-28_06-55-58AM_1.log
Lsinventory Output file location : /database/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-28_06-55-58AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 750960-GCBLUSRS02CCS01.genpact.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 (2) :
Patch 25434033 : applied on Sun May 28 06:54:41 UTC 2017
Unique Patch ID: 21061924
Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.170418"
Created on 28 Feb 2017, 08:19:35 hrs PST8PDT
Bugs fixed:
18933818, 19176885, 17201047, 25067795, 14774730, 19153980, 21911849
23727132, 18166577, 24448240, 17056813, 21811517, 19909862, 25494379
22675136, 24534298, 19895326, 22253904, 17804361, 19231857, 17528315
19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988
23265914, 19006757, 19374518, 19223010, 25076732, 22118835, 19852360
20408829, 21047766, 21566944
Patch 24732075 : applied on Sun May 28 06:46:21 UTC 2017
Unique Patch ID: 21176096
Patch description: "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Created on 22 Feb 2017, 21:40:49 hrs PST8PDT
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:
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
17612828, 6599380, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
24842886, 17546761, 18203835, 18964939, 18203838, 18203837, 17313525
22195457, 18139690, 16837842, 22296366, 14106803, 17842825, 22657942
21352646, 20657441, 16360112, 22195441, 17389192, 14565184, 17205719
18440095, 22195448, 14354737, 14764829, 13944971, 16571443, 21868720
17186905, 17080436, 18673342, 22905130, 17027426, 19972569, 19972568
19972566, 17282229, 19972564, 16870214, 19615136, 17390431, 18762750
16613964, 18098207, 17957017, 18471685, 19730508, 21538485, 18264060
17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 17655634
16228604, 20074391, 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, 24560906, 17786518
18315328, 18334586, 12747740, 19032867, 18096714, 17390160, 17232014
16422541, 18673325, 18155762, 14015842, 19827973, 22683225, 17726838
18554871, 23177648, 18051556, 20803583, 17922254, 15990359, 21972320
18282562, 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, 25505382, 17237521, 16863422, 18244962
19544839, 24433711, 17156148, 18973907, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 25369547, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 21756677, 11883252, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
25505394, 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, 17622427
19289642, 22195492, 14458214, 18723434, 17767676, 25505407, 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, 24411921, 19271443, 17016369, 20777150
23330124, 20441797, 19769489, 25093656, 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.
[914495421@750960-GCBLUSRS02CCS01 OPatch]$
Install the SQL portion of the patch by running the following command for a single instance environment.
cd $ORACLE_HOME/sqlpatch/25434033
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
SQL> set head off
SQL> select * from registry$history order by id;
24-AUG-13 12.03.45.119862 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU
16-DEC-15 03.52.59.628370 PM
APPLY SERVER
11.2.0.4 0
Patchset 11.2.0.2.0
PSU
28-MAY-17 03.21.23.641574 AM
APPLY SERVER
11.2.0.4.170418OJVMPSU 0
OJVM PSU post-install
28-MAY-17 03.21.23.591024 AM
jvmpsu.sql SERVER
11.2.0.4.170418OJVMPSU 0
RAN jvmpsu.sql
28-MAY-17 03.14.03.231179 AM
APPLY SERVER
11.2.0.4 170418
PSU 11.2.0.4.170418
PSU
28-MAY-17 03.21.23.644209 AM
APPLY
25434033
Patch 25434033 applied
6 rows selected.
SQL>
No comments:
Post a Comment