ORACLE12CR2 RAC安裝部署（REDHAT7.6）五、安裝ORACLE軟件

查看OPatch補丁信息：

[grid@fdcdb02 OPatch]$ opatch lspatches 26839277;DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277) 32231681;ACFS JAN 2021 RELEASE UPDATE 12.2.0.1.210119 (32231681) 32253903;TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:RELEASE) (32253903) 31802727;OCW OCT 2020 RELEASE UPDATE 12.2.0.1.201020 (31802727) 32228578;Database Jan 2021 Release Update : 12.2.0.1.210119 (32228578) OPatch succeeded. [root@fdcdb01 32226491]# ll total 136 drwxr-x--- 4 grid oinstall 48 Jan 10 12:34 26839277 drwxr-x--- 5 grid oinstall 62 Jan 10 12:27 31802727 drwxr-x--- 5 grid oinstall 81 Jan 10 12:25 32228578 drwxr-x--- 5 grid oinstall 62 Jan 10 12:29 32231681 drwxr-x--- 4 grid oinstall 48 Jan 10 12:29 32253903 drwxr-x--- 2 grid oinstall 4096 Jan 10 12:25 automation -rw-rw-r-- 1 grid oinstall 5828 Jan 10 21:02 bundle.xml -rw-r--r-- 1 grid oinstall 123977 Jan 10 20:42 README.html -rw-r--r-- 1 grid oinstall 0 Jan 10 12:25 README.txt

補丁應用成功。

7、檢查集群狀態

ASM磁盤OCR檢查：

5、創建ASM DATA盤

檢查ASM磁盤組情況：

所有主機reboot檢查集群是否運行正常。

四、安裝ORACLE軟件

1、安裝ORACLE軟件

[oracle@fdcdb01 database]$ ./runInstaller Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB. Actual 261237 MB Passed Checking swap space: must be greater than 150 MB. Actual 32767 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-04-02_10-03-42AM. Please wait ...[

2、執行ROOT.SH

一節點：

[root@fdcdb01 database]# /u01/app/oracle/product/12.2.0/db/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.2.0/db Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.

二節點：

[root@fdcdb02 grid]# /u01/app/oracle/product/12.2.0/db/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/12.2.0/db Enter the full pathname of the local bin directory: [/usr/local/bin]: The contents of "dbhome" have not changed. No need to overwrite. The contents of "oraenv" have not changed. No need to overwrite. The contents of "coraenv" have not changed. No need to overwrite. Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.

執行成功。

Oracle軟件安裝成功。

2、安裝Oracle RU補丁集（以下操作兩節點都需要執行）

更換OPatch包：

##更換OPatch包： ##兩個節點需要同時更換： su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch version" ##OPatch Version: 12.2.0.1.6 ##You must use the OPatch utility version 12.2.0.1.23 or later to apply this patch. ##這里不能刪除原來的OPatch包，而是選擇覆蓋，否則安裝會報錯： ##解壓補丁包 su - oracle -c "unzip /soft/p6880880_122010_Linux-x86-64.zip -d /u01/app/oracle/product/12.2.0/db/" ##選擇A su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch version" ##OPatch Version: 12.2.0.1.24

Validation of Oracle Inventory：

su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/12.2.0/db/" [root@fdcdb01 database]# su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/12.2.0/db/" Oracle Interim Patch Installer version 12.2.0.1.24 Copyright (c) 2021, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/12.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/db//oraInst.loc OPatch version : 12.2.0.1.24 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2021-04-02_10-36-30AM_1.log Lsinventory Output file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2021-04-02_10-36-30AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: fdcdb01 ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Database 12c 12.2.0.1.0 There are 1 products installed in this Oracle Home. Installed Products (128): Assistant Common Files 12.2.0.1.0 BLASLAPACK Component 12.2.0.1.0 Buildtools Common Files 12.2.0.1.0 Cluster Verification Utility Common Files 12.2.0.1.0 Database Configuration and Upgrade Assistants 12.2.0.1.0 Database Migration Assistant for Unicode 12.2.0.1.0 Database SQL Scripts 12.2.0.1.0 Database Workspace Manager 12.2.0.1.0 DB TOOLS Listener 12.2.0.1.0 Deinstallation Tool 12.2.0.1.0 Enterprise Edition Options 12.2.0.1.0 Expat libraries 2.0.1.0.3 Generic Connectivity Common Files 12.2.0.1.0 Hadoopcore Component 12.2.0.1.0 HAS Common Files 12.2.0.1.0 HAS Files for DB 12.2.0.1.0 Installation Common Files 12.2.0.1.0 Installation Plugin Files 12.2.0.1.0 Installer SDK Component 12.2.0.1.4 JAccelerator (COMPANION) 12.2.0.1.0 Java Development Kit 1.8.0.91.0 LDAP Required Support Files 12.2.0.1.0 OLAP SQL Scripts 12.2.0.1.0 Oracle Advanced Analytics 12.2.0.1.0 Oracle Advanced Security 12.2.0.1.0 Oracle Application Express 12.2.0.1.0 Oracle Bali Share 11.1.1.6.0 Oracle Call Interface (OCI) 12.2.0.1.0 Oracle Clusterware RDBMS Files 12.2.0.1.0 Oracle Configuration Manager 12.1.2.0.0 Oracle Configuration Manager Client 10.3.2.1.0 Oracle Configuration Manager Deconfiguration 10.3.1.0.0 Oracle Context Companion 12.2.0.1.0 Oracle Core Required Support Files 12.2.0.1.0 Oracle Core Required Support Files for Core DB 12.2.0.1.0 Oracle Database 12c 12.2.0.1.0 Oracle Database 12c 12.2.0.1.0 Oracle Database 12c Multimedia Files 12.2.0.1.0 Oracle Database Deconfiguration 12.2.0.1.0 Oracle Database Gateway for ODBC 12.2.0.1.0 Oracle Database Utilities 12.2.0.1.0 Oracle Database Vault option 12.2.0.1.0 Oracle DBCA Deconfiguration 12.2.0.1.0 Oracle Extended Windowing Toolkit 11.1.1.6.0 Oracle Globalization Support 12.2.0.1.0 Oracle Globalization Support 12.2.0.1.0 Oracle Globalization Support For Core 12.2.0.1.0 Oracle Help for Java 11.1.1.7.0 Oracle Help Share Library 11.1.1.7.0 Oracle Ice Browser 11.1.1.7.0 Oracle Internet Directory Client 12.2.0.1.0 Oracle Java Client 12.2.0.1.0 Oracle JDBC Server Support Package 12.2.0.1.0 Oracle JDBC/OCI Instant Client 12.2.0.1.0 Oracle JDBC/THIN Interfaces 12.2.0.1.0 Oracle JFC Extended Windowing Toolkit 11.1.1.6.0 Oracle JVM 12.2.0.1.0 Oracle JVM For Core 12.2.0.1.0 Oracle Label Security 12.2.0.1.0 Oracle LDAP administration 12.2.0.1.0 Oracle Locale Builder 12.2.0.1.0 Oracle Message Gateway Common Files 12.2.0.1.0 Oracle Multimedia 12.2.0.1.0 Oracle Multimedia Client Option 12.2.0.1.0 Oracle Multimedia Java Advanced Imaging 12.2.0.1.0 Oracle Multimedia Locator 12.2.0.1.0 Oracle Multimedia Locator Java Required Support Files 12.2.0.1.0 Oracle Multimedia Locator RDBMS Files 12.2.0.1.0 Oracle Net 12.2.0.1.0 Oracle Net Listener 12.2.0.1.0 Oracle Net Required Support Files 12.2.0.1.0 Oracle Net Services 12.2.0.1.0 Oracle Netca Client 12.2.0.1.0 Oracle Notification Service 12.2.0.1.0 Oracle Notification Service for Instant Client 12.2.0.1.0 Oracle ODBC Driver 12.2.0.1.0 Oracle ODBC Driverfor Instant Client 12.2.0.1.0 Oracle OLAP 12.2.0.1.0 Oracle OLAP API 12.2.0.1.0 Oracle OLAP RDBMS Files 12.2.0.1.0 Oracle One-Off Patch Installer 12.2.0.1.6 Oracle Partitioning 12.2.0.1.0 Oracle Programmer 12.2.0.1.0 Oracle R Enterprise Server Files 12.2.0.1.0 Oracle RAC Deconfiguration 12.2.0.1.0 Oracle RAC Required Support Files-HAS 12.2.0.1.0 Oracle Real Application Testing 12.2.0.1.0 Oracle Recovery Manager 12.2.0.1.0 Oracle Scheduler Agent 12.2.0.1.0 Oracle Security Developer Tools 12.2.0.1.0 Oracle Spatial and Graph 12.2.0.1.0 Oracle SQL Developer 12.2.0.1.0 Oracle Starter Database 12.2.0.1.0 Oracle Text 12.2.0.1.0 Oracle Text ATG Language Support Files 12.2.0.1.0 Oracle Text Required Support Files 12.2.0.1.0 Oracle Universal Connection Pool 12.2.0.1.0 Oracle Universal Installer 12.2.0.1.4 Oracle USM Deconfiguration 12.2.0.1.0 Oracle Wallet Manager 12.2.0.1.0 Oracle XML Development Kit 12.2.0.1.0 Oracle XML Query 12.2.0.1.0 oracle.swd.commonlogging 13.3.0.0.0 oracle.swd.opatchautodb 12.2.0.1.5 oracle.swd.oui.core.min 12.2.0.1.4 Parser Generator Required Support Files 12.2.0.1.0 Perl Interpreter 5.22.0.0.0 Perl Modules 5.22.0.0.0 PL/SQL 12.2.0.1.0 PL/SQL Embedded Gateway 12.2.0.1.0 Platform Required Support Files 12.2.0.1.0 Precompiler Common Files 12.2.0.1.0 Precompiler Common Files for Core 12.2.0.1.0 Precompiler Required Support Files 12.2.0.1.0 Precompilers 12.2.0.1.0 RDBMS Required Support Files 12.2.0.1.0 RDBMS Required Support Files for Instant Client 12.2.0.1.0 Required Support Files 12.2.0.1.0 Secure Socket Layer 12.2.0.1.0 SQL*Plus 12.2.0.1.0 SQL*Plus Files for Instant Client 12.2.0.1.0 SQL*Plus Required Support Files 12.2.0.1.0 SQLJ Runtime 12.2.0.1.0 SSL Required Support Files for InstantClient 12.2.0.1.0 Tracle File Analyzer 12.2.0.1.0 XDK Required Support Files 12.2.0.1.0 XML Parser for Java 12.2.0.1.0 XML Parser for Oracle JVM 12.2.0.1.0 There are 128 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. [root@fdcdb01 database]#

Run OPatch Conflict Check：

su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/32226491/32228578" su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/32226491/31802727" [root@fdcdb02 soft]# su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/32226491/32228578" Oracle Interim Patch Installer version 12.2.0.1.24 Copyright (c) 2021, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/db/oraInst.loc OPatch version : 12.2.0.1.24 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2021-04-02_10-42-26AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [root@fdcdb02 soft]# su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/32226491/31802727" Oracle Interim Patch Installer version 12.2.0.1.24 Copyright (c) 2021, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/db/oraInst.loc OPatch version : 12.2.0.1.24 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2021-04-02_10-42-42AM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.

Run OPatch SystemSpace Check：

cat <>/tmp/patch_list_dbhome.txt /soft/32226491/32228578 /soft/32226491/31802727 EOF su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt" [root@fdcdb01 database]# su - oracle -c "/u01/app/oracle/product/12.2.0/db/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt" Oracle Interim Patch Installer version 12.2.0.1.24 Copyright (c) 2021, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/12.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/12.2.0/db/oraInst.loc OPatch version : 12.2.0.1.24 OUI version : 12.2.0.1.4 Log file location : /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatch/opatch2021-04-02_10-48-47AM_1.log Invoking prereq "checksystemspace" Prereq "checkSystemSpace" passed. OPatch succeeded.

opatchauto：

##root用戶執行，按順序在節點1，2執行，不可同時執行 /u01/app/oracle/product/12.2.0/db/OPatch/opatchauto apply /soft/32226491 -oh /u01/app/oracle/product/12.2.0/db ##補丁安裝過程記錄 [root@fdcdb01 database]# /u01/app/oracle/product/12.2.0/db/OPatch/opatchauto apply /soft/32226491 -oh /u01/app/oracle/product/12.2.0/db OPatchauto session is initiated at Fri Apr 2 10:53:11 2021 System initialization log file is /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatchautodb/systemconfig2021-04-02_10-53-13AM.log. Session log file is /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatchauto/opatchauto2021-04-02_10-53-47AM.log The id for this session is GM4I Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.2.0/db Patch applicability verified successfully on home /u01/app/oracle/product/12.2.0/db Executing patch validation checks on home /u01/app/oracle/product/12.2.0/db Patch validation checks successfully completed on home /u01/app/oracle/product/12.2.0/db Verifying SQL patch applicability on home /u01/app/oracle/product/12.2.0/db No step execution required......... Preparing to bring down database service on home /u01/app/oracle/product/12.2.0/db No step execution required......... Performing prepatch operation on home /u01/app/oracle/product/12.2.0/db Perpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db Start applying binary patch on home /u01/app/oracle/product/12.2.0/db Binary patch applied successfully on home /u01/app/oracle/product/12.2.0/db Performing postpatch operation on home /u01/app/oracle/product/12.2.0/db Postpatch operation completed successfully on home /u01/app/oracle/product/12.2.0/db Preparing home /u01/app/oracle/product/12.2.0/db after database service restarted No step execution required......... Trying to apply SQL patch on home /u01/app/oracle/product/12.2.0/db No step execution required......... OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:fdcdb01 RAC Home:/u01/app/oracle/product/12.2.0/db Version:12.2.0.1.0 Summary: ==Following patches were SKIPPED: Patch: /soft/32226491/32231681 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /soft/32226491/26839277 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /soft/32226491/32253903 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /soft/32226491/31802727 Log: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-02_10-54-02AM_1.log Patch: /soft/32226491/32228578 Log: /u01/app/oracle/product/12.2.0/db/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-02_10-54-02AM_1.log OPatchauto session completed at Fri Apr 2 10:56:29 2021 Time taken to complete the session 3 minutes, 18 seconds

查看Oracle已安裝補丁集：

[oracle@fdcdb01 ~]$ opatch lspatches 32228578;Database Jan 2021 Release Update : 12.2.0.1.210119 (32228578) 31802727;OCW OCT 2020 RELEASE UPDATE 12.2.0.1.201020 (31802727) OPatch succeeded.

補丁安裝成功。

Oracle

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。