oracle rac 11.2.0.3 生产环境打补丁过程

最新推荐文章于 2022-05-11 15:28:34 发布

liaodp

最新推荐文章于 2022-05-11 15:28:34 发布

阅读量268

点赞数

分类专栏： oracle 11g rac

本文链接：https://blog.csdn.net/liaodp/article/details/105368341

版权

oracle 11g rac 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

[root@rac1 /]# cd /oracle/app/grid/product/11.2.0/
[root@rac1 11.2.0]# mv OPatch/ OPatch_grid.bak
[root@rac1 11.2.0]# cd /oracle/app/oracle/product/11.2.0/
[root@rac1 11.2.0]# mv OPatch/ OPatch_oracle.bak

[root@rac2 /]# cd /oracle/app/grid/product/11.2.0/
[root@rac2 11.2.0]# mv OPatch/ OPatch_grid.bak
[root@rac2 11.2.0]# cd /oracle/app/oracle/product/11.2.0/
[root@rac2 11.2.0]# mv OPatch/ OPatch_oracle.bak

[grid@rac1 patch]$ cd /oracle/app/grid/product/11.2.0/OPatch_grid.bak/
[grid@rac1 OPatch_grid.bak]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7

Oracle Home : /oracle/app/grid/product/11.2.0
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_10-40-36AM.log

Lsinventory Output file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_10-40-36AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2

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

OPatch succeeded.

[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$ cd /oracle/app/oracle/product/11.2.0/OPatch_oracle.bak/
[oracle@rac1 OPatch_oracle.bak]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7

Oracle Home : /oracle/app/oracle/product/11.2.0
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_10-44-34AM.log

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_10-44-34AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2

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

OPatch succeeded.

[grid@rac2 ~]$ cd /oracle/app/grid/product/11.2.0/OPatch_grid.bak/
[grid@rac2 OPatch_grid.bak]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7

Lsinventory Output file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_10-45-41AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
Local node = rac2
Remote node = rac1

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

OPatch succeeded.

[root@rac2 11.2.0]# su - oracle
[oracle@rac2 ~]$ cd /oracle/app/oracle/product/11.2.0/OPatch_oracle.bak/
[oracle@rac2 OPatch_oracle.bak]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_10-46-43AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
Local node = rac2
Remote node = rac1

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

OPatch succeeded.

[root@rac1 11.2.0]# mkdir /patch
[root@rac1 11.2.0]# chown 777 /patch/

[root@rac2 11.2.0]# mkdir /patch
[root@rac2 11.2.0]# chown 777 /patch/

[root@rac1 ~]# scp /patch/* root@59.231.150.5:/patch/
root@59.231.150.5's password:
p20760997_112030_Linux-x86-64.zip 100% 101MB 50.4MB/s 00:02
p20996944_112030_Linux-x86-64.zip 100% 600MB 40.0MB/s 00:15
p6880880_112000_Linux-x86-64.zip 100% 112MB 22.4MB/s 00:05

[root@rac1 ~]# cd /patch/
[root@rac1 patch]# unzip p6880880_112000_Linux-x86-64.zip
[root@rac1 patch]# mv OPatch/ /oracle/app/grid/product/11.2.0/
[root@rac1 patch]# chown -R grid:oinstall /oracle/app/grid/product/11.2.0/OPatch

[root@rac1 patch]# unzip p6880880_112000_Linux-x86-64.zip
[root@rac1 patch]# mv OPatch/ /oracle/app/oracle/product/11.2.0/
[root@rac1 patch]# chown -R oracle:oinstall //oracle/app/oracle/product/11.2.0/OPatch

[root@rac2 ~]# cd /patch/
[root@rac2 patch]# unzip p6880880_112000_Linux-x86-64.zip
[root@rac2 patch]# mv OPatch/ /oracle/app/grid/product/11.2.0/
[root@rac2 patch]# chown -R grid:oinstall /oracle/app/grid/product/11.2.0/OPatch

[root@rac2 patch]# unzip p6880880_112000_Linux-x86-64.zip
[root@rac2 patch]# mv OPatch/ /oracle/app/oracle/product/11.2.0/
[root@rac2 patch]# chown -R oracle:oinstall //oracle/app/oracle/product/11.2.0/OPatch

[root@rac1 patch]# su - grid
[grid@rac1 ~]$ cd /oracle/app/grid/product/11.2.0/OPatch

[grid@rac1 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home "/oracle/app/grid/product/11.2.0".
OPatch succeeded.

[grid@rac1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/grid/product/11.2.0
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/grid/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.3.0
Log file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_11-04-32AM_1.log

Lsinventory Output file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_11-04-32AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1.csssfw.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[root@rac1 patch]# su - oracle
[oracle@rac1 ~]$ cd /oracle/app/oracle/product/11.2.0/OPatch

[oracle@rac1 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home "/oracle/app/oracle/product/11.2.0".
OPatch succeeded.

[oracle@rac1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/oracle/product/11.2.0
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_11-06-07AM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_11-06-07AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1.csssfw.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[root@rac2 patch]# su - grid
[grid@rac2 ~]$ cd /oracle/app/grid/product/11.2.0/OPatch
[grid@rac2 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home "/oracle/app/grid/product/11.2.0".

OPatch succeeded.
[grid@rac2 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Lsinventory Output file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_11-10-12AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2.csssfw.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[root@rac2 patch]# su - oracle
[oracle@rac2 ~]$ cd /oracle/app/oracle/product/11.2.0/OPatch
[oracle@rac2 OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home "/oracle/app/oracle/product/11.2.0".

OPatch succeeded.
[oracle@rac2 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-03-13_11-11-10AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2.csssfw.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[grid@rac1 ~]$ cd /patch/

[grid@rac1 patch]$ unzip p20760997_112030_Linux-x86-64.zip

[grid@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch/20760997/ -oh /oracle/app/grid/product/11.2.0
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /oracle/app/grid/product/11.2.0
Central Inventory : /oracle/app/oraInventory

from : /oracle/app/grid/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.3.0
Log file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_11-40-55AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[root@rac2 patch]# chown -R grid:oinstall /patch/
[root@rac2 patch]# su - grid
[grid@rac2 ~]$ cd /patch/
[grid@rac2 patch]$ ls -lt
total 832916
-rw-r--r-- 1 grid oinstall 117648293 Mar 13 10:49 p6880880_112000_Linux-x86-64.zip
-rw-r--r-- 1 grid oinstall 628780568 Mar 13 10:49 p20996944_112030_Linux-x86-64.zip
-rw-r--r-- 1 grid oinstall 105622727 Mar 13 10:49 p20760997_112030_Linux-x86-64.zip
[grid@rac2 patch]$ unzip p20760997_112030_Linux-x86-64.zip

[grid@rac2 patch]$ cd /oracle/app/grid/product/11.2.0/OPatch
[grid@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch/20760997/ -oh /oracle/app/grid/product/11.2.0
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@rac1 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch/20760997/ -oh /oracle/app/oracle/product/11.2.0/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /oracle/app/oracle/product/11.2.0
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/oracle/product/11.2.0//oraInst.loc
OPatch version : 11.2.0.3.23
OUI version : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_11-59-20AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@rac2 OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /patch/20760997/ -oh /oracle/app/oracle/product/11.2.0/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

PREREQ session

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[root@rac1 /]# su - grid
[grid@rac1 ~]$ srvctl stop scan_listener
[grid@rac1 ~]$ srvctl stop listener

[root@rac1 /]# su - oracle
[oracle@rac1 ~]$ srvctl stop database -d ssdj
[oracle@rac1 ~]$ srvctl stop database -d gspt

[root@rac1 install]# pwd
/oracle/app/grid/product/11.2.0/crs/install
[root@rac1 11.2.0]# crs/install/rootcrs.pl -unlock
Using configuration parameter file: crs/install/crsconfig_params
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac2'
CRS-2677: Stop of 'ora.scan3.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'rac2'
CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ARCH.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2676: Start of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2676: Start of 'ora.scan3.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac1'
CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'
CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oracle/app/grid/product/11.2.0

[root@rac2 install]# pwd
/oracle/app/grid/product/11.2.0/crs/install
[root@rac2 11.2.0]# crs/install/rootcrs.pl -unlock
Using configuration parameter file: crs/install/crsconfig_params
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac2'
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac2'
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac2'
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.ARCH.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'
CRS-2677: Stop of 'ora.scan3.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ARCH.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac2' succeeded
CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac2'
CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'
CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'rac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'
CRS-2677: Stop of 'ora.crf' on 'rac2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'
CRS-2677: Stop of 'ora.gipcd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'
CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oracle/app/grid/product/11.2.0

[root@rac1 install]# ps -ef |grep ora
root 3100 3072 0 Mar09 ? 00:01:07 hald-addon-storage: polling /dev/sr0
root 30275 11160 0 14:21 pts/1 00:00:00 grep ora

[root@rac2 install]# ps -ef |grep ora
root 3102 3074 0 Mar09 ? 00:01:25 hald-addon-storage: polling /dev/sr0
root 20823 7982 0 14:21 pts/1 00:00:00 grep ora

[root@rac1 install]# su - grid
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/20760997/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043 17540582 18031683 18522512 19121548 19769496 20299017 20760997

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y

[root@rac2 install]# su - grid

[grid@rac2 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/20760997/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...

[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/20760997/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/oracle/app/oracle/product/11.2.0'

[oracle@rac2 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/20760997/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y

[root@rac1 patch]# su - grid
[grid@rac1 ~]$ cd /patch/
[grid@rac1 patch]$ ls
p20760997_112030_Linux-x86-64.zip p20996944_112030_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip
[grid@rac1 patch]$ unzip p20996944_112030_Linux-x86-64.zip

[root@rac2 patch]# su - grid
[grid@rac2 ~]$ cd /patch/
[grid@rac2 patch]$ ls
p20760997_112030_Linux-x86-64.zip p20996944_112030_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip
[grid@rac2 patch]$ unzip p20996944_112030_Linux-x86-64.zip

[grid@rac1 17592127]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/17592127/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17592127

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17592127' to OH '/oracle/app/grid/product/11.2.0'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...
Patch 17592127 successfully applied.
Log file location: /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_14-58-36PM_1.log

OPatch succeeded.

[grid@rac2 patch]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/17592127/
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17592127

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17592127' to OH '/oracle/app/grid/product/11.2.0'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...
Patch 17592127 successfully applied.
Log file location: /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_15-01-22PM_1.log

OPatch succeeded.

[oracle@rac1 scripts]$ /patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh completed successfully.

[oracle@rac1 17592127]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/17592127/custom/server/17592127
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17592127

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17592127' to OH '/oracle/app/oracle/product/11.2.0'

Patching component oracle.rdbms, 11.2.0.3.0...
Patch 17592127 successfully applied.
Log file location: /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_15-08-59PM_1.log

OPatch succeeded.

[oracle@rac2 ~]$ /patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh completed successfully.
[oracle@rac2 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/17592127/custom/server/17592127
Oracle Interim Patch Installer version 11.2.0.3.23
Copyright (c) 2020, Oracle Corporation. All rights reserved.

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17592127

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

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17592127' to OH '/oracle/app/oracle/product/11.2.0'

Patching component oracle.rdbms, 11.2.0.3.0...
Patch 17592127 successfully applied.
Log file location: /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-03-13_15-12-00PM_1.log

OPatch succeeded.

[oracle@rac1 17592127]$ /patch/17592127/custom/server/17592127/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /oracle/app/oracle/product/11.2.0/install/params.ora..
Reading /oracle/app/oracle/product/11.2.0/install/params.ora..
Parsing file /oracle/app/oracle/product/11.2.0/bin/racgwrap
Parsing file /oracle/app/oracle/product/11.2.0/bin/srvctl
Parsing file /oracle/app/oracle/product/11.2.0/bin/srvconfig
Parsing file /oracle/app/oracle/product/11.2.0/bin/cluvfy
Verifying file /oracle/app/oracle/product/11.2.0/bin/racgwrap
Verifying file /oracle/app/oracle/product/11.2.0/bin/srvctl
Verifying file /oracle/app/oracle/product/11.2.0/bin/srvconfig
Verifying file /oracle/app/oracle/product/11.2.0/bin/cluvfy
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/racgwrap
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/srvctl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/srvconfig
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/cluvfy
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/diskmon.bin
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/lsnodes
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/osdbagrp
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/rawutl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/srvm/admin/ractrans
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/srvm/admin/getcrshome
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/gnsd
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/crsdiag.pl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libhasgen11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libclsra11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libdbcfg11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocr11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocrb11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocrutl11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libuini11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/librdjni11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libgns11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libgnsjni11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libagfw11.so

[oracle@rac2 ~]$ /patch/17592127/custom/server/17592127/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /oracle/app/oracle/product/11.2.0/install/params.ora..
Reading /oracle/app/oracle/product/11.2.0/install/params.ora..
Parsing file /oracle/app/oracle/product/11.2.0/bin/racgwrap
Parsing file /oracle/app/oracle/product/11.2.0/bin/srvctl
Parsing file /oracle/app/oracle/product/11.2.0/bin/srvconfig
Parsing file /oracle/app/oracle/product/11.2.0/bin/cluvfy
Verifying file /oracle/app/oracle/product/11.2.0/bin/racgwrap
Verifying file /oracle/app/oracle/product/11.2.0/bin/srvctl
Verifying file /oracle/app/oracle/product/11.2.0/bin/srvconfig
Verifying file /oracle/app/oracle/product/11.2.0/bin/cluvfy
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/racgwrap
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/srvctl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/srvconfig
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/cluvfy
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/diskmon.bin
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/lsnodes
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/osdbagrp
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/rawutl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/srvm/admin/ractrans
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/srvm/admin/getcrshome
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/gnsd
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/bin/crsdiag.pl
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libhasgen11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libclsra11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libdbcfg11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocr11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocrb11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libocrutl11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libuini11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/librdjni11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libgns11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libgnsjni11.so
Reapplying file permissions on /oracle/app/oracle/product/11.2.0/lib/libagfw11.so

[root@rac1 patch]# /oracle/app/grid/product/11.2.0/rdbms/install/rootadd_rdbms.sh
[root@rac2 patch]# /oracle/app/grid/product/11.2.0/rdbms/install/rootadd_rdbms.sh

[root@rac1 patch]# /oracle/app/grid/product/11.2.0/crs/install/rootcrs.pl -patch
Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.

[root@rac2 patch]# /oracle/app/grid/product/11.2.0/crs/install/rootcrs.pl -patch
Using configuration parameter file: /oracle/app/grid/product/11.2.0/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.

[oracle@rac1 ~]$ srvctl start database -d ssdj
[oracle@rac1 ~]$ srvctl start database -d gspt

[oracle@rac1 ~]$ export ORACLE_SID=ssdj1
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 13 15:35:08 2020

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> @?/rdbms/admin/catbundle.sql psu apply

PL/SQL procedure successfully completed.
SQL> @?/rdbms/admin/utlrp.sql

[oracle@rac1 ~]$ export ORACLE_SID=ssdj1
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 13 15:44:43 2020

col action_time for a30
col version for a15
col id for 99
col action for a10
col namespace for a10
col COMMENTS for a20
col BUNDLE_SERIES for a15
set linesize 200;
SQL> select * from registry$history;

[oracle@rac1 ~]$ /oracle/app/oracle/product/11.2.0/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME |grep -i patch
Oracle Interim Patch Installer version 11.2.0.3.23
OPatch version : 11.2.0.3.23
Log file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/opatch2020-04-03_23-36-06PM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-04-03_23-36-06PM.txt
Oracle One-Off Patch Installer 11.2.0.1.7
Interim patches (2) :
Patch 17592127 : applied on Fri Apr 03 21:52:45 CST 2020
Unique Patch ID: 16995168
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
Patch Location in Inventory:
Patch Location in Storage area:
/oracle/app/oracle/product/11.2.0/.patch_storage/17592127_Jan_9_2014_07_26_53
Patch 20760997 : applied on Fri Apr 03 21:37:14 CST 2020
Unique Patch ID: 18966522
Patch description: "Database Patch Set Update : 11.2.0.3.15 (20760997)"
Sub-patch 20299017; "Database Patch Set Update : 11.2.0.3.14 (20299017)"
Sub-patch 19769496; "Database Patch Set Update : 11.2.0.3.13 (19769496)"
Sub-patch 19121548; "Database Patch Set Update : 11.2.0.3.12 (19121548)"
Sub-patch 18522512; "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Sub-patch 18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch 17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
admin_backport_14459552.sql --> ORACLE_HOME/patch/scripts/admin_backport_14459552.sql
bug10110625.sql --> ORACLE_HOME/patch/scripts/bug10110625.sql
bug12904308.sql --> ORACLE_HOME/patch/scripts/bug12904308.sql
bug14121009.sql --> ORACLE_HOME/patch/scripts/bug14121009.sql
bug16338983.sql --> ORACLE_HOME/patch/scripts/bug16338983.sql
bug17088068.sql --> ORACLE_HOME/patch/scripts/bug17088068.sql
bug19289642.sql --> ORACLE_HOME/patch/scripts/bug19289642.sql
sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
Patch Location in Inventory:
Patch Location in Storage area:
/oracle/app/oracle/product/11.2.0/.patch_storage/20760997_Jun_8_2015_23_57_50
OPatch succeeded.

[grid@rac1 ~]$ /oracle/app/grid/product/11.2.0/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME |grep -i patch
Oracle Interim Patch Installer version 11.2.0.3.23
OPatch version : 11.2.0.3.23
Log file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/opatch2020-04-03_23-39-19PM_1.log
Lsinventory Output file location : /oracle/app/grid/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2020-04-03_23-39-19PM.txt
Oracle One-Off Patch Installer 11.2.0.1.7
Interim patches (2) :
Patch 17592127 : applied on Fri Apr 03 21:48:53 CST 2020
Unique Patch ID: 16995168
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"
crspatch.pm --> ORACLE_HOME/crs/install/crspatch.pm
Patch Location in Inventory:
Patch Location in Storage area:
/oracle/app/grid/product/11.2.0/.patch_storage/17592127_Jan_9_2014_07_26_53
Patch 20760997 : applied on Fri Apr 03 21:28:36 CST 2020
Unique Patch ID: 18966522
Patch description: "Database Patch Set Update : 11.2.0.3.15 (20760997)"
Sub-patch 20299017; "Database Patch Set Update : 11.2.0.3.14 (20299017)"
Sub-patch 19769496; "Database Patch Set Update : 11.2.0.3.13 (19769496)"
Sub-patch 19121548; "Database Patch Set Update : 11.2.0.3.12 (19121548)"
Sub-patch 18522512; "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Sub-patch 18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch 17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch 16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
admin_backport_14459552.sql --> ORACLE_HOME/patch/scripts/admin_backport_14459552.sql
bug10110625.sql --> ORACLE_HOME/patch/scripts/bug10110625.sql
bug12904308.sql --> ORACLE_HOME/patch/scripts/bug12904308.sql
bug14121009.sql --> ORACLE_HOME/patch/scripts/bug14121009.sql
bug16338983.sql --> ORACLE_HOME/patch/scripts/bug16338983.sql
bug17088068.sql --> ORACLE_HOME/patch/scripts/bug17088068.sql
bug19289642.sql --> ORACLE_HOME/patch/scripts/bug19289642.sql
sdopatch.sql --> ORACLE_HOME/md/admin/sdopatch.sql
Patch Location in Inventory:
Patch Location in Storage area:
/oracle/app/grid/product/11.2.0/.patch_storage/20760997_Jun_8_2015_23_57_50
OPatch succeeded.

liaodp

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle rac 11.2.0.3 生产环境打补丁过程

[root@rac1 /]# cd /oracle/app/grid/product/11.2.0/[root@rac1 11.2.0]# mv OPatch/ OPatch_grid.bak[root@rac1 11.2.0]# cd /oracle/app/oracle/product/11.2.0/[root@rac1 11.2.0]# mv OPatch/ OPatch_oracle...
复制链接

扫一扫