使用 ASM 和版本升級安裝 Oracle 19C RAC 的分步指南

作者：雪竹聊技術 2023-10-10 09:26:18

系統 Linux Oracle

本文檔將指導您在 Linux 平臺上使用 ASM 逐步安裝 Oracle 19C RAC。這里討論每一步。我們將RAC安裝與ASM配合并進行版本升級。

一、概述

本文檔將指導您在 Linux 平臺上使用 ASM 逐步安裝 Oracle 19C RAC。這里討論每一步。我們將RAC安裝與ASM配合并進行版本升級。

遵循的步驟：

服務器配置
配置 Oracle ASM
預檢查 RAC 設置
為 RAC 安裝 GRID 基礎設施
安裝Oracle 19C數據庫
版本升級/PSU補丁應用

二、過程

1、修改服務器hosts文件

“/etc/hosts”文件必須包含服務器的完全限定名稱。請以 root 用戶身份在“/etc/hostname”文件中設置正確的主機名。

#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 安裝先決條件

執行自動或手動設置以完成基本的先決步驟。所有安裝都需要額外的設置。

（1）自動設置

如果您使用的是 RHEL7 或 CentOS7，則可以從 OL7 存儲庫獲取 PRM 并安裝它。它將從您的普通存儲庫中提取依賴項。

# 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）手動服務器配置

禁用防火墻

需要通過以下命令禁用服務器的防火墻。

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

運行以下命令之一來更改當前內核參數。

/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

創建用戶和組。

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

網絡配置。

vi /etc/sysconfig/network
# Recommended value for NOZEROCONF
NOZEROCONF=yes

3、為 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.rpm

4、兩個節點配置 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: done

oracleasm start

（1）ASM 中的磁盤創建

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

像這樣我們需要根據需要創建其他磁盤。

（2）從其他節點檢查ASM磁盤

oracleasm scandisks

oracleasm listdisks

5、創建目錄并更改權限

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、節點之間SSH設置

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" -noPromptPassphrase

7、使用 CLUVFY 進行預檢查

使用 CLUVFY 命令檢查集群安裝準備情況并在出現任何問題時進行糾正。

cd $GRID_HOME 
./runcluvfy.sh stage -pre crsinst -n AUS-LNDBASMT-001,AUS-LNDBASMT-002

8、為 RAC 安裝 19C GRID

cd /d01/app/19c/grid/
 ./gridSetup.sh

GRID 設置向導已啟動...

現在請按照如下所述的步驟操作：

選擇“為新集群配置 Oracle Grid Infrastructure”選項，然后單擊“下一步”按鈕。

單擊“下一步”按鈕，選擇“配置 Oracle 獨立集群”選項。

輸入集群名稱、SCAN 名稱和 SCAN 端口，然后單擊“下一步”按鈕。

注意–集群名稱長度應在 15 個字符以內，否則安裝將失敗。

在“集群節點信息”屏幕上，單擊“添加”按鈕。輸入集群中第二個節點的詳細信息，然后單擊“確定”按鈕。單擊“SSH 連接...”按鈕并輸入“oracle”用戶的密碼。單擊“設置”按鈕配置 SSH 連接，完成后單擊“測試”按鈕進行測試。測試完成后，單擊“下一步”按鈕。

檢查公共和專用網絡是否指定正確。如果顯示 NAT 接口，請記住將其標記為“請勿使用”。單擊“下一步”按鈕。

單擊“下一步”按鈕，選擇“使用 Oracle Flex ASM 進行存儲”選項。

選擇“是”并單擊下一步。

如果您希望為 GIMR 創建單獨的磁盤，請選擇“是”，然后單擊“下一步”。否則單擊“否”。

注意：如果您希望在單獨的磁盤上創建 GIMR，則磁盤大小必須至少為 32G。

首先使用更改發現路徑瀏覽路徑 /dev/oracleasm/disks*。將冗余設置為“正常”，單擊“5GB DISK”用于 OCR 和 Voting 磁盤配置，然后單擊“下一步”按鈕。

如果您需要創建 GIMR。請記住這不是強制性的。

輸入憑據并單擊“下一步”按鈕。

單擊“下一步”按鈕接受默認 IPMI 選項。

不要在 EM 注冊。單擊“下一步”按鈕。

我們使用單個用戶和組管理 ASM 添加數據庫，因此將組設置為“oinstall”并單擊“下一步”按鈕。單擊“是”按鈕接受后續對話框中的警告。

輸入 Oracle Base 位置“/d01/app/oracle”，然后單擊“下一步”按鈕。我們已經為后面的數據庫安裝預先創建了目錄，因此忽略隨后有關Oracle Base不為空的警告，單擊“是”按鈕。

單擊“下一步”按鈕接受默認清單目錄。

如果您希望根腳本自動運行，請輸入相關憑據。單擊“下一步”按鈕。

等待先決條件檢查完成。如果您有任何問題，請使用“修復并再次檢查”按鈕。完成可能的修復后，選中“全部忽略”復選框，然后單擊“下一步”按鈕。對于此類安裝，“網絡時間協議 (NTP)”測試可能會失敗。還行吧。它可以被修復。

如果您對摘要信息感到滿意，請單擊“安裝”按鈕。

現在GRID安裝完成了。

通過發出以下命令檢查正在運行的進程。

ps -ef|grep d.bin
 $GRID_HOME/crsctl stat res -t –> 此命令將顯示兩個節點正在運行的服務

9、安裝 Oracle 軟件二進制文件

將軟件文件解壓到您的 DB 主目錄中。

unzip LINUX.X64_193000_db_home.zip

運行以下命令來設置顯示。

./runInstaller

選擇僅安裝軟件選項，然后單擊下一步按鈕。

單擊“下一步”按鈕選擇 Oracle Real Application Clusters 數據庫安裝選項。

確保選擇了兩個節點，然后單擊“下一步”按鈕。

選擇企業版選項，然后單擊下一步按鈕。

輸入 /u01/app/orabase 作為 Oracle 庫，輸入/u01/app/oracle/product/19c/db_1 作為軟件位置，然后單擊 Next 按鈕。

自動運行配置腳本 - 將其留空。

然后單擊安裝按鈕。出現提示時，為兩個節點運行 root.sh。現在19C軟件二進制安裝已經完成。

10、創建數據庫

由于我們已經創建了所需的磁盤組（例如 DATA 和 FRA），現在我們正在繼續創建數據庫。

cd $ORACLE_HOME/bin
./dbca

請按照屏幕截圖進行操作。

選擇創建數據庫并點擊“下一步”

選擇高級配置，點擊“下一步”。

選擇通用或事務處理，然后單擊“下一步”。

確保兩個節點都被選中。

提供數據庫名稱、SID，然后單擊“下一步”。

選擇數據庫文件位置，然后單擊“下一步”。

選擇 FRA 位置、大小，然后單擊“下一步”。

分配適當的內存和其他必要的詳細信息，然后單擊“下一步”。

選擇下方并點擊“下一步”。

為所有用戶提供相同的密碼，然后單擊“下一步”。

單擊下一步，將創建數據庫。

11、RAC 設置的安裝后檢查

通過觸發以下命令檢查 RAC 的狀態 –

$GRID_HOME/crsctl stat res -t
srvctl config database -d infra 
srvctl status database -d infra 
srvctl config scan

12、數據庫從 19.3 升級到 19.5

對于版本升級，我們需要在兩個節點上一一打補丁。

停止oracle實例

srvctl stop 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 running on node aus-lndbasmt-002

Opatch版本及oracle補丁應用情況　

./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.

應用補丁

/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、啟動oracle實列并驗證補丁

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

在兩個節點中執行上述步驟后，如果發現任何無效對象，則應運行 utlrp.sql 來重新驗證這些對象。

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。

責任編輯：姜華來源：今日頭條

ASM Oracle

成人免费xxxxx在线视频软件_久久精品久久久_亚洲国产精品久久久_天天色天天色_亚洲人成一区_欧美一级欧美三级在线观看

使用 ASM 和版本升級安裝 Oracle 19C RAC 的分步指南

一、概述

二、過程

1、修改服務器hosts文件

2、Oracle 安裝先決條件

（1）自動設置

（2）手動服務器配置

禁用防火墻

3、為 ASM 配置安裝附加 RPM

4、兩個節點配置 Oracle ASM

（1）ASM 中的磁盤創建

（2）從其他節點檢查ASM磁盤

5、創建目錄并更改權限

6、節點之間SSH設置

7、使用 CLUVFY 進行預檢查

8、為 RAC 安裝 19C GRID

9、安裝 Oracle 軟件二進制文件

10、創建數據庫

11、RAC 設置的安裝后檢查

12、數據庫從 19.3 升級到 19.5

停止oracle實例

Opatch版本及oracle補丁應用情況

應用補丁

三、附錄

1、下載軟件

Opatch版本及oracle補丁應用情況　