文章目录
1 补丁介绍
GI补丁一般包括DB补丁，在打GI补丁过程中会自动打上DB补丁。也就是说GI版本>=DB版本
比如下载GI补丁包p26635745_112040_Linux-x86-64，解压其实里面包括22502505、26392168、26609929三个目录，而DB补丁包p26392168_112040_Linux-x86-64.zip解压后就是26392168目录
1.1 下载补丁和最新OPatch
GI PSU : p26635745_112040_Linux-x86-64(rac).zip
OPatch : p6880880_112000_Linux-x86-64(opatch).zip
说明：GI PSU包括DB PSU,CPU。单机与RAC的opatch通用，单机与rac的psu不通用。
上传补丁包到两个节点的/u01目录下。
1.2 补丁说明
26392168：DATABASE PATCH SET UPDATE
22562505：ACFS PATCH SET UPDATE
26609929：OCW PATCH SET UPDATE:11.2.0.4.171017
从CPUJan2016 起，PSU命名规则为：11.2.0.4.YYMMDD PSU命名规则
2 检查数据库当前OPatch版本
RAC所有节点的GI home和DB home都需要检查。
- 节点1
[oracle@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@new-rac1 ~]$ su - grid
Password:
[grid@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
- 节点2
[oracle@new-rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
[oracle@new-rac2 ~]$ su - grid
Password:
[grid@new-rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.4
OPatch succeeded.
3 确认停止oem
1.查看oem运行状态：
$ORACLE_HOME/bin/emctl status dbconsole
2.如果是运行状态，则需要关闭：
$ORACLE_HOME/bin/emctl stop dbconsole
4 更新OPatch
RAC所有节点的GI home和DB home都需要更新。
4.1 更新grid用户的OPatch
GI home:
[grid@new-rac1 ~] echo $ORACLE_HOME
/u01/app/11.2.0/grid
1.备份原OPatch
root用户执行
- 节点1
[grid@new-rac1 OPatch]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch_bak
mv: cannot move `/u01/app/11.2.0/grid/OPatch' to `/u01/app/11.2.0/grid/OPatch_bak': Permission denied
[grid@new-rac1 OPatch]$ exit
logout
[root@new-rac1 u01]# mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatch_bak
- 节点2
[root@new-rac2 u01]# mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatch_bak
2.解压补丁包并修改属组
- 节点1
[root@new-rac1 u01]# ll p6880880_112000_Linux-x86-64\(opatch\).zip
-rw-r--r-- 1 root root 106060978 Nov 20 09:23 p6880880_112000_Linux-x86-64(opatch).zip
[root@new-rac1 u01]# unzip p6880880_112000_Linux-x86-64\(opatch\).zip -d /u01/app/11.2.0/grid/
[root@new-rac1 u01]# chown -R grid:oinstall /u01/app/11.2.0/grid/OPatch
- 节点2
[root@new-rac2 u01]# ll p6880880_112000_Linux-x86-64\(opatch\).zip
-rw-r--r-- 1 root root 106060978 Nov 20 09:23 p6880880_112000_Linux-x86-64(opatch).zip
[root@new-rac2 u01]# unzip p6880880_112000_Linux-x86-64\(opatch\).zip -d /u01/app/11.2.0/grid/
[root@new-rac2 u01]# chown -R grid:oinstall /u01/app/11.2.0/grid/OPatch
grid用户操作
- 节点1
[root@new-rac1 u01]# su - grid
[grid@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
- 节点2
[root@new-rac2 u01]# su - grid
[grid@new-rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
（需要注意grid用户$ORACLE_HOME 权限。）
4.2 更新oracle用户的OPatch
ORACLE HOME:
[oracle@new-rac1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1
1.root用户执行
- 节点1
[root@new-rac1 u01]# mv /u01/app/oracle/product/11.2.0/dbhome_1/OPatch /u01/app/oracle/product/11.2.0/dbhome_1/OPatch_bak
- 节点2
[root@new-rac2 u01]# mv /u01/app/oracle/product/11.2.0/dbhome_1/OPatch /u01/app/oracle/product/11.2.0/dbhome_1/OPatch_bak
- 节点1
[root@new-rac1 u01]# unzip p6880880_112000_Linux-x86-64\(opatch\).zip -d /u01/app/oracle/product/11.2.0/dbhome_1/
[root@new-rac1 u01]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/OPatch
- 节点2
[root@new-rac2 u01]# unzip p6880880_112000_Linux-x86-64\(opatch\).zip -d /u01/app/oracle/product/11.2.0/dbhome_1/
[root@new-rac2 u01]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/OPatch
2.oracle用户操作
- 节点1
[root@new-rac1 u01]# su - oracle
[oracle@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
- 节点2
[oracle@new-rac2 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.
5 解压补丁文件
所有节点的 grid,oracle都要解压psu文件
1.创建目录
- oracle用户
[oracle@new-rac1 ~]$ cd $ORACLE_HOME
[oracle@new-rac1 dbhome_1]$ mkdir ora_psu
- grid用户
[grid@new-rac1 ~]$ cd $ORACLE_HOME
[grid@new-rac1 grid]$ mkdir grid_psu
mkdir: cannot create directory `grid_psu': Permission denied
！注意grid的ORACLE HOME权限是755，而oracle用户的ORACLE HOME权限是775
- root用户执行
[root@new-rac1 u01]# cd /u01/app/11.2.0/grid/
[root@new-rac1 grid]# mkdir grid_psu
[root@new-rac1 grid]# chown grid:oinstall grid_psu/
2.解压并修改属组和权限
[root@new-rac1 u01]# ll p26635745_112040_Linux-x86-64\(rac\).zip
-rw-r--r-- 1 root root 775179252 Nov 20 09:24 p26635745_112040_Linux-x86-64(rac).zip
- 解压到grid
[root@new-rac1 u01]# unzip p26635745_112040_Linux-x86-64\(rac\).zip -d /u01/app/11.2.0/grid/grid_psu/
[root@new-rac1 grid_psu]# chown -R grid:oinstall /u01/app/11.2.0/grid/grid_psu/
[root@new-rac1 ora_psu]# cd /u01/app/11.2.0/grid/grid_psu/
[root@new-rac1 grid_psu]# ll
total 128
drwxr-xr-x 5 grid oinstall 4096 Oct 13 2017 26635745
-rw-rw-r-- 1 grid oinstall 124327 Oct 17 2017 PatchSearch.xml
[root@new-rac1 grid_psu]# chmod 775 26635745/
[root@new-rac1 grid_psu]# ll
total 128
drwxrwxr-x 5 grid oinstall 4096 Oct 13 2017 26635745
-rw-rw-r-- 1 grid oinstall 124327 Oct 17 2017 PatchSearch.xml
- 解压到oracle
[root@new-rac1 u01]# unzip p26635745_112040_Linux-x86-64\(rac\).zip -d /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/
[root@node1 tmp]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/
[root@new-rac1 ora_psu]# chmod 775 /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/
3.节点2 重复5
6 检查补丁之间有无冲突
所有节点的grid、oracle用户都要检查。
6.1 节点1 grid用户检查
[root@new-rac1 grid_psu]# su - grid
[grid@new-rac1 ~]$ cd /u01/app/11.2.0/grid/grid_psu/26635745/
[grid@new-rac1 26635745]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_10-22-01AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
6.2 节点1 oracle用户检查
[grid@new-rac1 26635745]$ su - oracle
Password:
[oracle@new-rac1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/
[oracle@new-rac1 26635745]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-20_10-23-05AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
6.3 节点2重复6
7 为数据库做冷备份
（如果不考虑安全性，这步可以省略，有点点风险）
7.1 为数据库做冷备
查看数据文件、控制文件、参数文件、日志文件位置，然后拷贝到指定目录下保存。
[root@new-rac1 grid_psu]# su - oracle
[oracle@new-rac1 ~]$ mkdir rmanbak
7.2 备份oracle_home
使用root用户将#ORACLE_HOME上级目录整个备份，给目录进行压缩，先用tar打包再用gzip压缩：
[root@new-rac1 ~]# tar -zcvpf db_20191120.tar.gz /u01/app/oracle/product/11.2.0/dbhome_1/
[root@new-rac1 ~]# ll
total 3219236
-rw-------. 1 root root 1970 Nov 14 16:07 anaconda-ks.cfg
-rw-r--r-- 1 root root 3279147147 Nov 20 10:48 db_20191120.tar.gz
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Desktop
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Documents
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Downloads
-rw-r--r--. 1 root root 17229824 Nov 15 10:00 equallogic-host-tools-1.6.0-2.iso
-rw-r--r--. 1 root root 50968 Nov 14 16:07 install.log
-rw-r--r--. 1 root root 11504 Nov 14 16:04 install.log.syslog
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Music
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Pictures
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Public
-rw-r--r--. 1 root root 1357 Nov 15 10:00 RPM-GPG-KEY-DELLEQL
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Templates
drwxr-xr-x. 2 root root 4096 Nov 14 16:26 Videos
8 停止数据库实例和crs服务
- 节点1
root用户执行，/u01/app/11.2.0/grid/为grid用户的$ORACLE_HOME
1.停止节点1的数据库实例
[root@new-rac1 ~]# cd /u01/app/11.2.0/grid/bin/
[root@new-rac1 bin]# ./srvctl stop instance -d racdb -i racdb1
2.停止节点1的crs服务
[root@new-rac1 bin]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'new-rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'new-rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'new-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.RACDB_DATA.dg' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'new-rac1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'new-rac1'
CRS-2677: Stop of 'ora.FRA.dg' on 'new-rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.new-rac1.vip' on 'new-rac1'
CRS-2677: Stop of 'ora.cvu' on 'new-rac1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'new-rac2'
CRS-2677: Stop of 'ora.RACDB_DATA.dg' on 'new-rac1' succeeded
CRS-2676: Start of 'ora.cvu' on 'new-rac2' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'new-rac1' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'new-rac2'
CRS-2677: Stop of 'ora.new-rac1.vip' on 'new-rac1' succeeded
CRS-2672: Attempting to start 'ora.new-rac1.vip' on 'new-rac2'
CRS-2676: Start of 'ora.scan2.vip' on 'new-rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'new-rac2'
CRS-2676: Start of 'ora.new-rac1.vip' on 'new-rac2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'new-rac2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'new-rac1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'new-rac2'
CRS-2677: Stop of 'ora.OCR.dg' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'new-rac1'
CRS-2677: Stop of 'ora.asm' on 'new-rac1' succeeded
CRS-2676: Start of 'ora.oc4j' on 'new-rac2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'new-rac1'
CRS-2677: Stop of 'ora.ons' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'new-rac1'
CRS-2677: Stop of 'ora.net1.network' on 'new-rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'new-rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'new-rac1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'new-rac1'
CRS-2677: Stop of 'ora.evmd' on 'new-rac1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'new-rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'new-rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'new-rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'new-rac1'
CRS-2677: Stop of 'ora.cssd' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'new-rac1'
CRS-2677: Stop of 'ora.crf' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'new-rac1'
CRS-2677: Stop of 'ora.gipcd' on 'new-rac1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'new-rac1'
CRS-2677: Stop of 'ora.gpnpd' on 'new-rac1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'new-rac1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /u01/app/11.2.0/grid
9 手动更新补丁
9.1 应用CRS补丁
- 节点1 grid 用户执行
[root@new-rac1 bin]# su - grid
[grid@new-rac1 ~]$ cd $ORACLE_HOME/grid_psu/
[grid@new-rac1 grid_psu]$ ll
total 128
drwxrwxr-x 5 grid oinstall 4096 Oct 13 2017 26635745/
-rw-rw-r-- 1 grid oinstall 124327 Oct 17 2017 PatchSearch.xml
[grid@new-rac1 grid_psu]$ cd 26635745/
[grid@new-rac1 26635745]$ ls
22502505/ 26392168/ 26609929/ bundle.xml PatchSearch.xml README.html README.txt
[grid@new-rac1 26635745]$ pwd
/u01/app/11.2.0/grid/grid_psu/2663574
$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/22502505/
$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/26392168/
$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/26609929/
[grid@new-rac1 26635745]$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/22502505/
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-04-30AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 22502505
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '22502505' to OH '/u01/app/11.2.0/grid'
Patching component oracle.usm, 11.2.0.4.0...
Patch 22502505 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-04-30AM_1.log
OPatch succeeded.
[grid@new-rac1 26635745]$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/26392168/
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-06-35AM_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
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/11.2.0/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.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.sdo.locator, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18031668' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
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.ldap.rsf.ic, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '18522509' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '19121551' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] , [ oracle.sysman.console.db, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Applying sub-patch '19769489' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] , [ oracle.ovm, 11.2.0.4.0 ] , [ oracle.xdk, 11.2.0.4.0 ] , [ oracle.oraolap, 11.2.0.4.0 ] , [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
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.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20299013' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 11.2.0.4.0 ] , [ oracle.rdbms.oci, 11.2.0.4.0 ] , [ oracle.precomp.common, 11.2.0.4.0 ] , [ oracle.sysman.agent, 10.2.0.4.5 ] , [ oracle.xdk, 11.2.0.4.0 ] , [ oracle.sysman.console.db, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
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.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.common.core, 10.2.0.4.5...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...
Applying sub-patch '20760982' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '21352635' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.agent, 10.2.0.4.5 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '21948347' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.agent, 10.2.0.4.5 ] , [ oracle.ovm, 11.2.0.4.0 ] , [ oracle.xdk, 11.2.0.4.0 ] , [ oracle.tfa, 11.2.0.4.0 ] , [ oracle.sysman.console.db, 11.2.0.4.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.5 ] not present in the Oracle Home or a higher version is found.
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.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '22502456' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] , [ oracle.tfa, 11.2.0.4.0 ] , [ oracle.rdbms.olap, 11.2.0.4.0 ] , [ oracle.oraolap, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.oraolap.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '23054359' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.rdbms.dv, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Applying sub-patch '24006111' to OH '/u01/app/11.2.0/grid'
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Applying sub-patch '24732075' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.4.0 ] , [ oracle.sysman.plugin.db.main.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.sqlplus.ic, 11.2.0.4.0...
Patching component oracle.sqlplus, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.util, 11.2.0.4.0...
Patching component oracle.ordim.client, 11.2.0.4.0...
Patching component oracle.ordim.jai, 11.2.0.4.0...
Patching component oracle.ordim.server, 11.2.0.4.0...
Applying sub-patch '25869727' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26609445' to OH '/u01/app/11.2.0/grid'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' to OH '/u01/app/11.2.0/grid'
ApplySession: Optional component(s) [ oracle.sysman.agent, 10.2.0.4.5 ] , [ oracle.xdk, 11.2.0.4.0 ] , [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.client, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.network.listener, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Composite patch 26392168 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-06-35AM_1.log
OPatch succeeded.
[grid@new-rac1 26635745]$ /u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/11.2.0/grid/grid_psu/26635745/26609929/
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-16-54AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 26609929
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/11.2.0/grid')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '26609929' to OH '/u01/app/11.2.0/grid'
Patching component oracle.crs, 11.2.0.4.0...
Patch 26609929 successfully applied.
Log file location: /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_11-16-54AM_1.log
OPatch succeeded.
9.2 应用db补丁
- 节点1 oracle 用户执行
1.补丁安装前检查
su - oracle
[oracle@new-rac1 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26609929/custom/server/26609929/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26609929/custom/server/26609929/custom/scripts/prepatch.sh completed successfully.
2.应用db补丁
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26392168/
出现报错：
[oracle@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26392168/
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-20_11-24-50AM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqlplus.so
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-20_11-24-50AM_1.log
OPatch failed with error code 73
问题解决：
[oracle@new-rac1 ~]$ ps -ef |grep smon
oracle 142402 103510 0 14:18 pts/0 00:00:00 grep smon
[oracle@new-rac1 ~]$ ps -ef |grep ora
root 29917 1 0 Nov18 ? 00:09:28 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/new-rac1/tfa_home
root 86726 86699 0 10:28 pts/1 00:00:00 su - oracle
oracle 86727 86726 0 10:28 pts/1 00:00:00 -bash
oracle 87887 86727 0 10:34 pts/1 00:00:00 sqlplus as sysdba
root 103502 94766 0 11:19 pts/0 00:00:00 su - oracle
oracle 103510 103502 0 11:19 pts/0 00:00:00 -bash
oracle 142480 103510 0 14:19 pts/0 00:00:00 ps -ef
oracle 142481 103510 0 14:19 pts/0 00:00:00 grep ora
[oracle@new-rac1 ~]$ kill -9 29917
-bash: kill: (29917) - Operation not permitted
[oracle@new-rac1 ~]$ exit
logout
[root@new-rac1 bin]# ps -ef |grep ora
root 29917 1 0 Nov18 ? 00:09:29 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath /u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/app/11.2.0/grid/tfa/new-rac1/tfa_home
root 86726 86699 0 10:28 pts/1 00:00:00 su - oracle
oracle 86727 86726 0 10:28 pts/1 00:00:00 -bash
oracle 87887 86727 0 10:34 pts/1 00:00:00 sqlplus as sysdba
root 143326 8866 0 14:21 pts/0 00:00:00 grep ora
root 143341 143324 0 14:21 ? 00:00:00 /u01/app/11.2.0/grid/jdk/jre/bin/java -Xms64m -Xmx256m -Djavax.net.ssl.trustStore=/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/public.jks -classpath /u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/RATFA.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/je-4.0.103.jar:/u01/app/11.2.0/grid/tfa/new-rac1/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.CommandLine new-rac1:checkTFAMain -port 5000
[root@new-rac1 bin]# kill -9 29917
[root@new-rac1 bin]# kill -9 143341
-bash: kill: (143341) - No such process
[root@new-rac1 bin]# ps -ef |grep ora
root 86726 86699 0 10:28 pts/1 00:00:00 su - oracle
oracle 86727 86726 0 10:28 pts/1 00:00:00 -bash
oracle 87887 86727 0 10:34 pts/1 00:00:00 sqlplus as sysdba
root 143442 8866 0 14:21 pts/0 00:00:00 grep ora
重新执行：
[oracle@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26392168/
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-20_14-24-59PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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 '/u01/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...
Applying sub-patch '25869727' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.4.0...
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Applying sub-patch '26609445' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.oracore.rsf, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Applying sub-patch '26392168' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.oid.client, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 11.2.0.4.0...
Patching component oracle.ldap.client, 11.2.0.4.0...
Patching component oracle.sysman.agent, 10.2.0.4.5...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.network.listener, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Composite patch 26392168 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-11-20_14-24-59PM_1.log
OPatch succeeded.
3.补丁修复完确定
[oracle@new-rac1 ~]$ /u01/app/oracle/product/11.2.0/dbhome_1/ora_psu/26635745/26609929/custom/server/26609929/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Reading /u01/app/oracle/product/11.2.0/dbhome_1/install/params.ora..
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Parsing file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Verifying file /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/racgwrap
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvctl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/srvconfig
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/cluvfy
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/diskmon.bin
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/lsnodes
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/osdbagrp
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/rawutl
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/ractrans
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/srvm/admin/getcrshome
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/gnsd
Reapplying file permissions on /u01/app/oracle/product/11.2.0/dbhome_1/bin/crsdiag.pl
Postpatch completed successfully
9.3 执行rootadd_rdbms.sh 、rootcrs.pl -patch
- 节点1root用户执行
su – root
[root@new-rac1 ~]# /u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
[root@new-rac1 ~]# /u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
9.4 启动 node1 数据库实例 和 node1 crs服务
(实际上前面执行 rootcrs.pl -patch 已经让node1的crs起来了)
[root@new-rac1 ~]# cd /u01/app/11.2.0/grid/bin/
[root@new-rac1 bin]# ./srvctl start instance -d racdb -i racdb1
9.5 节点2重复节点1操作
节点2重复8、9（停止节点二数据库和节点二crs服务、grid、oracle打补丁、rootadd_rdbms.sh 、rootcrs.pl -patch）操作
10 升级字典
（升级数据库字典，要停业务。如果打补丁在DBCA之前，则不需要升级数据库字典，反之则需要升级数据库字典）
由于RAC实际只有一个数据库，因此任意节点登录数据库执行1次即可。最后重启数据库。
[root@new-rac2 bin]# ./srvctl status database -d racdb
Instance racdb1 is running on node new-rac1
Instance racdb2 is running on node new-rac2
10.1 关闭数据库相关进程
（静态监听、动态监听、EOM、相关服务)
1.停止数据库外部进程
ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9
[root@new-rac2 bin]# ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'
2.停止监听
[root@new-rac2 bin]# ./srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): new-rac1,new-rac2
[root@new-rac2 bin]# ./srvctl stop listener
[root@new-rac2 bin]# ./srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is not running
[root@new-rac2 bin]# ps -ef |grep ora_|grep -v grep
3.相关服务
[oracle@new-rac2 bin]$ netstat -an |grep 1521
[oracle@new-rac2 bin]$ netstat -an |grep 1158
10.2 正式升级数据库的数据字典
1.升级数据字典
[oracle@new-rac1 ~]$ sqlplus / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/catbundle.sql psu apply
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
2.重启数据库
[oracle@new-rac1 ~]$ srvctl stop database -d racdb
[oracle@new-rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node new-rac1
Instance racdb2 is not running on node new-rac2
[oracle@new-rac1 ~]$ srvctl start database -d racdb
[oracle@new-rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node new-rac1
Instance racdb2 is running on node new-rac2
11 验证补丁更新结果
1.各节点的GI HOME和ORACLE HOME都执行验证。
- 节点1grid用户
[grid@new-rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.17
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-11-20_15-32-03PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-11-20_15-32-03PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: new-rac1.nsfc.gov.cn
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.
Interim patches (3) :
Patch 26609929 : applied on Wed Nov 20 11:17:27 CST 2019
Unique Patch ID: 21512432
Patch description: "OCW Patch Set Update : 11.2.0.4.170814 (26609929)"
Created on 10 Aug 2017, 22:16:53 hrs PST8PDT
Bugs fixed:
19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 22162062
21232394, 20365005, 17750548, 17387214, 17617807, 14497275, 20219458
17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
20110156, 17843489, 17065496, 21694632, 13991403, 17273020, 22762046
17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
17886392, 20995001, 17039197, 17947785, 16317771, 10052729, 22353346
20340620, 16237657, 20317221, 15917869, 18199185, 18399991, 20186278
18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 23621494
20552947, 18414137, 18882642, 17001914, 17927970, 14378120, 16346413
15986647, 18068871, 21222147, 18143836, 16206997, 21982225, 25490238
19168690, 20235511, 18343490, 21875360, 16613232, 19276791, 17722664
20440643, 12928658, 18952577, 16249829, 18520351, 18226143, 18265482
16076412, 18229842, 17172091, 20676340, 17818075, 20091753, 18231837
14373486, 20136892, 17483479, 20551654, 18120545, 18729166, 13843841
21225209, 17405302, 18709496, 18330979, 18744838, 14525998, 18187697
17087371, 20531190, 20598625, 14385860, 18348155, 19479503, 12928592
17516024, 18370031, 17764053, 19272663, 17551223, 14671408, 18272135
14207615, 21255373, 17500165, 18875012, 14769643, 25656952, 19558324
18464784, 18848125, 19241857, 17955615, 14851828, 20315294, 14693336
20014326, 17352230, 16284825, 17238586, 17089344, 17405605, 21327402
17531342, 26546632, 19398098, 17640316, 17159489, 13823394, 16543190
22024217, 17983675, 20795241, 16281493, 17598201, 18346135, 17481314
15986311, 19601468, 17208793, 18700935, 18999857, 14076173, 18428146
18352845, 17435488, 17592037, 20408163, 18352846, 19616601, 17391726
17387779, 15851860, 14777968, 20141091, 16206882, 19885321, 21113068
20175174, 17305100, 15832129, 16901346, 25591658, 17985714, 18536826
17780903, 18752378, 18946768, 16875342, 16876500, 17769597, 19955755
16429265, 18336452, 17273003, 17209968, 25484507, 17059927, 17046460
20094984, 19319357, 16988311, 18053631, 16867761, 18774591, 20235486
21442094, 19359787, 15869775, 19642566, 17447588, 21152052, 16798862
15920201
Patch 26392168 : applied on Wed Nov 20 11:14:24 CST 2019
Unique Patch ID: 21615794
Patch description: "Database Patch Set Update : 11.2.0.4.171017 (26392168)"
Created on 5 Oct 2017, 23:50:44 hrs PST8PDT
Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"
Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"
Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"
Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 16731148
16314254, 13837378, 18441944, 17835048, 13558557, 17008068, 17201159
25427662, 17853498, 17246576, 18356166, 18681862, 18440047, 20569094
16875449, 20387265, 19788842, 17296856, 21330264, 14010183, 17648596
17551063, 17025461, 24719736, 17267114, 22507210, 17912217, 17889583
18202441, 17040764, 17478145, 25655390, 16524926, 19358317, 22148226
18747196, 26544823, 18641419, 17036973, 17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16832076, 18247991, 16692232, 22507234
17570240, 13871092, 24624166, 17848897, 17441661, 14034426, 17465741
16596890, 17437634, 21343897, 20506706, 21453153, 18339044, 22321741
17951233, 18430495, 21787056, 22380919, 20506715, 19469538, 17811429
17903598, 19721304, 18230522, 19554106, 19458377, 21281607, 17612828
6599380, 22092979, 22321756, 17040527, 17811438, 18641461, 14657740
13364795, 19490948, 21387964, 17346671, 17588480, 18235390, 18849970
26474853, 17889549, 19309466, 16472716, 20596234, 18331850, 18641451
17344412, 21179898, 19461270, 17546761, 24842886, 14521849, 18203835
18203838, 18964939, 18203837, 17313525, 22195457, 18139690, 16837842
22296366, 14106803, 17842825, 21352646, 22657942, 20657441, 16360112
22195441, 17389192, 26198926, 14565184, 17205719, 18440095, 22195448
14354737, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
18673342, 22905130, 17027426, 19972569, 19972568, 20144308, 19972566
17282229, 19972564, 16870214, 19615136, 17390431, 18762750, 16613964
17957017, 18098207, 18471685, 19730508, 21538485, 18264060, 17323222
17754782, 17600719, 18317531, 17852463, 17596908, 17655634, 16228604
20074391, 19972570, 18996843, 19854503, 16042673, 17835627, 20334344
17393683, 18000422, 20861693, 17551709, 26575788, 23315889, 20506699
19006849, 18277454, 18456514, 17258090, 17174582, 25654936, 17242746
16399083, 21132297, 17824637, 17762296, 22168163, 17397545, 16450169
12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
17853456, 18673304, 20004021, 26030218, 21668627, 16194160, 17477958
16538760, 12982566, 20828947, 20296213, 18259031, 18293054, 17610798
19699191, 23065323, 17311728, 18135678, 23294548, 16785708, 10136473
22551446, 24560906, 19777862, 17786518, 18315328, 18334586, 12747740
19032867, 18096714, 18899974, 17390160, 17232014, 16422541, 18673325
18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648
18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292
16668584, 21343838, 20299015, 17446237, 18043064, 18093615, 23713236
17694209, 17288409, 20475845, 17274537, 13955826, 16934803, 17634921
17501491, 16315398, 22683212, 17006183, 13829543, 18191164, 26746894
17655240, 19393542, 18384391, 21538567, 16198143, 21847223, 25823754
17892268, 20142975, 19584068, 17165204, 21756699, 18508861, 16901385
18554763, 21532755, 18189036, 17443671, 17385178, 17936109, 14829250
20925795, 20509482, 17478514, 16850630, 13951456, 16595641, 14054676
15861775, 16912439, 17299889, 17297939, 18619917, 16833527, 17798953
17816865, 18607546, 17571306, 21286665, 17341326, 17851160, 20558005
17586955, 19049453, 21051840, 17587063, 16956380, 18328509, 25423453
14133975, 18061914, 21051833, 18522509, 18765602, 18199537, 17332800
13609098, 18384537, 22502493, 14338435, 17945983, 21067387, 16392068
17752995, 21051862, 16863422, 25505382, 17237521, 18244962, 19544839
24433711, 17156148, 18973907, 23026585, 17877323, 17449815, 18180390
17088068, 17037130, 20004087, 19466309, 25505371, 11733603, 18084625
21051858, 18674024, 21051852, 18091059, 16306373, 25369547, 18306996
18193833, 19915271, 17787259, 20631274, 25879656, 16344544, 14692762
18614015, 17346091, 18228645, 17721717, 18436307, 19888853, 21756677
11883252, 17891943, 22353199, 16384983, 19121551, 12816846, 17982555
17761775, 22243719, 17265217, 25505394, 17071721, 16721594, 21756661
18262334, 15913355, 17891946, 17672719, 17602269, 17239687, 17042658
17238511, 17811456, 17284817, 17752121, 20879889, 17394950, 16579084
17011832, 22195465, 14602788, 18325460, 24476265, 24476274, 12611721
16903536, 19689979, 17006570, 16043574, 18783224, 24662775, 16494615
21526048, 19197175, 16069901, 17811447, 17308789, 22195477, 17865671
19013183, 17343514, 17325413, 18316692, 16180763, 17348614, 14368995
21983325, 17393915, 16285691, 19211433, 20331945, 17883081, 24316947
17705023, 17614227, 19578350, 22195485, 14084247, 13645875, 16777840
19727057, 14852021, 18744139, 18674047, 19285025, 17716305, 18482502
17622427, 19289642, 25947799, 22195492, 20869721, 14458214, 18723434
17767676, 25505407, 17786278, 19258504, 17082983, 21351877, 17365043
13498382, 18331812, 16065166, 25489607, 16685417, 18031668, 22893153
16943711, 19272701, 21517440, 17649265, 13866822, 18094246, 24528741
17783588, 14245531, 17082359, 20448824, 18280813, 23330119, 16268425
25600421, 17302277, 18018515, 17215560, 24411921, 19271443, 17016369
20777150, 23330124, 20441797, 19769489, 17545847, 25093656, 18260550
13853126, 23536835, 17227277, 25957038, 24652769, 19207117, 9756271
18868646, 17614134, 26667023, 17546973, 18704244, 19680952, 26667015
17050888, 18828868, 18273830, 17360606, 16992075, 17375354, 12905058
18362222, 21429602, 17571039, 17468141, 18436647, 17235750, 21168487
16220077, 16929165
Patch 22502505 : applied on Wed Nov 20 11:05:19 CST 2019
Unique Patch ID: 19880366
Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)"
Created on 17 Feb 2016, 00:12:23 hrs PST8PDT
Bugs fixed:
21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148
17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796
18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303
18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334
18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946
--------------------------------------------------------------------------------
OPatch succeeded.
- 节点1 oracle用户
sqlplus / as sysdba
SQL>
col ACTION_TIME for a40;
col COMMENTS for a20;
col BUNDLE_SERIES for a10;
SQL> select ACTION_TIME,BUNDLE_SERIES,COMMENTS from dba_registry_history;
ACTION_TIME BUNDLE_SER COMMENTS
---------------------------------------- ---------- --------------------
18-11月-19 02.43.49.662395 下午 PSU Patchset 11.2.0.2.0
20-11月-19 03.22.37.074601 下午 PSU PSU 11.2.0.4.171017
2.查看无效对象
select count(*) from dba_objects where status<>'VALID';
COUNT(*)
----------
0
12 启动监听，对外提供服务
[oracle@new-rac1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): new-rac1,new-rac2
[oracle@new-rac1 ~]$ lsnrctl stat
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-11月-2019 15:48:39
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 20-11月-2019 15:28:18
Uptime 0 days 0 hr. 20 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/new-rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.214)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.128.215)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "racdb" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Service "racdbXDB" has 1 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
扫一扫
1289
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
