Oracle 19c rac 補丁升級，從19.7 to19.22-集群

1. 補丁包概述

數據庫環境

角色

數據庫

IP地址

數據庫版本

主機名

數據庫名稱

源端

RAC

172.30.21.166/167

19.7

hfcwdb66/hfcwdb67

hfdb

將以下補丁包上傳到/soft下


上傳到兩個節點的soft目錄下：p6880880_190000_Linux-x86-64.zip （更新opatch）
p35940989_190000_Linux-x86-64.zip（GI包，grid軟件升級包）
p35943157_190000_Linux-x86-64.zip（DB包，數據庫升級包）

通過網盤分享的文件：oracle 19.22 補丁
鏈接: https://pan.baidu.com/s/1j9-ZVe7eojN3VZ_fn3ja1g?pwd=y3ih 提取碼: y3ih?

 column product format A40
column version format A15
column version_full format A20
column status format A15
select * from product_component_version;SYS@hfdb1>  select * from product_component_version;PRODUCT                                  VERSION         VERSION_FULL         STATUS
---------------------------------------- --------------- -------------------- ------------------------------
Oracle Database 19c Enterprise Edition   19.0.0.0.0      19.7.0.0.0           Production

2. OPatch檢查和更新

opatch 現在的版本

[grid@hfdb30:/oracle/app/19c/grid/OPatch]$opatch version
OPatch Version: 12.2.0.1.17OPatch succeeded.
[grid@hfdb30:/oracle/app/19c/grid/OPatch]$

grid 替換 opatch（兩個節點都要執行）

注意以下所有操作都是root用戶執行的，但是進行查詢版本的時候需要進入配置過環境變量的用戶

替換完后使用opatch version 命令查看，這里要求所有的節點的 grid 和 oralce 用戶下的 opatch 都要升級，我這里是 2 節點的 rac，所以需要升級 4 次。

unzip -o p6880880_190000_Linux-x86-64.zipsu - root
cd /softchown -R grid:oinstall /soft
su - grid -c "unzip -q -o /soft/p6880880_190000_Linux-x86-64.zip -d /oracle/app/19c/grid"
su - grid -c "unzip -q /soft/p35940989_190000_Linux-x86-64.zip -d /soft"chown -R oracle:oinstall /soft
su - oracle -c "unzip -q -o /soft/p35943157_190000_Linux-x86-64.zip -d /oracle/app/oracle/product/19c/db_1"opatch version

oracle 替換 opatch（兩個節點都要執行）

su - oracle -c "unzip -q -o /soft/p6880880_190000_Linux-x86-64.zip -d /oracle/app/oracle/product/19c/db_1"su - oracle
opatch version-- 部分操作
[root@hfcwdb66 grid]# mv OPatch OPatch.bak
[root@hfcwdb66 grid]# cp -r /soft/OPatch/ ./
[root@hfcwdb66 grid]# chown grid:oinstall -R OPatch
[root@hfcwdb66 grid]# su - grid
上一次登錄：一 12月  9 20:04:06 CST 2024
[grid@hfcwdb66:/home/grid]$cd $ORACLE_HOME
[grid@hfcwdb66:/oracle/app/19c/grid]$cd OPatch
[grid@hfcwdb66:/oracle/app/19c/grid/OPatch]$opatch version
OPatch Version: 12.2.0.1.44OPatch succeeded.

3. 驗證Oracle Inventory的有效性

oracle用戶和 grid 用戶都執行：（兩個節點都要執行）

GI HOME 和DB HOME 都需要驗證，分別使用grid和oracle用戶執行如下命令，確保返回SUCCESS。

$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

4. 運行 OPatch 沖突檢查（兩個節點都要執行）

grid 用戶：

su - grid
cd /oracle/app/19c/grid/OPatch/ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/33575402
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35943157
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35956421
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35967489
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/36115038-- 部分操作
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35943157
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-45-20PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed.OPatch succeeded.
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35967489
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-46-16PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed.OPatch succeeded.

oracle 用戶

su - oracle
cd /oracle/app/19c/grid/OPatch$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35943157
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35967489-- 部分操作
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35943157
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-45-20PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed.OPatch succeeded.
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/35940989/35967489
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-46-16PM_1.logInvoking prereq "checkconflictagainstohwithdetail"Prereq "checkConflictAgainstOHWithDetail" passed.OPatch succeeded.
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$vim /soft/patch_list_dbhome.txt
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /soft/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-51-31PM_1.logInvoking prereq "checksystemspace"Prereq "checkSystemSpace" passed.OPatch succeeded.

5. 運行opatch命令檢查GI HOME下是否有足夠的空間

-- grid用戶
vim /soft/patch_list_gihome.txt/soft/35940989/35943157
/soft/35940989/35967489
/soft/35940989/35956421
/soft/35940989/36115038
/soft/35940989/33575402$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /soft/patch_list_gihome.txt-- oracle 用戶
im /soft/patch_list_dbhome.txt/soft/35940989/35943157
/soft/35940989/35967489$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /soft/patch_list_dbhome.txt--部分操作
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$vim /soft/patch_list_dbhome.txt
[oracle@hfcwdb66:/oracle/app/19c/grid/OPatch]$$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /soft/patch_list_dbhome.txt
Oracle Interim Patch Installer version 12.2.0.1.41
Copyright (c) 2024, Oracle Corporation.  All rights reserved.PREREQ sessionOracle Home       : /oracle/app/oracle/product/19c/db_1
Central Inventory : /oracle/app/oraInventoryfrom           : /oracle/app/oracle/product/19c/db_1/oraInst.loc
OPatch version    : 12.2.0.1.41
OUI version       : 12.2.0.7.0
Log file location : /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatch/opatch2024-12-10_17-51-31PM_1.logInvoking prereq "checksystemspace"Prereq "checkSystemSpace" passed.OPatch succeeded.

6. 補丁沖突檢測與解決（修補程序）

su - root
cd /
/oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989  -oh /oracle/app/19c/grid -analyze --回滾（這里不需要執行，失敗可以執行）
su - root
/u01/app/19.3.0/grid/OPatch/opatchauto rollback /soft/35940989 -analyze -- 部分操作
[root@hfcwdb66 /]# /oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989  -oh /oracle/app/19c/grid -analyzeOPatchauto session is initiated at Tue Dec 10 17:55:25 2024System initialization log file is /oracle/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-12-10_05-55-35PM.log.會話日志文件是/oracle/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-12-10_05-55-42PM.log
此會話的 ID 為 F1LJExecuting OPatch prereq operations to verify patch applicability on home /oracle/app/19c/grid
Patch applicability verified successfully on home /oracle/app/19c/gridExecuting patch validation checks on home /oracle/app/19c/grid
Patch validation checks successfully completed on home /oracle/app/19c/gridOPatchAuto 成功。--------------------------------Summary--------------------------------Analysis for applying patches has completed successfully:Host:hfcwdb66
CRS Home:/oracle/app/19c/grid
Version:19.0.0.0.0==Following patches were SUCCESSFULLY analyzed to be applied:Patch: /soft/35940989/35967489
Log: /oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-12-10_17-56-14下午_1.logPatch: /soft/35940989/35956421
Log: /oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-12-10_17-56-14下午_1.logPatch: /soft/35940989/33575402
Log: /oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-12-10_17-56-14下午_1.logPatch: /soft/35940989/36115038
Log: /oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-12-10_17-56-14下午_1.logPatch: /soft/35940989/35943157
Log: /oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/opatch2024-12-10_17-56-14下午_1.logOPatchauto session completed at Tue Dec 10 17:57:56 2024
Time taken to complete the session 2 minutes, 22 seconds
  • 這里節點1和節點2都需要執行，否則在執行過程會報錯
# 下面這個文件節點2可能沒有，建議從節點1copy在授權 scp -r /oracle/app/oraInventory/ContentsXML/oui-patch.xml hfcwdb67:/oracle/app/oraInventory/ContentsXML
chmod 777 /oracle/app/oraInventory/ContentsXML/oui-patch.xml
cd /soft/35940989/35967489/files/bin/
chmod 777 *-- 部分操作
[root@hfcwdb66 ContentsXML]# chmod 777 /oracle/app/oraInventory/ContentsXML/oui-patch.xml
[root@hfcwdb66 ContentsXML]# cd /soft/35940989/35967489/files/bin/
[root@hfcwdb66 bin]# chmod 777 *
[root@hfcwdb66 bin]# cd /oracle/app/oraInventory/
[root@hfcwdb66 oraInventory]# ll
總用量 12
drwxrwx--- 4 grid oinstall   64 3月   8 2023 backup
drwxrwx--- 2 grid oinstall   81 3月   8 2023 ContentsXML
drwxrwx--- 6 grid oinstall 4096 3月   8 2023 logs
-rw-rw---- 1 grid oinstall   59 3月   8 2023 oraInst.loc
-rwxrwx--- 1 grid oinstall 1644 3月   8 2023 orainstRoot.sh
[root@hfcwdb66 oraInventory]# cd ContentsXML/
[root@hfcwdb66 ContentsXML]# ll
總用量 16
-rw-rw---- 1 grid oinstall 300 3月   8 2023 comps.xml
-rw-rw---- 1 grid oinstall 557 3月   8 2023 inventory.xml
-rw-rw---- 1 grid oinstall 292 3月   8 2023 libs.xml
-rwxrwxrwx 1 grid oinstall 174 3月   8 2023 oui-patch.xml
[root@hfcwdb66 ContentsXML]# scp oui-patch.xml hfcwdb67:/oracle/app/oraInventory/ContentsXML/
root@hfcwdb67's password:
oui-patch.xml

7. 使用root用戶應用補丁【節點1打完，再打節點2】

節點 1 停庫停監聽，節點 2 啟庫啟監聽，節點 1， 先打 grid，再打 oralce，打完后把節點 1 啟庫啟監聽，再打節點 2，節點 2 停庫停監聽。

#打節點1補丁
-- 停止節點1的數據庫和監聽，開始節點2 的監聽和數據庫
su - root
cd /
export ORACLE_BASE=/oracle/app/grid 
export ORACLE_HOME=/oracle/app/19c/grid 
export PATH=/oracle/app/19c/grid/bin:/oracle/app/19d/grid/OPatch:$PATH -- 打grid
/oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/19c/grid 
-- 補丁時間比較長，日志在/oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/
-- [Dec 10, 2024 9:57:46 PM] [INFO]    EXITING METHOD: NApply(patches,options) --日志顯示這個級別上是已經安裝好了。# 查看版本的命令
opatch lspatches -- 打oracle
/oracle/app/oracle/product/19c/db_1/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/oracle/product/19c/db_1
-- 補丁時間比較長，日志在/oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/core/opatch/# 查看版本的命令
opatch lspatches #打節點2補丁
-- 啟動節點1數據庫
srvctl start instance -d hfcwdb -i hfcwdb1# 以下是節點2的
srvctl stop instance -d hfcwdb -i hfcwdb2-- 打grid
/oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/19c/grid
-- 補丁時間比較長，日志在/oracle/app/19c/grid/cfgtoollogs/opatchauto/core/opatch/
-- EXITING METHOD: NApply(patches,options) --日志顯示這個級別上是已經安裝好了。-- 打oracle
/oracle/app/oracle/product/19c/db_1/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/oracle/product/19c/db_1
-- [Dec 10, 2024 10:49:24 PM] [INFO]   EXITING METHOD: NApply(patches,options)  --日志顯示這個級別上是已經安裝好了。# 查看版本的命令
opatch lspatches ===============================================其他說也可以直接以前打，但是我這里失敗，所以我用的上面的分開給grid和oracle打補丁==================================# 節點1
su - root
cd /
export ORACLE_BASE=/oracle/app/grid 
export ORACLE_HOME=/oracle/app/19c/grid 
export PATH=/oracle/app/19c/grid/bin:/oracle/app/19d/grid/OPatch:$PATH 
# 打補丁
/oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/19c/grid 
或
opatchauto apply /soft/35940989 # 節點2，在打節點2之前，注意先把節點一的服務啟動
su - root
cd /
# 打補丁
/u01/app/19.3.0/grid/OPatch/opatchauto apply /soft/35940989
或
opatchauto apply /soft/35940989 # 查看版本的命令
opatch lspatches ==============================================================================================================-- 部分日志
[grid@hfcwdb66:/oracle/app/19c/grid/OPatch]$opatch lspatches
36115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)OPatch succeeded.[root@hfcwdb66 /]# /oracle/app/oracle/product/19c/db_1/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/oracle/product/19c/db_1OPatchauto session is initiated at Tue Dec 10 20:03:23 2024System initialization log file is /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2024-12-10_08-03-42PM.log.會話日志文件是/oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2024-12-10_08-04-04PM.log
此會話的 ID 為 Q2PEExecuting OPatch prereq operations to verify patch applicability on home /oracle/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /oracle/app/oracle/product/19c/db_1Executing patch validation checks on home /oracle/app/oracle/product/19c/db_1
Patch validation checks successfully completed on home /oracle/app/oracle/product/19c/db_1Verifying SQL patch applicability on home /oracle/app/oracle/product/19c/db_1
No sqlpatch prereq operations are required on the local node for this home
No step execution required.........Preparing to bring down database service on home /oracle/app/oracle/product/19c/db_1
No step execution required.........Performing prepatch operation on home /oracle/app/oracle/product/19c/db_1
Prepatch operation completed successfully on home /oracle/app/oracle/product/19c/db_1Start applying binary patch on home /oracle/app/oracle/product/19c/db_1[oracle@hfcwdb66:/oracle/app/oracle/product/19c/db_1/OPatch]$opatch lspatches
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
30805684;OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)OPatch succeeded.
[oracle@hfcwdb66:/oracle/app/oracle/product/19c/db_1/OPatch]$exit
logout
[root@hfcwdb66 ~]# crsctl check crs
CRS-4639: Could not contact Oracle High Availability Services-- 啟動報錯
[root@hfcwdb66 ~]# crsctl start crs
CRS-6706: Oracle Clusterware Release patch level ('2194295427') does not match Software patch level ('1476904475'). Oracle Clusterware cannot be started.
CRS-4000: Command Start failed, or completed with errors.-- 解決
[root@hfcwdb66 ~]# clscfg -localpatch
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
[root@hfcwdb66 ~]# /oracle/app/19c/grid/crs/install/rootcrs.sh -lock
Using configuration parameter file: /oracle/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:/oracle/app/grid/crsdata/hfcwdb66/crsconfig/crslock_hfcwdb66_2024-12-10_08-56-23PM.log
2024/12/10 20:56:31 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'[root@hfcwdb66 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.--節點2：
[root@hfcwdb67 /]# /oracle/app/19c/grid/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/19c/gridOPatchauto session is initiated at Tue Dec 10 21:04:10 2024System initialization log file is /oracle/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-12-10_09-04-28PM.log.Session log file is /oracle/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-12-10_09-05-14PM.log
The id for this session is RCAUExecuting OPatch prereq operations to verify patch applicability on home /oracle/app/19c/grid
Patch applicability verified successfully on home /oracle/app/19c/gridExecuting patch validation checks on home /oracle/app/19c/grid
Patch validation checks successfully completed on home /oracle/app/19c/gridPerforming prepatch operations on CRS - bringing down CRS service on home /oracle/app/19c/grid
Prepatch operation log file location: /oracle/app/grid/crsdata/hfcwdb67/crsconfig/crs_prepatch_apply_inplace_hfcwdb67_2024-12-10_09-14-04PM.log
CRS service brought down successfully on home /oracle/app/19c/gridStart applying binary patch on home /oracle/app/19c/grid[grid@hfcwdb67:/oracle/app/19c/grid/OPatch]$opatch lspatches
36115038;TOMCAT RELEASE UPDATE 19.0.0.0.0 (36115038)
35967489;OCW RELEASE UPDATE 19.22.0.0.0 (35967489)
35956421;ACFS RELEASE UPDATE 19.22.0.0.0 (35956421)
35943157;Database Release Update : 19.22.0.0.240116 (35943157)
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)OPatch succeeded.[root@hfcwdb67 /]# /oracle/app/oracle/product/19c/db_1/OPatch/opatchauto apply /soft/35940989 -oh /oracle/app/oracle/product/19c/db_1OPatchauto session is initiated at Tue Dec 10 22:09:16 2024System initialization log file is /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatchautodb/systemconfig2024-12-10_10-09-26PM.log.Session log file is /oracle/app/oracle/product/19c/db_1/cfgtoollogs/opatchauto/opatchauto2024-12-10_10-09-33PM.log
The id for this session is JG1MExecuting OPatch prereq operations to verify patch applicability on home /oracle/app/oracle/product/19c/db_1
Patch applicability verified successfully on home /oracle/app/oracle/product/19c/db_1Executing patch validation checks on home /oracle/app/oracle/product/19c/db_1
Patch validation checks successfully completed on home /oracle/app/oracle/product/19c/db_1Verifying SQL patch applicability on home /oracle/app/oracle/product/19c/db_1
No sqlpatch prereq operations are required on the local node for this home
No step execution required.........Preparing to bring down database service on home /oracle/app/oracle/product/19c/db_1
No step execution required.........Performing prepatch operation on home /oracle/app/oracle/product/19c/db_1
Prepatch operation completed successfully on home /oracle/app/oracle/product/19c/db_1Start applying binary patch on home /oracle/app/oracle/product/19c/db_1Last login: Tue Dec 10 22:49:30 2024
[root@hfcwdb67 ~]# crsctl check crs
CRS-4639: Could not contact Oracle High Availability Services
[root@hfcwdb67 ~]# crsctl start crs
CRS-6706: Oracle Clusterware Release patch level ('2194295427') does not match Software patch level ('1476904475'). Oracle Clusterware cannot be started.
CRS-4000: Command Start failed, or completed with errors.
[root@hfcwdb67 ~]# clscfg -localpatch
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
[root@hfcwdb67 ~]# /oracle/app/19c/grid/crs/install/rootcrs.sh -lock
Using configuration parameter file: /oracle/app/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:/oracle/app/grid/crsdata/hfcwdb67/crsconfig/crslock_hfcwdb67_2024-12-10_10-51-25PM.log
2024/12/10 22:51:33 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
[root@hfcwdb67 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

8. 執行相關的升級（只需在一個節點上面執行）

sqlplus / as sysdba
startup
quit
cd $ORACLE_HOME/OPatch
./datapatch -sanity_checks
./datapatch -verbose-- 操作
[oracle@hfcwdb67:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Tue Dec 10 22:52:57 2024
Version 19.22.0.0.0Copyright (c) 1982, 2023, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 2415915888 bytes
Fixed Size                  8942448 bytes
Variable Size             603979776 bytes
Database Buffers         1795162112 bytes
Redo Buffers                7831552 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
[oracle@hfcwdb67:/home/oracle]$cd $ORACLE_HOME/OPatch
[oracle@hfcwdb67:/oracle/app/oracle/product/19c/db_1/OPatch]$./datapatch -sanity_checks
SQL Patching sanity checks version 19.22.0.0.0 on Tue 10 Dec 2024 10:53:57 PM CST
Copyright (c) 2021, 2024, Oracle.  All rights reserved.Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20241210_225357_26521/sanity_checks_20241210_225357_26521.logRunning checks
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 942.
Use of uninitialized value $pdb in hash element at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 946.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
Use of uninitialized value $pdb in concatenation (.) or string at /oracle/app/oracle/product/19c/db_1/sqlpatch/sqlpatch_sanity_checks.pm line 932.
JSON report generated in /oracle/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20241210_225357_26521/sqlpatch_sanity_checks_summary.json file
Checks completed. Printing report:Check: Database component status - OK
Check: PDB Violations - OK
Check: Invalid System Objects - OK
Check: Tablespace Status - OK
Check: Backup jobs - OK
Check: Temp file exists - OK
Check: Temp file online - OK
Check: Data Pump running - OK
Check: Container status - OK
Check: Oracle Database Keystore - OK
Check: Dictionary statistics gathering - OK
Check: Scheduled Jobs - WARNINGExecution of scheduler jobs while database patching is running may lead to failures and/or performance issues.There are jobs currently running or scheduled to be executed during next hour.Consider patching the database when jobs are not running and will not be scheduled to run during patching.To check for jobs that are running or scheduled to run:SELECT owner as schema_name, job_name, state, next_run_dateFROM sys.all_scheduler_jobsWHERE state = 'RUNNING'UNIONSELECT owner as schema_name, job_name, state, next_run_dateFROM sys.all_scheduler_jobsWHERE state = 'SCHEDULED'and cast(next_run_date as date) > sysdateand cast(next_run_date as date) < sysdate + 1/24;:|         JOB_NAME         |            NEXT_RUN_DATE            | SCHEMA_NAME |   STATE   ||--------------------------+-------------------------------------+-------------+-----------||  CLEANUP_NON_EXIST_OBJ   | 10-DEC-24 11.38.31.255550 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------|| CLEANUP_ONLINE_IND_BUILD | 10-DEC-24 11.52.12.122451 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------||    CLEANUP_ONLINE_PMO    | 10-DEC-24 11.52.52.590843 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------||   CLEANUP_TAB_IOT_PMO    | 10-DEC-24 11.52.22.644627 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------||  CLEANUP_TRANSIENT_PKG   | 10-DEC-24 11.52.42.000000 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------||  CLEANUP_TRANSIENT_TYPE  | 10-DEC-24 11.38.30.925943 PM +08:00 |     SYS     | SCHEDULED ||--------------------------+-------------------------------------+-------------+-----------|
Check: GoldenGate triggers - OK
Check: Logminer DDL triggers - OK
Check: Check sys public grants - OK
Check: Statistics gathering running - OK
Check: Optim dictionary upgrade parameter - OK
Check: Symlinks on oracle home path - OK
Check: Central Inventory - OK
Check: Queryable Inventory dba directories - OK
Check: Queryable Inventory locks - OK
Check: Queryable Inventory package - OK
Check: Queryable Inventory external table - ERRORDatapatch uses opatch_xml_inv which is an external table to get OPatch Inventory information.It was not possible to get information from opatch_xml_inv table.Verify external tables work correctly in your environment. Refer to MOS Note 1602089.1 for more details.hfcwdb2:| RESULT  ||---------|| Failure ||---------|
Check: Imperva processes - OK
Check: Guardium processes - OK
Check: Locale - OKRefer to MOS Note 2680521.1 and debug log
/oracle/app/oracle/cfgtoollogs/sqlpatch/sanity_checks_20241210_225357_26521/sanity_checks_debug_20241210_225357_26521.logSQL Patching sanity checks completed on Tue 10 Dec 2024 10:54:56 PM CST
[oracle@hfcwdb67:/oracle/app/oracle/product/19c/db_1/OPatch]$./datapatch -verbose
SQL Patching tool version 19.22.0.0.0 Production on Tue Dec 10 22:55:13 2024
Copyright (c) 2012, 2024, Oracle.  All rights reserved.Log file for this invocation: /oracle/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_27778_2024_12_10_22_55_13/sqlpatch_invocation.logConnecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...doneCurrent state of interim SQL patches:
Interim patch 30805684 (OJVM RELEASE UPDATE: 19.7.0.0.200414 (30805684)):Binary registry: InstalledSQL registry: Applied successfully on 09-MAR-23 12.32.05.334355 AMCurrent state of release update SQL patches:Binary registry:19.22.0.0.0 Release_Update 240104023954: InstalledSQL registry:Applied 19.7.0.0.0 Release_Update 200404035018 successfully on 09-MAR-23 12.32.05.290503 AMAdding patches to installation queue and performing prereq checks...done
Installation queue:No interim patches need to be rolled backPatch 35943157 (Database Release Update : 19.22.0.0.240116 (35943157)):Apply from 19.7.0.0.0 Release_Update 200404035018 to 19.22.0.0.0 Release_Update 240104023954No interim patches need to be applied
Patch installation complete.  Total patches installed: 1Installing patches...
Validating logfiles...done
Patch 35943157 apply: SUCCESSlogfile: /oracle/app/oracle/cfgtoollogs/sqlpatch/35943157/25527362/35943157_apply_HFCWDB_2024Dec10_22_57_27.log (no errors)
SQL Patching tool complete on Tue Dec 10 23:07:09 2024
[oracle@hfcwdb67:/oracle/app/oracle/product/19c/db_1/OPatch]$

Opatch升級的日志，方便以后排錯。

通過網盤分享的文件：opatch2024-12-10_22-11-50PM_1.log等4個文件
鏈接: https://pan.baidu.com/s/1dVur6tANXEIje6CUWAryRA?pwd=6ynq 提取碼: 6ynq?

9. 回退補丁升級

su - root
cd //oracle/app/19c/grid/OPatch/opatchauto rollback /soft/35940989
或
opatchauto rollback /soft/35940989 --部分日志
[root@hfcwdb66 /]# /oracle/app/19c/grid/OPatch/opatchauto rollback /soft/35940989  -oh /oracle/app/19c/grid/OPatchauto session is initiated at Wed Dec 11 08:55:53 2024System initialization log file is /oracle/app/19c/grid/cfgtoollogs/opatchautodb/systemconfig2024-12-11_08-56-23AM.log.會話日志文件是/oracle/app/19c/grid/cfgtoollogs/opatchauto/opatchauto2024-12-11_08-56-50AM.log
此會話的 ID 為 4DBIExecuting OPatch prereq operations to verify patch applicability on home /oracle/app/19c/grid
Patch applicability verified successfully on home /oracle/app/19c/gridExecuting patch validation checks on home /oracle/app/19c/grid
Patch validation checks successfully completed on home /oracle/app/19c/gridPerforming prepatch operations on CRS - bringing down CRS service on home /oracle/app/19c/grid
Prepatch operation log file location: /oracle/app/grid/crsdata/hfcwdb66/crsconfig/crs_prepatch_apply_inplace_hfcwdb66_2024-12-11_09-00-26AM.log
CRS service brought down successfully on home /oracle/app/19c/gridStart rolling back binary patch on home /oracle/app/19c/grid
Binary patch rolled back successfully on home /oracle/app/19c/gridRunning rootadd_rdbms.sh on home /oracle/app/19c/grid
Successfully executed rootadd_rdbms.sh on home /oracle/app/19c/gridPerforming postpatch operations on CRS - starting CRS service on home /oracle/app/19c/grid[grid@hfcwdb66:/home/grid]$cd $ORACLE_HOME
[grid@hfcwdb66:/oracle/app/19c/grid]$cd OPatch
[grid@hfcwdb66:/oracle/app/19c/grid/OPatch]$opatch lspatches
30898856;TOMCAT RELEASE UPDATE 19.0.0.0.0 (30898856)
30869304;ACFS RELEASE UPDATE 19.7.0.0.0 (30869304)
30894985;OCW RELEASE UPDATE 19.7.0.0.0 (30894985)
30869156;Database Release Update : 19.7.0.0.200414 (30869156)OPatch succeeded.
[grid@hfcwdb66:/oracle/app/19c/grid/OPatch]$

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/web/62929.shtml
繁體地址，請注明出處：http://hk.pswp.cn/web/62929.shtml
英文地址，請注明出處：http://en.pswp.cn/web/62929.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

Windows安裝Jira

Windows安裝Jira

下載 Download Jira Data Center | Atlassian https://product-downloads.atlassian.com/software/jira/downloads/atlassian-jira-software-10.3.0-x64.exe 以管理員身份安裝&#xff0c;否則彈出以下提醒 創建和配置MySQL數據庫&#xff1a;參照 Connecting Jira applicat…
閱讀更多...
uniapp - 微信小程序

uniapp - 微信小程序

一、background-image 大圖不顯示的問題 解決方法&#xff1a; 1、使用網絡地址&#xff1b;2、使用 base64 urlTobase64(filePath) {// #ifdef MP-WEIXINlet img ${filePath},imgBase64 wx.getFileSystemManager().readFileSync(img, "base64"),base64Url data:…
閱讀更多...
DETR: End-to-End Object Detection with Transformers論文學習

DETR: End-to-End Object Detection with Transformers論文學習

論文地址&#xff1a;https://arxiv.org/pdf/2005.12872 代碼地址&#xff1a;https://github.com/facebookresearch/detr 相關學習視頻&#xff1a;https://space.bilibili.com/94779326/lists?sid1531941 標題前言&#xff1a; DETR 是 Facebook 團隊于 2020 年提出的基于…
閱讀更多...
LeetCode 24反轉鏈表

LeetCode 24反轉鏈表

單鏈表反轉&#xff1a;詳細解析與代碼實現 在數據結構的學習過程中&#xff0c;鏈表是一個非常重要且有趣的部分&#xff0c;而單鏈表的反轉操作更是常考的基礎知識點。今天就來和大家詳細講講如何實現單鏈表的反轉&#xff0c;并通過代碼示例來加深理解呀。 題目 給定單鏈…
閱讀更多...
Redis學習筆記之——學習計劃

Redis學習筆記之——學習計劃

Redis——Remote Dictionary Server&#xff0c;開源、基于內存、速度快、key-value... Redis做為一個高性能的鍵值存儲系統&#xff0c;廣泛應用于緩存、會話存儲、分布式鎖以及其他需要快速訪問的數據場景中。熟悉掌握redis&#xff0c;似乎已成為廣大碼農們必備的一項技能。…
閱讀更多...
網絡安全教學博客（二）：常見網絡安全威脅剖析

網絡安全教學博客（二）：常見網絡安全威脅剖析

在上一篇博客中&#xff0c;我們了解了網絡安全的基礎概念和重要性。今天&#xff0c;讓我們深入探討一下常見的網絡安全威脅&#xff0c;以便我們能夠更好地識別和防范它們。 惡意軟件&#xff08;Malware&#xff09; 病毒&#xff08;Virus&#xff09;&#xff1a;病毒是一…
閱讀更多...
Vue3狀態管理:Pinia架構設計分析

Vue3狀態管理:Pinia架構設計分析

Vue3狀態管理:Pinia架構設計分析 介紹 在Vue.js開發中&#xff0c;狀態管理是一個非常重要的部分。隨著Vue3的發布&#xff0c;Pinia作為一種新的狀態管理架構也相繼問世。本文將對Pinia架構進行深入分析&#xff0c;幫助讀者了解其設計原理、特點以及在實際項目中的應用。 架構…
閱讀更多...
【IDEA】啟動報錯

【IDEA】啟動報錯

今天啟動IDEA報錯 報錯信息&#xff1a; Cannot connect to already running IDE instance. Exception: Process 5,444 is still running 打開任務管理器&#xff0c;關掉進程ID5444的任務
閱讀更多...
socket編程UDP-實現停等機制（接收確認、超時重傳）

socket編程UDP-實現停等機制（接收確認、超時重傳）

在下面博客中&#xff0c;我介紹了利用UDP模擬TCP連接、按數據包發送文件的過程&#xff0c;并附上完整源碼。 socket編程UDP-文件傳輸&模擬TCP建立連接脫離連接&#xff08;進階篇&#xff09;_udp socket發送-CSDN博客 下面博客實現的是滑動窗口機制&#xff1a; sock…
閱讀更多...
uniapp小程序的錨點定位（將頁面滾動到目標位置）

uniapp小程序的錨點定位（將頁面滾動到目標位置）

小程序中&#xff0c;a頁面跳轉到b頁面&#xff0c;跳轉后滾動定位到b頁面的特定位置。 1.uni.pageScrollTo傳遞一個scrollTop參數可以滾動到特定位置。2.可以通過 uni.createSelectorQuery()等獲取定位元素的位置信息。3.uni.getSystemInfoSync()獲取設備的導航欄和狀態欄高度…
閱讀更多...
php基礎：命名空間

php基礎：命名空間

1.PHP 命名空間可以解決以下兩類問題&#xff1a; 1.用戶編寫的代碼與PHP內部的類/函數/常量或第三方類/函數/常量之間的名字沖突。 2.為很長的標識符名稱(通常是為了緩解第一類問題而定義的)創建一個別名&#xff08;或簡短&#xff09;的名稱&#xff0c;以提高源代碼的可讀…
閱讀更多...
分布式 CAP理論 總結

分布式 CAP理論 總結

前言 相關系列 《分布式 & 目錄》《分布式 & CAP理論 & 總結》《分布式 & CAP理論 & 問題》 分布式 分布式的核心是將大型業務拆解成多個子業務以使之在不同的機器上執行。分布式是用于解決單個物理機容量&性能瓶頸問題而采用的優化手段&#xf…
閱讀更多...
python xpath解析筆記

python xpath解析筆記

與bs4的區別 bs4有很多屬性和方法&#xff0c;而xpath只有一個方法&#xff0c;是通過不同的xpath表達式實現很多功能的。 html例子 定位 tree.xpath(‘/html/head/title’) 返回列表。 開頭的斜杠表示從根節點遍歷。 中間的斜杠表示層級。&#xff08;相當于bs4中的>…
閱讀更多...
Q學習（Q-Learning）詳解

Q學習（Q-Learning）詳解

?作者簡介&#xff1a;2022年博客新星 第八。熱愛國學的Java后端開發者&#xff0c;修心和技術同步精進。 &#x1f34e;個人主頁&#xff1a;Java Fans的博客 &#x1f34a;個人信條&#xff1a;不遷怒&#xff0c;不貳過。小知識&#xff0c;大智慧。 &#x1f49e;當前專欄…
閱讀更多...
樹狀數組詳解

樹狀數組詳解

概述 樹狀數組&#xff08;Binary Indexed Tree&#xff0c;簡稱BIT&#xff09;&#xff0c;是一種數據結構&#xff0c;用于處理區間查詢和更新問題。它是一種可以高效地在對數級別時間復雜度內進行單點更新和區間查詢的數據結構。樹狀數組通常用于解決以下兩類問題&#xf…
閱讀更多...
freeswitch(開啟支持MCU視頻會議,使用mod_av模塊)

freeswitch(開啟支持MCU視頻會議,使用mod_av模塊)

親測版本centos 7.9系統–》 freeswitch1.10.9 本人freeswitch安裝路徑（根據自己的路徑進入） /usr/local/freeswitch/etc/freeswitch場景說明： 有些場景想使用視頻會議MCU融合畫面進行開會使用方法： 第一步：下載插件 yum install -y epel-release yum install
閱讀更多...
【大數據技術基礎】【記錄Ubuntu 16.04升級到18.04】Ubuntu的一個版本升級到另一個版本

【大數據技術基礎】【記錄Ubuntu 16.04升級到18.04】Ubuntu的一個版本升級到另一個版本

在 Ubuntu 操作系統中進行軟件更新和系統升級 Ubuntu Kylin 16.04 LTS 系統進行系統升級到 Ubuntu 18.04.6 LTS 版本 升級提示&#xff1a;系統彈出提示框&#xff0c;告知用戶有新版本的 Ubuntu 可用&#xff0c;詢問用戶是否想要升級。 認證窗口&#xff1a;顯示了一個認證…
閱讀更多...
這是一個vue3 + scss的數字滾動效果

這是一個vue3 + scss的數字滾動效果

介紹: 當數字變化時&#xff0c;只改變變化的數字位&#xff0c;其余的不變&#xff0c;可以遞增、遞減、驟變、負數也可以&#xff0c;但是樣式要根據具體的項目需求去改&#xff1b; 效果1、增加數字&#xff1a; 效果2、減少數字&#xff1a; 使用方法&#xff1a; <te…
閱讀更多...
TortoiseGit的下載、安裝和配置

TortoiseGit的下載、安裝和配置

一、TortoiseGit的簡介 tortoiseGit是一個開放的git版本控制系統的源客戶端&#xff0c;支持Winxp/vista/win7.該軟件功能和git一樣 不同的是&#xff1a;git是命令行操作模式&#xff0c;tortoiseGit界面化操作模式&#xff0c;不用記git相關命令就可以直接操作&#xff0c;讀…
閱讀更多...
最新版Chrome瀏覽器加載ActiveX控件之Adobe PDF閱讀器控件

最新版Chrome瀏覽器加載ActiveX控件之Adobe PDF閱讀器控件

背景 Adobe PDF閱讀器控件是一個ActiveX控件&#xff0c;用于在Windows平臺上顯示和操作PDF文件。它提供了一系列方法和屬性&#xff0c;可以實現對PDF文件的加載、顯示、搜索、打印、保存等操作。 allWebPlugin中間件是一款為用戶提供安全、可靠、便捷的瀏覽器插件服務的中間件…
閱讀更多...
最新文章

Copyright @ 2022~2023