Manually
apply patch on Grid as well as Oracle home step by steps(11.2.0.4.)
1)
Download Oracle April Patch 2020 and opatch utility patch
a)
Patch 30805461 - Oracle Grid Infrastructure Patch Set Update
11.2.0.4.200414
b)
p6880880_112000_Linux-x86-64.zip
2)
Check opatch version and recommended to have latest opatch and
download it from oracle support (6880880) and unzip it in Grid Home
and all available home folder after renaming Old Opatch folder
You
must use the OPatch utility version 11.2.0.3.23 or later to apply
this patch.
We
need to apply patch on Grid first then each database running on that
node
3)
Stop Database and take backup of Inventory,Grid Home and Home binary
[oracrs@Node1
~]$
[oracrs@Node1
~]$ ps -ef|grep pmon
TES1TRAC
1105 1 0 Jun26 ? 00:17:44 ora_pmon_TES1TRAC1
oracrs
4926 1 0 Jun26 ? 00:11:33 asm_pmon_+ASM1
oracrs
6852 6707 0 08:27 pts/0 00:00:00 grep pmon
TES2TRAC
32029 1 0 Jun26 ? 00:20:14 ora_pmon_TES2TRAC1
fuo11nft
32732 1 0 Jun26 ? 00:20:33 ora_pmon_TES3TRAC1
[oracrs@Node1
~]$
To
Stop database instance
srvctl
stop instance -d TES1TRAC -i TES1TRAC1 -o immediate
srvctl
stop instance -d TES2TRAC -i TES2TRAC1 -o immediate
srvctl
stop instance -d TES3TRAC -i TES3TRAC1 -o immediate
To
check opatch version and validate inventory on Grid Home
[oracrs@Node1
OPatch]$ ./opatch lsinventory
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u02/oracle/11.2.0.4/grid
Central
Inventory : /u01/oracle/oraInventory
from
: /u02/oracle/11.2.0.4/grid/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_08-33-56AM_1.log
Lsinventory
Output file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/lsinv/lsinventory2020-07-21_08-33-56AM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname:
Node1
ARU
platform id: 226
ARU
platform description:: Linux x86-64
Installed
Top-level Products (1):
Oracle
Grid Infrastructure 11g
11.2.0.4.0
There
are 1 products installed in this Oracle Home.
There
are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch
succeeded.
[oracrs@Node1
OPatch]$ ./opatch version
OPatch
Version: 11.2.0.3.25
OPatch
succeeded.
[oracrs@Node1
OPatch]$
[oracrs@Node1
OPatch]$
stop
crs from root
+ASM1:/u02/oracle/11.2.0.4/grid:N
# line added by Agent
TES2TRAC:/u01/oracle/TES2TRAC/product/11.2.0.4:N
# line added by Agent
fuo11nft:/u01/oracle/fuo11nft/product/11.2.0.4:N
# line added by Agent
TES1TRAC:/u01/oracle/TES1TRAC/product/11.2.0.4:N
# line added by Agent
[root@Node1
~]# cd /u02/oracle/11.2.0.4/grid/bin
[root@Node1
bin]# ./crsctl stop crs
-
After stopping CRS and take backup of Grid inventory
cd
/u01/oracle/oraInventory
tar
-cvf /staging/grid_home_inventory.tar .
du
-hP /staging/grid_home_inventory.tar
unzip
downloaded patch from Grid user and change permission
chmod
-R 775 30805461
1)
start clusterware and stop database instance on one node
ps
-ef|grep pmon
ps
-ef|grep tns
Apply
patch on Grid home
------------------------
Patch
details
-----------
[oracrs@port1019ovl
30805461]$ ls -ltr
total
228
drwxrwxr-x
5 oracrs dba 4096 Jun 26 2019 29509309 - only grid
drwxrwxr-x
5 oracrs dba 4096 Aug 23 2019 29938455 -Both DB homes and Grid
home
drwxrwxr-x
28 oracrs dba 4096 Mar 20 07:09 30670774 - Both DB homes and Grid
home
-rwxrwxr-x
1 oracrs dba 128986 Mar 23 06:07 PatchSearch.xml
-rwxrwxr-x
1 oracrs dba 549 Mar 23 07:27 bundle.xml
-rwxrwxr-x
1 oracrs dba 0 Mar 23 07:28 README.txt
-rwxrwxr-x
1 oracrs dba 0 Mar 23 07:28 atp_lfp
-rwxrwxr-x
1 oracrs dba 85893 Apr 13 06:59 README.html
[oracrs@port1019ovl
30805461]$
30670774-Both
DB homes and Grid home
29938455-OCW
PATCH SET UPDATE 11.2.0.4.191015-Both DB homes and Grid home
29509309-ACFS
PATCH SET UPDATE 11.2.0.4.190716Footnote 1-Only Grid home
Validate
and update Opatch version and Grid Inventory
-----------------------------------------------------------------
update
opatch version taking backup of old opatch folder
and
unzipping newly download opatch as below
eg
from
root user
mv
OPatch OPatch_old
cp
/staging/patch_sf_2020/p6880880_112000_Linux-x86-64.zip
/u02/oracle/11.2.0.4/grid
unzip
p6880880_112000_Linux-x86-64.zip
chown
-R oracrs:dba OPatch
chmod
775 OPatch
[root@port1021ovl
grid]# chown -R oracrs:dba OPatch
[root@port1021ovl
grid]# chmod 775 OPatch
[root@port1021ovl
grid]# su - oracrs
and
set environment for GRID using Grid owner
[oracrs@TES1TRAC
l ~]$ . oraenv
ORACLE_SID
= [+ASM2] ?
[oracrs@
TES1TRAC ~]$ cd $ORACLE_HOME/OPatch
[oracrs@
TES1TRAC OPatch]$ ./opatch version
OPatch
Version: 11.2.0.3.25
OPatch
succeeded.
[oracrs@TES1TRAC
OPatch]$
[TES1TRAC@Node1
OPatch]$ ./opatch version
OPatch
Version: 11.2.0.3.25
OPatch
succeeded.
[TES1TRAC@Node1
OPatch]$
[TES1TRAC@Node1
OPatch]$
From
root user
unlock
grid home ,it will restart Grid automatically
cd
<$ORACLE_HOME>/crs/install
eg
cd
/u02/oracle/11.2.0.4/grid/crs/install
./rootcrs.pl
-unlock
From
Grid user apply patch manually on grid home
set
GRID HOME
/u02/oracle/11.2.0.4/grid/OPatch/opatch
lsinventory -detail -oh /u02/oracle/11.2.0.4/grid
cd
/u02/oracle/11.2.0.4/grid/OPatch
export
PATH=$PATH:/u02/oracle/11.2.0.4/grid/Opatch
opatch
napply -oh <Grid Home> -local /<Patch
location>/30805461/30670774
eg
opatch
napply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/30670774
opatch
apply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/29938455
opatch
apply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/29509309
Root
user lock grid home and start grid if not started automatically
cd
<Grid Home>/crs/install/rootcrs.pl -patch
cd
/u02/oracle/11.2.0.4/grid/crs/install/rootcrs.pl -patch
start
crs on node1
start
database on node1
==========Grid
Patch completed====================
Apply
patch on Each Oracle home and only two patch will applied on Oracle
Home
------------------------
Start
database one by one which database you want to be patched
srvctl
start instance -d TES1TRAC -i TES1TRAC1
srvctl
start instance -d TES2TRAC -i TES2TRAC1
srvctl
start instance -d TES3TRAC -i TES3TRAC1
1)
Validate and update Opatch version and inventory
mv
OPatch OPatch_old
cp
/staging/patch_sf_2020/p6880880_112000_Linux-x86-64.zip
/u01/oracle/TES2TRAC/product/11.2.0.4
unzip
p6880880_112000_Linux-x86-64.zip
2)
verify patch version
[TES1TRAC@Node1
OPatch]$ ./opatch version
OPatch
Version: 11.2.0.3.25
OPatch
succeeded.
[TES1TRAC@Node1
OPatch]$
Validate
inventory for each oracle RAC home
./opatch
lsinventory -detail -oh <Oracle Home>
eg
./opatch
lsinventory -detail -oh /u01/oracle/TES1TRAC/product/11.2.0.4
start
database instance
srvctl
start instance -d TES1TRAC -i TES1TRAC1
set
oracle home and run from instance owner
Apply
patch on oracle home as below
1)
run prepatch script
-------------
<patch_location>/29938455/custom/server/29938455/custom/scripts/prepatch.sh
-dbhome <Oracle Home>
eg
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/prepatch.sh
-dbhome /u01/oracle/TES1TRAC/product/11.2.0.4
Apply
first patch
--------------
$ORACLE_HOME/OPatch/opatch
napply -oh <Oracle Home> -local
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455
eg
$ORACLE_HOME/OPatch/opatch
napply -oh /u01/oracle/TES1TRAC/product/11.2.0.4 -local
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455
Go
to directory of patch and Apply Second patch
----------------------------------------------
cd
/staging/patch_sf_2020/30805461/30670774
export
PATH=$PATH:/u01/oracle/TES1TRAC/product/11.2.0.4/OPatch
opatch
apply
run
post patch script
----------------
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/postpatch.sh
-dbhome /u01/oracle/TES1TRAC/product/11.2.0.4
checked
applied patches
---------------
[fuo11nft@Node1
30670774]$ opatch lspatches
30670774;Database
Patch Set Update : 11.2.0.4.200414 (30670774)
29938455;OCW
Patch Set Update : 11.2.0.4.191015 (29938455)
OPatch
succeeded.
[fuo11nft@Node1
30670774]$
Database
need to started manually
srvctl
start instance -d TES1TRAC -i TES1TRAC1
load
modified SQL files
the
following steps load modified SQL files into the database. For an
Oracle RAC environment, perform these steps on only one node.
For
each database instance running on the Oracle home being patched,
connect to the database using SQL*Plus. Connect as SYSDBA and run the
catbundle.sql script as follows:
cd
$ORACLE_HOME/rdbms/admin
sqlplus
/nolog
SQL>
CONNECT / AS SYSDBA
SQL>
STARTUP
SQL>
@catbundle.sql psu apply
SQL>
QUIT
The
catbundle.sql execution is reflected in the dba_registry_history view
by a row associated with bundle series PSU.
For
information about the catbundle.sql script, see My Oracle Support
Document 605795.1 Introduction to Oracle Database catbundle.sql.
If
the OJVM PSU was applied for a previous GI PSU patch, you may see
invalid Java classes after execution of the catbundle.sql script in
the previous step. If this is the case, run utlrp.sql to re-validate
these Java classes.
cd
$ORACLE_HOME/rdbms/admin
sqlplus
/nolog
SQL>
CONNECT / AS SYSDBA
SQL>
@utlrp.sql
EXECUTE
dbms_stats.gather_dictionary_stats;
RMCPRD
rman_connect="rmc_hal_${DATABASE}/${DATABASE}_rmc_hal@${rman_sid}"
$
rman catalog username/password@RMCPRD
RMAN>
UPGRADE CATALOG;
verification
select
count(1) from dba_objects where status like 'INVALID'
/
set
lines 200 pages 200
col
action_time format a40
col
action format a30
col
namespace format a10
col
comments format a30
col
version format a13
set
lin 200 head on feed on pagesize 100
/
select
i.instance_name,r.* from v$instance i, registry$history r
/
set
lines 200 pages 200
/
column
comp_name format a50
/
SELECT
comp_id,comp_name, status, version FROM dba_registry
/
TVG16_IssueLogROW24_BlankDB
Mon
07/13/2020 5:30 PM - 6:30 PM
repeat
same step for other database home
Details
Apply
patch on Grid home
oracrs@Node1
patch_sf_2020]$
[oracrs@Node1
patch_sf_2020]$ ls -ltr
total
1365504
drwxr-xr-x
5 oracrs dba 4096 Mar 23 07:28 30805461
-rwxrwxr-x
1 oracrs dba 120388005 Jul 20 11:41 p6880880_112000_Linux-x86-64.zip
-rwxrwxr-x
1 oracrs dba 1277877242 Jul 20 11:42
p30805461_112040_Linux-x86-64.zip
[oracrs@Node1
patch_sf_2020]$ ls -ltr 30805461
total
228
drwxr-xr-x
5 oracrs dba 4096 Jun 26 2019 29509309
drwxr-xr-x
5 oracrs dba 4096 Aug 23 2019 29938455
drwxr-xr-x
28 oracrs dba 4096 Mar 20 07:09 30670774
-rw-rw-r--
1 oracrs dba 128986 Mar 23 06:07 PatchSearch.xml
-rw-r--r--
1 oracrs dba 549 Mar 23 07:27 bundle.xml
-rw-r--r--
1 oracrs dba 0 Mar 23 07:28 README.txt
-rw-r--r--
1 oracrs dba 0 Mar 23 07:28 atp_lfp
-rw-rw-r--
1 oracrs dba 85893 Apr 13 06:59 README.html
[oracrs@Node1
patch_sf_2020]$ unzip p30805461_112040_Linux-x86-64.zip
[oracrs@Node1
patch_sf_2020]$ chmod -R 775 30805461
[oracrs@Node1
patch_sf_2020]$ cd $ORACLE_HOME
[oracrs@Node1
grid]$
[oracrs@Node1
grid]$ ps -ef|grep pmon
oracrs
4849 1 0 10:11 ? 00:00:00 asm_pmon_+ASM1
oracrs
22493 20380 0 11:06 pts/0 00:00:00 grep pmon
[oracrs@Node1
grid]$ ps -ef|grep tns
root
29 2 0 10:09 ? 00:00:00 [netns]
oracrs
5934 1 0 10:11 ? 00:00:20
/u02/oracle/11.2.0.4/grid/bin/tnslsnr LISTENER -inherit
oracrs
5958 1 0 10:11 ? 00:00:00
/u02/oracle/11.2.0.4/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
oracrs
22497 20380 0 11:06 pts/0 00:00:00 grep tns
[oracrs@Node1
grid]$ cd OPatch
[oracrs@Node1
OPatch]$ ./opatch version
OPatch
Version: 11.2.0.3.25
OPatch
succeeded.
[oracrs@Node1
OPatch]$ /u02/oracle/11.2.0.4/grid/OPatch/opatch lsinventory -detail
-oh /u02/oracle/11.2.0.4/grid
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u02/oracle/11.2.0.4/grid
Central
Inventory : /u01/oracle/oraInventory
from
: /u02/oracle/11.2.0.4/grid/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-07-34AM_1.log
Lsinventory
Output file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/lsinv/lsinventory2020-07-21_11-07-34AM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname:
Node1
ARU
platform id: 226
ARU
platform description:: Linux x86-64
Installed
Top-level Products (1):
Oracle
Grid Infrastructure 11g
11.2.0.4.0
There
are 1 products installed in this Oracle Home.
Installed
Products (89):
Agent
Required Support Files
10.2.0.4.5
Assistant
Common Files 11.2.0.4.0
Automatic
Storage Management Assistant 11.2.0.4.0
Bali
Share
1.1.18.0.0
Buildtools
Common Files 11.2.0.4.0
Character
Set Migration Utility 11.2.0.4.0
Cluster
Ready Services Files
11.2.0.4.0
Cluster
Verification Utility Common Files
11.2.0.4.0
Cluster
Verification Utility Files
11.2.0.4.0
Database
SQL Scripts
11.2.0.4.0
Deinstallation
Tool 11.2.0.4.0
Enterprise
Manager Common Core Files 10.2.0.4.5
Enterprise
Manager Common Files 10.2.0.4.5
Enterprise
Manager plugin Common Files 11.2.0.4.0
Expat
libraries
2.0.1.0.1
HAS
Common Files
11.2.0.4.0
HAS
Files for DB
11.2.0.4.0
Installation
Common Files 11.2.0.4.0
Installation
Plugin Files 11.2.0.4.0
Installer
SDK Component 11.2.0.4.0
Java
Development Kit
1.5.0.51.10
LDAP
Required Support Files
11.2.0.4.0
OLAP
SQL Scripts
11.2.0.4.0
Oracle
Advanced Security
11.2.0.4.0
Oracle
Clusterware RDBMS Files
11.2.0.4.0
Oracle
Configuration Manager Deconfiguration
10.3.1.0.0
Oracle
Containers for Java
11.2.0.4.0
Oracle
Core Required Support Files
11.2.0.4.0
Oracle
Database 11g
11.2.0.4.0
Oracle
Database 11g Multimedia Files
11.2.0.4.0
Oracle
Database Deconfiguration
11.2.0.4.0
Oracle
Database User Interface
2.2.13.0.0
Oracle
Database Utilities
11.2.0.4.0
Oracle
DBCA Deconfiguration
11.2.0.4.0
Oracle
Extended Windowing Toolkit
3.4.47.0.0
Oracle
Globalization Support
11.2.0.4.0
Oracle
Globalization Support
11.2.0.4.0
Oracle
Grid Infrastructure 11g
11.2.0.4.0
Oracle
Help For Java
4.2.9.0.0
Oracle
Ice Browser
5.2.3.6.0
Oracle
Internet Directory Client
11.2.0.4.0
Oracle
Java Client
11.2.0.4.0
Oracle
JDBC/OCI Instant Client
11.2.0.4.0
Oracle
JDBC/THIN Interfaces
11.2.0.4.0
Oracle
JFC Extended Windowing Toolkit
4.2.36.0.0
Oracle
JVM
11.2.0.4.0
Oracle
LDAP administration
11.2.0.4.0
Oracle
Locale Builder
11.2.0.4.0
Oracle
Multimedia
11.2.0.4.0
Oracle
Multimedia Client Option
11.2.0.4.0
Oracle
Multimedia Java Advanced Imaging
11.2.0.4.0
Oracle
Multimedia Locator
11.2.0.4.0
Oracle
Multimedia Locator RDBMS Files
11.2.0.4.0
Oracle
Net
11.2.0.4.0
Oracle
Net Listener
11.2.0.4.0
Oracle
Net Required Support Files
11.2.0.4.0
Oracle
Netca Client
11.2.0.4.0
Oracle
Notification Service
11.2.0.3.0
Oracle
Notification Service (eONS)
11.2.0.4.0
Oracle
One-Off Patch Installer
11.2.0.3.4
Oracle
Quality of Service Management (Client)
11.2.0.4.0
Oracle
Quality of Service Management (Server)
11.2.0.4.0
Oracle
RAC Deconfiguration
11.2.0.4.0
Oracle
RAC Required Support Files-HAS
11.2.0.4.0
Oracle
Recovery Manager
11.2.0.4.0
Oracle
Security Developer Tools
11.2.0.4.0
Oracle
Text Required Support Files
11.2.0.4.0
Oracle
Universal Installer
11.2.0.4.0
Oracle
USM Deconfiguration
11.2.0.4.0
Oracle
Wallet Manager
11.2.0.4.0
Parser
Generator Required Support Files
11.2.0.4.0
Perl
Interpreter
5.10.0.0.2
Perl
Modules
5.10.0.0.1
PL/SQL
11.2.0.4.0
PL/SQL
Embedded Gateway
11.2.0.4.0
Platform
Required Support Files
11.2.0.4.0
Precompiler
Required Support Files 11.2.0.4.0
RDBMS
Required Support Files
11.2.0.4.0
RDBMS
Required Support Files for Instant Client
11.2.0.4.0
RDBMS
Required Support Files Runtime
11.2.0.4.0
Required
Support Files
11.2.0.4.0
Secure
Socket Layer
11.2.0.4.0
SQL*Plus
11.2.0.4.0
SQL*Plus
Files for Instant Client
11.2.0.4.0
SQL*Plus
Required Support Files
11.2.0.4.0
SSL
Required Support Files for InstantClient
11.2.0.4.0
Universal
Storage Manager Files 11.2.0.4.0
XDK
Required Support Files
11.2.0.4.0
XML
Parser for Java
11.2.0.4.0
There
are 89 products installed in this Oracle Home.
There
are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch
succeeded.
[oracrs@Node1
OPatch]$ cd cd /u02/oracle/11.2.0.4/grid/crs/install
-bash:
cd: cd: No such file or directory
[oracrs@Node1
OPatch]$ cd /u02/oracle/11.2.0.4/grid/crs/install
[oracrs@Node1
install]$ ls -ltr /staging/patch_sf_2020/30805461/30670774
total
176
-rwxrwxr-x
1 oracrs dba 21 Mar 20 07:04 README.txt
-rwxrwxr-x
1 oracrs dba 64562 Mar 20 07:04 README.html
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 24006111
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 22502456
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 26925576
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 23054359
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 29913194
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 19769489
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 26392168
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 30298532
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 29141056
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 24732075
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 20760982
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 18031668
drwxrwxr-x
5 oracrs dba 4096 Mar 20 07:04 29497421
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 25869727
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 27734982
drwxrwxr-x
5 oracrs dba 4096 Mar 20 07:04 28729262
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 26609445
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 19121551
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 21352635
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 18522509
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 17478514
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:04 21948347
drwxrwxr-x
5 oracrs dba 4096 Mar 20 07:05 28204707
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:05 20299013
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:05 27338049
drwxrwxr-x
4 oracrs dba 4096 Mar 20 07:05 30670774
-rwxrwxr-x
1 oracrs dba 3073 Mar 20 07:09 patchmd.xml
[oracrs@Node1
install]$ ls -ltr /staging/patch_sf_2020/30805461/29938455
total
32
drwxrwxr-x
4 oracrs dba 4096 Aug 23 2019 etc
drwxrwxr-x
4 oracrs dba 4096 Aug 23 2019 custom
-rwxrwxr-x
1 oracrs dba 18460 Aug 23 2019 README.txt
drwxrwxr-x
15 oracrs dba 4096 Aug 23 2019 files
[oracrs@Node1
install]$ ls -ltr /staging/patch_sf_2020/30805461/29509309
total
20
-rwxrwxr-x
1 oracrs dba 5956 Jun 26 2019 README.txt
drwxrwxr-x
4 oracrs dba 4096 Jun 26 2019 etc
drwxrwxr-x
3 oracrs dba 4096 Jun 26 2019 custom
drwxrwxr-x
6 oracrs dba 4096 Jun 26 2019 files
[oracrs@Node1
install]$ exit
logout
1)
unlock Grid home from root user
[root@Node1
grid]# cd cd /u02/oracle/11.2.0.4/grid/crs/install
[root@Node1
grid]# cd /u02/oracle/11.2.0.4/grid/crs/install
[root@Node1
install]# ./rootcrs.pl -unlock
Using
configuration parameter file: ./crsconfig_params
CRS-2791:
Starting shutdown of Oracle High Availability Services-managed
resources on 'Node1'
CRS-2673:
Attempting to stop 'ora.crsd' on 'Node1'
CRS-2790:
Starting shutdown of Cluster Ready Services-managed resources on
'Node1'
CRS-2673:
Attempting to stop 'ora.LISTENER.lsnr' on 'Node1'
CRS-2673:
Attempting to stop 'ora.DATA.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.registry.acfs' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FSBDATA.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FSBFLASH.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FUBDATA.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FUBFLASH.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FUODATA.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.FUOFLASH.dg' on 'Node1'
CRS-2673:
Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'Node1'
CRS-2677:
Stop of 'ora.LISTENER.lsnr' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.Node1.vip' on 'Node1'
CRS-2677:
Stop of 'ora.LISTENER_SCAN1.lsnr' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.scan1.vip' on 'Node1'
CRS-2677:
Stop of 'ora.FSBFLASH.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.FUBDATA.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.FUODATA.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.FSBDATA.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.registry.acfs' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.ACFS_CTRLM.dg' on 'Node1'
CRS-2677:
Stop of 'ora.FUOFLASH.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.Node1.vip' on 'Node1' succeeded
CRS-2672:
Attempting to start 'ora.Node1.vip' on 'port1019ovl'
CRS-2677:
Stop of 'ora.FUBFLASH.dg' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.scan1.vip' on 'Node1' succeeded
CRS-2672:
Attempting to start 'ora.scan1.vip' on 'port1019ovl'
CRS-2676:
Start of 'ora.Node1.vip' on 'port1019ovl' succeeded
CRS-2677:
Stop of 'ora.ACFS_CTRLM.dg' on 'Node1' succeeded
CRS-2676:
Start of 'ora.scan1.vip' on 'port1019ovl' succeeded
CRS-2672:
Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'port1019ovl'
CRS-2676:
Start of 'ora.LISTENER_SCAN1.lsnr' on 'port1019ovl' succeeded
CRS-2677:
Stop of 'ora.DATA.dg' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.asm' on 'Node1'
CRS-2677:
Stop of 'ora.asm' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.ons' on 'Node1'
CRS-2677:
Stop of 'ora.ons' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.net1.network' on 'Node1'
CRS-2677:
Stop of 'ora.net1.network' on 'Node1' succeeded
CRS-2792:
Shutdown of Cluster Ready Services-managed resources on 'Node1' has
completed
CRS-2677:
Stop of 'ora.crsd' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.ctssd' on 'Node1'
CRS-2673:
Attempting to stop 'ora.evmd' on 'Node1'
CRS-2673:
Attempting to stop 'ora.asm' on 'Node1'
CRS-2673:
Attempting to stop 'ora.mdnsd' on 'Node1'
CRS-2673:
Attempting to stop 'ora.drivers.acfs' on 'Node1'
CRS-2677:
Stop of 'ora.evmd' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.mdnsd' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.drivers.acfs' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.ctssd' on 'Node1' succeeded
CRS-2677:
Stop of 'ora.asm' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.cluster_interconnect.haip' on 'Node1'
CRS-2677:
Stop of 'ora.cluster_interconnect.haip' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.cssd' on 'Node1'
CRS-2677:
Stop of 'ora.cssd' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.crf' on 'Node1'
CRS-2677:
Stop of 'ora.crf' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.gipcd' on 'Node1'
CRS-2677:
Stop of 'ora.gipcd' on 'Node1' succeeded
CRS-2673:
Attempting to stop 'ora.gpnpd' on 'Node1'
CRS-2677:
Stop of 'ora.gpnpd' on 'Node1' succeeded
CRS-2793:
Shutdown of Oracle High Availability Services-managed resources on
'Node1' has completed
CRS-4133:
Oracle High Availability Services has been stopped.
Successfully
unlock /u02/oracle/11.2.0.4/grid
[root@Node1
install]#
3)
Start applying patch now
[oracrs@Node1
~]$ cd /u02/oracle/11.2.0.4/grid/OPatch
[oracrs@Node1
OPatch]$ export PATH=$PATH:/u02/oracle/11.2.0.4/grid/OPatch
[oracrs@Node1
OPatch]$ ls -ltr /staging/patch_sf_2020/30805461/29509309
total
20
-rwxrwxr-x
1 oracrs dba 5956 Jun 26 2019 README.txt
drwxrwxr-x
4 oracrs dba 4096 Jun 26 2019 etc
drwxrwxr-x
3 oracrs dba 4096 Jun 26 2019 custom
drwxrwxr-x
6 oracrs dba 4096 Jun 26 2019 files
[oracrs@Node1
OPatch]$ export PATH=$PATH:/u02/oracle/11.2.0.4/grid/OPatch
[oracrs@Node1
OPatch]$ opatch napply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/30670774
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u02/oracle/11.2.0.4/grid
Central
Inventory : /u01/oracle/oraInventory
from
: /u02/oracle/11.2.0.4/grid/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-17-14AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 17478514 18031668 18522509
19121551 19769489 20299013 20760982 21352635 21948347 22502456
23054359 24006111 24732075 25869727 26609445 26392168 26925576
27338049 27734982 28204707 28729262 29141056 29497421 29913194
30298532 30670774
Do
you want to proceed? [y|n]
y
User
Responded with: Y
All
checks passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the
local system.
(Oracle
Home = '/u02/oracle/11.2.0.4/grid')
Is
the local system ready for patching? [y|n]
y
User
Responded with: Y
Backing
up files...
Applying
sub-patch '17478514' to OH '/u02/oracle/11.2.0.4/grid'
ApplySession:
Optional component(s) [ oracle.sdo, 11.2.0.4.0 ] , [
oracle.sysman.agent, 10.2.0.4.5 ] , [ oracle.xdk, 11.2.0.4.0 ] not
present in the Oracle Home or a higher version is found.
Patching
component oracle.ldap.rsf.ic, 11.2.0.4.0...
Patching
component oracle.swd.oui, 11.2.0.4.0...
OPatch
found the word "error" in the stderr of the make command.
Please
look at this stderr. You can re-run this make command.
Stderr
output:
chmod:
changing permissions of `/u02/oracle/11.2.0.4/grid/bin/extjobO':
Operation not permitted
make:
[iextjob] Error 1 (ignored)
Composite
patch 30670774 successfully applied.
OPatch
Session completed with warnings.
Log
file location:
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-17-14AM_1.log
OPatch
completed with warnings.
apply
another patch
[oracrs@Node1
OPatch]$
[oracrs@Node1
OPatch]$
[oracrs@Node1
OPatch]$ opatch apply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/29938455
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u02/oracle/11.2.0.4/grid
Central
Inventory : /u01/oracle/oraInventory
from
: /u02/oracle/11.2.0.4/grid/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-21-31AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 29938455
Do
you want to proceed? [y|n]
y
User
Responded with: Y
All
checks passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the
local system.
(Oracle
Home = '/u02/oracle/11.2.0.4/grid')
Is
the local system ready for patching? [y|n]
y
User
Responded with: Y
Backing
up files...
Applying
interim patch '29938455' to OH '/u02/oracle/11.2.0.4/grid'
Patching
component oracle.crs, 11.2.0.4.0...
Patch
29938455 successfully applied.
Log
file location:
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-21-31AM_1.log
OPatch
succeeded.
apply
last patch
[oracrs@Node1
OPatch]$ opatch apply -oh /u02/oracle/11.2.0.4/grid -local
/staging/patch_sf_2020/30805461/29509309
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u02/oracle/11.2.0.4/grid
Central
Inventory : /u01/oracle/oraInventory
from
: /u02/oracle/11.2.0.4/grid/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-22-17AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 29509309
Do
you want to proceed? [y|n]
y
User
Responded with: Y
All
checks passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the
local system.
(Oracle
Home = '/u02/oracle/11.2.0.4/grid')
Is
the local system ready for patching? [y|n]
y
User
Responded with: Y
Backing
up files...
Applying
interim patch '29509309' to OH '/u02/oracle/11.2.0.4/grid'
Patching
component oracle.usm, 11.2.0.4.0...
Patch
29509309 successfully applied.
Log
file location:
/u02/oracle/11.2.0.4/grid/cfgtoollogs/opatch/opatch2020-07-21_11-22-17AM_1.log
OPatch
succeeded.
[oracrs@Node1
OPatch]$
root@Node1
install]# id
uid=0(root)
gid=0(root) groups=0(root)
[root@Node1
install]# cd cd /u02/oracle/11.2.0.4/grid//crs/install
[root@Node1
install]# cd /u02/oracle/11.2.0.4/grid//crs/install
[root@Node1
install]# ./rootcrs.pl -patch
Using
configuration parameter file: ./crsconfig_params
Installing
Trace File Analyzer
CRS-4123:
Oracle High Availability Services has been started.
[root@Node1
install]#
root@Node1
install]# ps -ef|grep pmon
oracrs
7072 1 0 11:26 ? 00:00:00 asm_pmon_+ASM1
root
9754 8575 0 11:29 pts/0 00:00:00 grep pmon
[root@Node1
install]#
Now
patching grid home completed
=================database
patching======================
1)
run prepatch after validating opatch version and inventory
drwxr-xr-x
4 RACDB dba 4096 Feb 1 2017 log
drwxr-xr-x
7 RACDB dba 4096 Feb 1 2017 install
drwxr-xr-x
4 RACDB dba 12288 Jan 24 2019 lib
drwxr-x---
15 RACDB dba 4096 Apr 22 11:49 OPatch
drwxr-xr-x
2 RACDB dba 4096 Jul 21 11:31 dbs
[RACDB@Node1
11.2.0.4]$ ls -ltr
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/prepatch.sh
-rwxrwxr-x
1 oracrs dba 4566 Aug 23 2019
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/prepatch.sh
[RACDB@Node1
11.2.0.4]$ cd OPatch
2)apply
patch on Database home
[RACDB@Node1
OPatch]$ ./opatch lsinventory -detail -oh
/u01/oracle/RACDB/product/11.2.0.4
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u01/oracle/RACDB/product/11.2.0.4
Central
Inventory : /u01/oracle/oraInventory
from
: /u01/oracle/RACDB/product/11.2.0.4/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-21_11-34-24AM_1.log
Lsinventory
Output file location :
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/lsinv/lsinventory2020-07-21_11-34-24AM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname:
Node1
ARU
platform id: 226
ARU
platform description:: Linux x86-64
Installed
Top-level Products (1):
Oracle
Database 11g
11.2.0.4.0
There
are 1 products installed in this Oracle Home.
Installed
Products (136):
Agent
Required Support Files
10.2.0.4.5
Assistant
Common Files 11.2.0.4.0
Bali
Share
1.1.18.0.0
Buildtools
Common Files 11.2.0.4.0
Character
Set Migration Utility 11.2.0.4.0
Cluster
Verification Utility Common Files
11.2.0.4.0
Database
Configuration and Upgrade Assistants
11.2.0.4.0
Database
SQL Scripts
11.2.0.4.0
Database
Workspace Manager
11.2.0.4.0
Deinstallation
Tool 11.2.0.4.0
Enterprise
Edition Options 11.2.0.4.0
Enterprise
Manager Agent 10.2.0.4.5
Enterprise
Manager Agent Core Files 10.2.0.4.5
Enterprise
Manager Common Core Files 10.2.0.4.5
Enterprise
Manager Common Files 10.2.0.4.5
Enterprise
Manager Database Plugin -- Agent Support 11.2.0.4.0
Enterprise
Manager Database Plugin -- Repository Support 11.2.0.4.0
Enterprise
Manager Grid Control Core Files 10.2.0.4.5
Enterprise
Manager plugin Common Files 11.2.0.4.0
Enterprise
Manager Repository Core Files 10.2.0.4.5
Exadata
Storage Server
11.2.0.1.0
Expat
libraries
2.0.1.0.1
Generic
Connectivity Common Files
11.2.0.4.0
HAS
Common Files
11.2.0.4.0
HAS
Files for DB
11.2.0.4.0
Installation
Common Files 11.2.0.4.0
Installation
Plugin Files 11.2.0.4.0
Installer
SDK Component 11.2.0.4.0
JAccelerator
(COMPANION) 11.2.0.4.0
Java
Development Kit
1.5.0.51.10
LDAP
Required Support Files
11.2.0.4.0
OLAP
SQL Scripts
11.2.0.4.0
Oracle
11g Warehouse Builder Required Files
11.2.0.4.0
Oracle
Advanced Security
11.2.0.4.0
Oracle
Application Express
11.2.0.4.0
Oracle
Call Interface (OCI)
11.2.0.4.0
Oracle
Clusterware RDBMS Files
11.2.0.4.0
Oracle
Code Editor
1.2.1.0.0I
Oracle
Configuration Manager
10.3.8.1.0
Oracle
Configuration Manager Client
10.3.2.1.0
Oracle
Configuration Manager Deconfiguration
10.3.1.0.0
Oracle
Containers for Java
11.2.0.4.0
Oracle
Core Required Support Files
11.2.0.4.0
Oracle
Data Mining RDBMS Files
11.2.0.4.0
Oracle
Database 11g
11.2.0.4.0
Oracle
Database 11g
11.2.0.4.0
Oracle
Database 11g Multimedia Files
11.2.0.4.0
Oracle
Database Deconfiguration
11.2.0.4.0
Oracle
Database Gateway for ODBC
11.2.0.4.0
Oracle
Database User Interface
2.2.13.0.0
Oracle
Database Utilities
11.2.0.4.0
Oracle
Database Vault J2EE Application
11.2.0.4.0
Oracle
Database Vault option
11.2.0.4.0
Oracle
DBCA Deconfiguration
11.2.0.4.0
Oracle
Display Fonts
9.0.2.0.0
Oracle
Enterprise Manager Console DB
11.2.0.4.0
Oracle
Extended Windowing Toolkit
3.4.47.0.0
Oracle
Globalization Support
11.2.0.4.0
Oracle
Globalization Support
11.2.0.4.0
Oracle
Help For Java
4.2.9.0.0
Oracle
Help for the Web
2.0.14.0.0
Oracle
Ice Browser
5.2.3.6.0
Oracle
Internet Directory Client
11.2.0.4.0
Oracle
Java Client
11.2.0.4.0
Oracle
JDBC Server Support Package
11.2.0.4.0
Oracle
JDBC/OCI Instant Client
11.2.0.4.0
Oracle
JDBC/THIN Interfaces
11.2.0.4.0
Oracle
JFC Extended Windowing Toolkit
4.2.36.0.0
Oracle
JVM
11.2.0.4.0
Oracle
Label Security
11.2.0.4.0
Oracle
LDAP administration
11.2.0.4.0
Oracle
Locale Builder
11.2.0.4.0
Oracle
Message Gateway Common Files
11.2.0.4.0
Oracle
Multimedia
11.2.0.4.0
Oracle
Multimedia Annotator
11.2.0.4.0
Oracle
Multimedia Client Option
11.2.0.4.0
Oracle
Multimedia Java Advanced Imaging
11.2.0.4.0
Oracle
Multimedia Locator
11.2.0.4.0
Oracle
Multimedia Locator RDBMS Files
11.2.0.4.0
Oracle
Net
11.2.0.4.0
Oracle
Net Listener
11.2.0.4.0
Oracle
Net Required Support Files
11.2.0.4.0
Oracle
Net Services
11.2.0.4.0
Oracle
Netca Client
11.2.0.4.0
Oracle
Notification Service
11.2.0.3.0
Oracle
Notification Service (eONS)
11.2.0.4.0
Oracle
ODBC Driver
11.2.0.4.0
Oracle
ODBC Driverfor Instant Client
11.2.0.4.0
Oracle
OLAP
11.2.0.4.0
Oracle
OLAP API
11.2.0.4.0
Oracle
OLAP RDBMS Files
11.2.0.4.0
Oracle
One-Off Patch Installer
11.2.0.3.4
Oracle
Partitioning
11.2.0.4.0
Oracle
Programmer
11.2.0.4.0
Oracle
Quality of Service Management (Client)
11.2.0.4.0
Oracle
RAC Deconfiguration
11.2.0.4.0
Oracle
RAC Required Support Files-HAS
11.2.0.4.0
Oracle
Real Application Testing
11.2.0.4.0
Oracle
Recovery Manager
11.2.0.4.0
Oracle
Security Developer Tools
11.2.0.4.0
Oracle
Spatial
11.2.0.4.0
Oracle
SQL Developer
11.2.0.4.0
Oracle
Starter Database
11.2.0.4.0
Oracle
Text
11.2.0.4.0
Oracle
Text Required Support Files
11.2.0.4.0
Oracle
UIX
2.2.24.6.0
Oracle
Universal Connection Pool
11.2.0.4.0
Oracle
Universal Installer
11.2.0.4.0
Oracle
USM Deconfiguration
11.2.0.4.0
Oracle
Wallet Manager
11.2.0.4.0
Oracle
XML Development Kit
11.2.0.4.0
Oracle
XML Query
11.2.0.4.0
Parser
Generator Required Support Files
11.2.0.4.0
Perl
Interpreter
5.10.0.0.2
Perl
Modules
5.10.0.0.1
PL/SQL
11.2.0.4.0
PL/SQL
Embedded Gateway
11.2.0.4.0
Platform
Required Support Files
11.2.0.4.0
Precompiler
Common Files 11.2.0.4.0
Precompiler
Required Support Files 11.2.0.4.0
Provisioning
Advisor Framework 10.2.0.4.3
RDBMS
Required Support Files
11.2.0.4.0
RDBMS
Required Support Files for Instant Client
11.2.0.4.0
RDBMS
Required Support Files Runtime
11.2.0.4.0
regexp
2.1.9.0.0
Required
Support Files
11.2.0.4.0
Sample
Schema Data
11.2.0.4.0
Secure
Socket Layer
11.2.0.4.0
SQL*Plus
11.2.0.4.0
SQL*Plus
Files for Instant Client
11.2.0.4.0
SQL*Plus
Required Support Files
11.2.0.4.0
SQLJ
Runtime
11.2.0.4.0
SSL
Required Support Files for InstantClient
11.2.0.4.0
XDK
Required Support Files
11.2.0.4.0
XML
Parser for Java
11.2.0.4.0
XML
Parser for Oracle JVM
11.2.0.4.0
There
are 136 products installed in this Oracle Home.
There
are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch
succeeded.
[RACDB@Node1
OPatch]$
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/prepatch.sh
-dbhome /u01/oracle/RACDB/product/11.2.0.4
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/prepatch.sh
completed successfully.
Apply
patch on oracle home
[RACDB@Node1
OPatch]$ $ORACLE_HOME/OPatch/opatch napply -oh
/u01/oracle/RACDB/product/11.2.0.4 -local
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u01/oracle/RACDB/product/11.2.0.4
Central
Inventory : /u01/oracle/oraInventory
from
: /u01/oracle/RACDB/product/11.2.0.4/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-21_11-34-57AM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 29938455
Do
you want to proceed? [y|n]
y
User
Responded with: Y
All
checks passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the
local system.
(Oracle
Home = '/u01/oracle/RACDB/product/11.2.0.4')
Is
the local system ready for patching? [y|n]
y
User
Responded with: Y
Backing
up files...
Applying
interim patch '29938455' to OH '/u01/oracle/RACDB/product/11.2.0.4'
Patching
component oracle.rdbms, 11.2.0.4.0...
Patch
29938455 successfully applied.
Log
file location:
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-21_11-34-57AM_1.log
OPatch
succeeded.
apply
another patch
[RACDB@Node1
OPatch]$ cd /staging/patch_sf_2020/30805461/30670774
[RACDB@Node1
30670774]$ export
PATH=$PATH:/u01/oracle/RACDB/product/11.2.0.4/OPatch
[RACDB@Node1
30670774]$ opatch apply
Oracle
Interim Patch Installer version 11.2.0.3.25
Copyright
(c) 2020, Oracle Corporation. All rights reserved.
Oracle
Home : /u01/oracle/RACDB/product/11.2.0.4
Central
Inventory : /u01/oracle/oraInventory
from
: /u01/oracle/RACDB/product/11.2.0.4/oraInst.loc
OPatch
version : 11.2.0.3.25
OUI
version : 11.2.0.4.0
Log
file location :
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-21_11-35-49AM_1.log
Patching
component oracle.swd.oui, 11.2.0.4.0...
Patching
component oracle.ctx, 11.2.0.4.0...
OPatch
found the word "error" in the stderr of the make command.
Please
look at this stderr. You can re-run this make command.
Stderr
output:
chmod:
changing permissions of
`/u01/oracle/RACDB/product/11.2.0.4/bin/extjobO': Operation not
permitted
make:
[iextjob] Error 1 (ignored)
Composite
patch 30670774 successfully applied.
OPatch
Session completed with warnings.
Log
file location:
/u01/oracle/RACDB/product/11.2.0.4/cfgtoollogs/opatch/opatch2020-07-21_11-35-49AM_1.log
OPatch
completed with warnings.
[RACDB@Node1
30670774]$
verify
patch
[RACDB@Node1
30670774]$ opatch lspatches
30670774;Database
Patch Set Update : 11.2.0.4.200414 (30670774)
29938455;OCW
Patch Set Update : 11.2.0.4.191015 (29938455)
OPatch
succeeded.
[RACDB@Node1
30670774]$
/staging/patch_sf_2020/30805461/29938455/custom/server/29938455/custom/scripts/postpatch.sh
-dbhome /u01/oracle/RACDB/product/11.2.0.4
Reading
/u01/oracle/RACDB/product/11.2.0.4/install/params.ora..
Reading
/u01/oracle/RACDB/product/11.2.0.4/install/params.ora..
Parsing
file /u01/oracle/RACDB/product/11.2.0.4/bin/racgwrap
Parsing
file /u01/oracle/RACDB/product/11.2.0.4/bin/srvctl
Parsing
file /u01/oracle/RACDB/product/11.2.0.4/bin/srvconfig
Parsing
file /u01/oracle/RACDB/product/11.2.0.4/bin/cluvfy
Verifying
file /u01/oracle/RACDB/product/11.2.0.4/bin/racgwrap
Verifying
file /u01/oracle/RACDB/product/11.2.0.4/bin/srvctl
Verifying
file /u01/oracle/RACDB/product/11.2.0.4/bin/srvconfig
Verifying
file /u01/oracle/RACDB/product/11.2.0.4/bin/cluvfy
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/racgwrap
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/srvctl
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/srvconfig
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/cluvfy
Reapplying
file permissions on
/u01/oracle/RACDB/product/11.2.0.4/bin/diskmon.bin
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/lsnodes
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/osdbagrp
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/rawutl
Reapplying
file permissions on
/u01/oracle/RACDB/product/11.2.0.4/srvm/admin/ractrans
Reapplying
file permissions on
/u01/oracle/RACDB/product/11.2.0.4/srvm/admin/getcrshome
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/gnsd
Reapplying
file permissions on /u01/oracle/RACDB/product/11.2.0.4/bin/crsdiag.pl
Postpatch
completed successfully
[RACDB@Node1
30670774]$
No comments:
Post a Comment