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

举报
Lucifer三思而后行 发表于 2021/10/28 09:49:37 2021/10/28
【摘要】 查看OPatch补丁信息:[grid@fdcdb02 OPatch]$ opatch lspatches26839277;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 RE...

查看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 <<EOF >>/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.

补丁安装成功。

【版权声明】本文为华为云社区用户原创内容,转载时必须标注文章的来源(华为云社区)、文章链接、文章作者等基本信息, 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@huaweicloud.com
  • 点赞
  • 收藏
  • 关注作者

评论(0

0/1000
抱歉,系统识别当前为高风险访问,暂不支持该操作

全部回复

上滑加载中

设置昵称

在此一键设置昵称,即可参与社区互动!

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。

*长度不超过10个汉字或20个英文字符,设置后3个月内不可修改。