ORACLE12CR2 RAC安装部署(REDHAT7.6)五、安装ORACLE软件

网友投稿 730 2022-05-29

查看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包:

ORACLE12CR2 RAC安装部署(REDHAT7.6)五、安装ORACLE软件

##更换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小时内删除侵权内容。

上一篇:【云驻共创】前端的秘籍-AppCube
下一篇:四面阿里被问MySQL底层如何实现order by的,瞬间懵了!
相关文章