一、概述
本文檔將指導(dǎo)您在 Linux 平臺(tái)上使用 ASM 逐步安裝 Oracle 19C RAC。這里討論每一步。我們將RAC安裝與ASM配合并進(jìn)行版本升級(jí)。
遵循的步驟 ：
- 服務(wù)器配置
- 配置 Oracle ASM
- 預(yù)檢查 RAC 設(shè)置
- 為 RAC 安裝 GRID 基礎(chǔ)設(shè)施
- 安裝Oracle 19C數(shù)據(jù)庫
- 版本升級(jí)/PSU補(bǔ)丁應(yīng)用
二、過程
1、修改服務(wù)器hosts文件
“/etc/hosts”文件必須包含服務(wù)器的完全限定名稱。請以 root 用戶身份在“/etc/hostname”文件中設(shè)置正確的主機(jī)名。
#Public IP
10.201.33.38 AUS-LNDBASMT-001.dbanalyser.com AUS-LNDBASMT-001
10.201.33.39 AUS-LNDBASMT-002.dbanalyser.com AUS-LNDBASMT-002
#Virtual IP
10.201.33.70 AUS-LNDBASMT-001-vip.dbanalyser.com AUS-LNDBASMT-001-vip
10.201.33.71 AUS-LNDBASMT-002-vip.dbanalyser.com AUS-LNDBASMT-002-vip
#Private IP
10.201.224.125 AUS-LNDBASMT-001-priv.dbanalyser.com AUS-LNDBASMT-001-priv
10.201.224.126 AUS-LNDBASMT-002-priv.dbanalyser.com AUS-LNDBASMT-002-priv
#Scan
10.201.33.72 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
10.201.33.73 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
10.201.33.74 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN
2、Oracle 安裝先決條件
執(zhí)行自動(dòng)或手動(dòng)設(shè)置以完成基本的先決步驟。所有安裝都需要額外的設(shè)置。
（1）自動(dòng)設(shè)置
如果您使用的是 RHEL7 或 CentOS7，則可以從 OL7 存儲(chǔ)庫獲取 PRM 并安裝它。它將從您的普通存儲(chǔ)庫中提取依賴項(xiàng)。
# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm對于 RHEL8 或 CentOS8 –
curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c- 1.0-2.el8.x86_64.rpm
yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm（2）手動(dòng)服務(wù)器配置
禁用防火墻
需要通過以下命令禁用服務(wù)器的防火墻。
systemctl stop firewalld
systemctl disable firewalld在“/etc/sysctl.conf”文件中添加或修改以下行。
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500運(yùn)行以下命令之一來更改當(dāng)前內(nèi)核參數(shù)。
/sbin/sysctl -p將以下行添加到“/etc/security/limits.conf 文件”。
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728創(chuàng)建用戶和組。
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba
useraddoracle
usermod -g oinstall oracle
usermod -G dba asmoper,asmadmin.asmdba,oper,oracle安裝以下 RPM 軟件包。
yum install -y bc
yum install -y binutils
#yum install -y compat-libcap1
yum install -y compat-libstdc++-33
#yum install -y dtrace-modules
#yum install -y dtrace-modules-headers
#yum install -y dtrace-modules-provider-headers
#yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
#yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC
# New for OL8
yum install -y libnsl
yum install -y libnsl.i686
yum install -y libnsl2
yum install -y libnsl2.i686網(wǎng)絡(luò)配置。
vi /etc/sysconfig/network
# Recommended value for NOZEROCONF
NOZEROCONF=yes3、為 ASM 配置安裝附加 RPM
kmod-oracleasm-2.0.8-17.el7.x86_64
oracleasmlib-2.0.12-1.el7.x86_64.rpm
oracleasm-support-2.1.8-3.el7.x86_64.rpm4、兩個(gè)節(jié)點(diǎn)配置 Oracle ASM
oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets (‘[]’). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: doneoracleasm start（1）ASM 中的磁盤創(chuàng)建
fdisk /dev/sdf
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them. Be careful before using the write command.
Command (m for help): n
Partition type:
p primary (1 primary, 0 extended, 3 free) e extended
Select (default p):
Using default response p
Partition number (2-4, default 2): d
Partition number (2-4, default 2): 2
No free sectors available
Command (m for help): d
Selected partition 1
Partition 1 is deleted
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free) e extended
Select (default p)
Using default response partition number (1-4, default 1):
First sector (2048-20971519, default 2048):
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
/etc/init.d/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes
/etc/init.d/oracleasm createdisk DATAVOL1 /dev/sdf1
Marking disk “DATAVOL1” as an ASM disk: [ OK ]
/etc/init.d/oracleasm listdisks
DATAVOL1像這樣我們需要根據(jù)需要?jiǎng)?chuàng)建其他磁盤。（2）從其他節(jié)點(diǎn)檢查ASM磁盤
oracleasm scandisks
oracleasm listdisks5、創(chuàng)建目錄并更改權(quán)限
mkdir -p /d01/app/19c/grid
mkdir -p /d01/app/oracle/product/19c/db_1
chown -R oracle:oinstall /d01
chmod -R 775 /d01/6、節(jié)點(diǎn)之間SSH設(shè)置
unzip /d01/app/19c/grid/LINUX.X64_193000_grid_home.zip
cd $GRID_HOME/deinstall
./sshUserSetup.sh -user oracle -hosts " AUS-LNDBASMT-001 AUS-LNDBASMT-002" -noPromptPassphrase7、使用 CLUVFY 進(jìn)行預(yù)檢查
使用 CLUVFY 命令檢查集群安裝準(zhǔn)備情況并在出現(xiàn)任何問題時(shí)進(jìn)行糾正。
cd $GRID_HOME
./runcluvfy.sh stage -pre crsinst -n AUS-LNDBASMT-001,AUS-LNDBASMT-0028、為 RAC 安裝 19C GRID
cd /d01/app/19c/grid/
./gridSetup.shGRID 設(shè)置向?qū)б褑?dòng)...
現(xiàn)在請按照如下所述的步驟操作 ：
選擇“為新集群配置 Oracle Grid Infrastructure”選項(xiàng)，然后單擊“下一步”按鈕。
單擊“下一步”按鈕，選擇“配置 Oracle 獨(dú)立集群”選項(xiàng)。
輸入集群名稱、SCAN 名稱和 SCAN 端口，然后單擊“下一步”按鈕。
注意–集群名稱長度應(yīng)在 15 個(gè)字符以內(nèi)，否則安裝將失敗。
在“集群節(jié)點(diǎn)信息”屏幕上，單擊“添加”按鈕。輸入集群中第二個(gè)節(jié)點(diǎn)的詳細(xì)信息，然后單擊“確定”按鈕。單擊“SSH 連接...”按鈕并輸入“oracle”用戶的密碼。單擊“設(shè)置”按鈕配置 SSH 連接，完成后單擊“測試”按鈕進(jìn)行測試。測試完成后，單擊“下一步”按鈕。
檢查公共和專用網(wǎng)絡(luò)是否指定正確。如果顯示 NAT 接口，請記住將其標(biāo)記為“請勿使用”。單擊“下一步”按鈕。
單擊“下一步”按鈕，選擇“使用 Oracle Flex ASM 進(jìn)行存儲(chǔ)”選項(xiàng)。
選擇“是”并單擊下一步。
如果您希望為 GIMR 創(chuàng)建單獨(dú)的磁盤，請選擇“是”，然后單擊“下一步”。否則單擊“否”。
注意：如果您希望在單獨(dú)的磁盤上創(chuàng)建 GIMR，則磁盤大小必須至少為 32G。
首先使用更改發(fā)現(xiàn)路徑瀏覽路徑 /dev/oracleasm/disks*。將冗余設(shè)置為“正常”，單擊“5GB DISK”用于 OCR 和 Voting 磁盤配置，然后單擊“下一步”按鈕。
如果您需要?jiǎng)?chuàng)建 GIMR。請記住這不是強(qiáng)制性的。
輸入憑據(jù)并單擊“下一步”按鈕。
單擊“下一步”按鈕接受默認(rèn) IPMI 選項(xiàng)。
不要在 EM 注冊。單擊“下一步”按鈕。
我們使用單個(gè)用戶和組管理 ASM 添加數(shù)據(jù)庫，因此將組設(shè)置為“oinstall”并單擊“下一步”按鈕。單擊“是”按鈕接受后續(xù)對話框中的警告。
輸入 Oracle Base 位置“/d01/app/oracle”，然后單擊“下一步”按鈕。我們已經(jīng)為后面的數(shù)據(jù)庫安裝預(yù)先創(chuàng)建了目錄，因此忽略隨后有關(guān)Oracle Base不為空的警告，單擊“是”按鈕。
單擊“下一步”按鈕接受默認(rèn)清單目錄。
如果您希望根腳本自動(dòng)運(yùn)行，請輸入相關(guān)憑據(jù)。單擊“下一步”按鈕。
等待先決條件檢查完成。如果您有任何問題，請使用“修復(fù)并再次檢查”按鈕。完成可能的修復(fù)后，選中“全部忽略”復(fù)選框，然后單擊“下一步”按鈕。對于此類安裝，“網(wǎng)絡(luò)時(shí)間協(xié)議 (NTP)”測試可能會(huì)失敗。還行吧。它可以被修復(fù)。
如果您對摘要信息感到滿意，請單擊“安裝”按鈕。
現(xiàn)在GRID安裝完成了。
通過發(fā)出以下命令檢查正在運(yùn)行的進(jìn)程。
ps -ef|grep d.bin
$GRID_HOME/crsctl stat res -t –> 此命令將顯示兩個(gè)節(jié)點(diǎn)正在運(yùn)行的服務(wù)9、安裝 Oracle 軟件二進(jìn)制文件
將軟件文件解壓到您的 DB 主目錄中。
unzip LINUX.X64_193000_db_home.zip運(yùn)行以下命令來設(shè)置顯示。
./runInstaller選擇僅安裝軟件選項(xiàng)，然后單擊下一步按鈕。
單擊“下一步”按鈕選擇 Oracle Real Application Clusters 數(shù)據(jù)庫安裝選項(xiàng)。
確保選擇了兩個(gè)節(jié)點(diǎn)，然后單擊“下一步”按鈕。
選擇企業(yè)版選項(xiàng)，然后單擊下一步按鈕。
輸入 /u01/app/orabase 作為 Oracle 庫，輸入/u01/app/oracle/product/19c/db_1 作為軟件位置，然后單擊 Next 按鈕。
自動(dòng)運(yùn)行配置腳本 - 將其留空。
然后單擊安裝按鈕。出現(xiàn)提示時(shí)，為兩個(gè)節(jié)點(diǎn)運(yùn)行 root.sh。現(xiàn)在19C軟件二進(jìn)制安裝已經(jīng)完成。
10、創(chuàng)建數(shù)據(jù)庫
由于我們已經(jīng)創(chuàng)建了所需的磁盤組（例如 DATA 和 FRA），現(xiàn)在我們正在繼續(xù)創(chuàng)建數(shù)據(jù)庫。
cd $ORACLE_HOME/bin
./dbca
請按照屏幕截圖進(jìn)行操作。
選擇創(chuàng)建數(shù)據(jù)庫并點(diǎn)擊“下一步”
選擇高級(jí)配置，點(diǎn)擊“下一步”。
選擇通用或事務(wù)處理，然后單擊“下一步”。
確保兩個(gè)節(jié)點(diǎn)都被選中。
提供數(shù)據(jù)庫名稱、SID，然后單擊“下一步”。
選擇數(shù)據(jù)庫文件位置 ，然后單擊“下一步”。
選擇 FRA 位置、大小 ，然后單擊“下一步”。
分配適當(dāng)?shù)膬?nèi)存和其他必要的詳細(xì)信息，然后單擊“下一步”。
選擇下方并點(diǎn)擊“下一步”。
為所有用戶提供相同的密碼，然后單擊“下一步”。
單擊下一步，將創(chuàng)建數(shù)據(jù)庫。
11、RAC 設(shè)置的安裝后檢查
通過觸發(fā)以下命令檢查 RAC 的狀態(tài) –
$GRID_HOME/crsctl stat res -t
srvctl config database -d infra
srvctl status database -d infra
srvctl config scan12、數(shù)據(jù)庫從 19.3 升級(jí)到 19.5
對于版本升級(jí)，我們需要在兩個(gè)節(jié)點(diǎn)上一一打補(bǔ)丁。
停止oracle實(shí)例
srvctl stop instance -db POCDB -node aus-lndbasmt-001
srvctl status database -db pocdbInstance POCDB1 is not running on node aus-lndbasmt-001
Instance POCDB2 is running on node aus-lndbasmt-002
Opatch版本及oracle補(bǔ)丁應(yīng)用情況
./Opatch version
OPatch Version: 12.2.0.1.17
OPatch succeeded.
[oracle@AUS-LNDBASMT-001 OPatch]$ ./Opatch lsinventory -oh /oracle/Oracle_Software/19cDB
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/Oracle_Software/19cDB
Central Inventory : /oracle/u01/app/oraInventory
from : /oracle/Oracle_Software/19cDB/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-19-31PM_1.log
Lsinventory Output file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/lsinv/lsinventory2020-07-31_12-19-31PM.txt
——————————————————————————–
Local Machine Information::
Hostname: AUS-LNDBASMT-001.wiley.com
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 19c 19.0.0.0.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 29585399 : applied on Thu Apr 18 03:21:33 EDT 2019
Unique Patch ID: 22840393
Patch description: “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”
Created on 9 Apr 2019, 19:12:47 hrs PST8PDT
Bugs fixed:
27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673
28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321
28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040
28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250
28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779
28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876
29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455
29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456
29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631
29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540
29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091
29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624
29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934
29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583
29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090
29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753
29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299
29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381
29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931
29413360, 29457319, 29465047
Patch 29517242 : applied on Thu Apr 18 03:21:17 EDT 2019
Unique Patch ID: 22862832
Patch description: “Database Release Update : 19.3.0.0.190416 (29517242)”
Created on 17 Apr 2019, 23:27:10 hrs PST8PDT
Bugs fixed:
29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179
25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312
27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021
28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445
28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897
28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957
28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549
28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945
28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461
28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214
28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560
28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532
28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794
28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561
28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634
28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281
28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762
28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083
28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306
28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738
29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475
29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352
29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575
29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200
29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554
29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498
29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024
29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860
29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805
29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223
29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380
29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219
29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341
29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338
29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909
29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567
29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073
29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817
29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313
29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743
29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456
29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541
29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493
29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733
29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122
29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419
29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260
29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351
29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984
29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273
29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859
29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164
29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117
29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884
29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906
29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184
29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435
29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448
29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539
29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218
29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956
29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915
29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918
29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417
29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568
29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209
29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453
29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620
29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271
29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151
29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588
29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502
29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889
29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121
29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264
29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386
29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616
29521748, 29530812, 29531654, 29557336, 29558975, 29601461
——————————————————————————–
OPatch succeeded.
cd /oracle/patch/30125133/
/oracle/Oracle_Software/19cDB/OPatch/opatch query -is_rolling_patch
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/Oracle_Software/19cDB
Central Inventory : /oracle/u01/app/oraInventory
from : /oracle/Oracle_Software/19cDB/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-21-23PM_1.log
——————————————————————————–
Patch is a rolling patch: true
Patch is a FMW rolling patch: false
OPatch succeeded.應(yīng)用補(bǔ)丁
/oracle/Oracle_Software/19cDB/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/Oracle_Software/19cDB
Central Inventory : /oracle/u01/app/oraInventory
from : /oracle/Oracle_Software/19cDB/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.2.0.7.0
Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log
Verifying environment and performing prerequisite checks…
OPatch continues with these patches: 30125133
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/Oracle_Software/19cDB’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Applying interim patch ‘30125133’ to OH ‘/oracle/Oracle_Software/19cDB’
ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 19.0.0.0.0…
Patching component oracle.rdbms.rsf, 19.0.0.0.0…
Patching component oracle.assistants.acf, 19.0.0.0.0…
Patching component oracle.assistants.deconfig, 19.0.0.0.0…
Patching component oracle.assistants.server, 19.0.0.0.0…
Patching component oracle.buildtools.rsf, 19.0.0.0.0…
Patching component oracle.ctx, 19.0.0.0.0…
Patching component oracle.ldap.rsf, 19.0.0.0.0…
Patching component oracle.network.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…
Patching component oracle.sdo, 19.0.0.0.0…
Patching component oracle.sqlplus, 19.0.0.0.0…
Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…
Patching component oracle.rdbms.rman, 19.0.0.0.0…
Patching component oracle.ctx.atg, 19.0.0.0.0…
Patching component oracle.rdbms.oci, 19.0.0.0.0…
Patching component oracle.rdbms.util, 19.0.0.0.0…
Patching component oracle.xdk, 19.0.0.0.0…
Patching component oracle.ovm, 19.0.0.0.0…
Patching component oracle.network.listener, 19.0.0.0.0…
Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…
Patching component oracle.dbjava.jdbc, 19.0.0.0.0…
Patching component oracle.dbdev, 19.0.0.0.0…
Patching component oracle.rdbms.deconfig, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…
Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…
Patching component oracle.install.deinstalltool, 19.0.0.0.0…
Patching component oracle.dbjava.ic, 19.0.0.0.0…
Patching component oracle.sdo.locator, 19.0.0.0.0…
Patching component oracle.rdbms.scheduler, 19.0.0.0.0…
Patching component oracle.rdbms.dv, 19.0.0.0.0…
Patching component oracle.ons, 19.0.0.0.0…
Patching component oracle.ldap.security.osdt, 19.0.0.0.0…
Patching component oracle.ctx.rsf, 19.0.0.0.0…
Patching component oracle.duma, 19.0.0.0.0…
Patching component oracle.ldap.owm, 19.0.0.0.0…
Patching component oracle.oracore.rsf, 19.0.0.0.0…
Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0…
Patching component oracle.odbc, 19.0.0.0.0…
Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…
Patching component oracle.network.client, 19.0.0.0.0…
Patching component oracle.sqlplus.ic, 19.0.0.0.0…
Patching component oracle.dbjava.ucp, 19.0.0.0.0…
Patching component oracle.xdk.rsf, 19.0.0.0.0…
Patching component oracle.marvel, 19.0.0.0.0…
Patching component oracle.xdk.parser.java, 19.0.0.0.0…
Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…
Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0…
Patching component oracle.precomp.common, 19.0.0.0.0…
Patching component oracle.precomp.lang, 19.0.0.0.0…
Patch 30125133 successfully applied.
Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30125133].
Please refer to Doc ID 2161861.1 for any possible further required actions.
Log file location: /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log
OPatch succeeded.4、啟動(dòng)oracle實(shí)列并驗(yàn)證補(bǔ)丁srvctl start instance -db POCDB -node aus-lndbasmt-001
srvctl status database -db pocdb
Instance POCDB1 is not running on node aus-lndbasmt-001
Instance POCDB2 is not running on node aus-lndbasmt-002
[oracle@AUS-LNDBASMT-001 30125133]$ sqlplus “/ as sysdba”
SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 31 12:30:38 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.5.0.0.0
SQL> select * from v$version;
BANNER
——————————————————————————–
BANNER_FULL
—————————————————————————————————————————————————————-
BANNER_LEGACY CON_ID
——————————————————————————– ———-
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.5.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production 0
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.5.0.0.0在兩個(gè)節(jié)點(diǎn)中執(zhí)行上述步驟后，如果發(fā)現(xiàn)任何無效對象，則應(yīng)運(yùn)行 utlrp.sql 來重新驗(yàn)證這些對象。
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql三、附錄
1、下載軟件
Oracle Database 19c 第 3 版 Linux x86-64軟件下載鏈接 –
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html。
