CentOS7 安装 Oracle 11g rac（9） —— 安装 Oracle 软件
目录
CentOS7 安装 Oracle 11g rac（9） —— 安装 Oracle 软件一、创建磁盘组1、在节点 rac1 创建两个磁盘组 DATA 和 BAK2、在节点 rac2 上修改磁盘组的状态为 mount
二、修改 oracle 响应文件1、解压缩安装包2、修改 oracle 响应文件
三、开始安装 oracle 软件1、执行 runInstaller 命令开始安装 oracle2、修改之后重新执行 runInstaller 命令3、切换到 root 用户，在 rac1、rac2 执行以下脚本
四、查看集群状态
一、创建磁盘组
1、在节点 rac1 创建两个磁盘组 DATA 和 BAK
-- 创建磁盘组 data
create diskgroup data external redundancy disk '/dev/oracleasm/disks/DATA1';
--为磁盘组 data 添加磁盘
alter diskgroup data add disk '/dev/oracleasm/disks/DATA2';
-- 创建磁盘组 bak
create diskgroup bak external redundancy disk '/dev/oracleasm/disks/BAK1';
--为磁盘组 bak 添加磁盘
alter diskgroup bak add disk '/dev/oracleasm/disks/BAK2';
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 13 21:36:15 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create diskgroup data external redundancy disk '/dev/oracleasm/disks/DATA1';
Diskgroup created.
SQL> alter diskgroup data add disk '/dev/oracleasm/disks/DATA2';
Diskgroup altered.
SQL> create diskgroup bak external redundancy disk '/dev/oracleasm/disks/BAK1';
Diskgroup created.
SQL> alter diskgroup bak add disk '/dev/oracleasm/disks/BAK2';
Diskgroup altered.
-- 查看磁盘组信息
SQL> select INST_ID,name,free_mb,state from gv$asm_diskgroup;
INST_ID NAME FREE_MB STATE
---------- ------------------------------ ---------- -----------
1 OCR 2146 MOUNTED
1 DATA 8140 MOUNTED
1 BAK 8140 MOUNTED
2 OCR 2146 MOUNTED
2 BAK 0 DISMOUNTED
2 DATA 0 DISMOUNTED
6 rows selected.
2、在节点 rac2 上修改磁盘组的状态为 mount
在添加了磁盘组后在另一个节点是处于unmount 状态，所以需要在另一个节点将磁盘组设置为 mount 状态。在个节点 rac2 上执行如下操作：
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jun 13 21:36:28 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> alter diskgroup bak mount;
Diskgroup altered.
--查看磁盘组信息
SQL> select INST_ID,name,free_mb,state from gv$asm_diskgroup;
INST_ID NAME FREE_MB STATE
---------- ------------------------------ ---------- -----------
2 OCR 2146 MOUNTED
2 BAK 8097 MOUNTED
2 DATA 8097 MOUNTED
1 OCR 2146 MOUNTED
1 DATA 8097 MOUNTED
1 BAK 8097 MOUNTED
6 rows selected.
二、修改 oracle 响应文件
1、解压缩安装包
[root@rac1 ~]# su - oracle
上一次登录：日 6月 12 23:58:02 CST 2022pts/1 上
[oracle@rac1 ~]$ ll
total 2487200
-rw-r--r--. 1 oracle oinstall 1395582860 Jan 7 2020 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r--. 1 oracle oinstall 1151304589 Jan 7 2020 p13390677_112040_Linux-x86-64_2of7.zip
# 解压缩安装文件
[oracle@rac1 ~]$ unzip p13390677_112040_Linux-x86-64_1of7.zip
[oracle@rac1 ~]$ unzip p13390677_112040_Linux-x86-64_2of7.zip
[oracle@rac1 ~]$ ll
total 2487200
drwxr-xr-x 7 oracle oinstall 136 Aug 27 2013 database
-rw-r--r--. 1 oracle oinstall 1395582860 Jan 7 2020 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r--. 1 oracle oinstall 1151304589 Jan 7 2020 p13390677_112040_Linux-x86-64_2of7.zip
2、修改 oracle 响应文件
[oracle@rac1 ~]$ cd database/
[oracle@rac1 database]$ ll
total 44
drwxr-xr-x 4 oracle oinstall 248 Aug 27 2013 install
-rw-r--r-- 1 oracle oinstall 30016 Aug 27 2013 readme.html
drwxr-xr-x 2 oracle oinstall 61 Aug 27 2013 response
drwxr-xr-x 2 oracle oinstall 34 Aug 27 2013 rpm
-rwxr-xr-x 1 oracle oinstall 3267 Aug 27 2013 runInstaller
drwxr-xr-x 2 oracle oinstall 29 Aug 27 2013 sshsetup
drwxr-xr-x 14 oracle oinstall 4096 Aug 27 2013 stage
-rw-r--r-- 1 oracle oinstall 500 Aug 27 2013 welcome.html
[oracle@rac1 database]$ cd response/
[oracle@rac1 response]$ ll
total 80
-rwxr-xr-x 1 oracle oinstall 44533 Aug 27 2013 dbca.rsp
-rw-r--r-- 1 oracle oinstall 25116 Aug 27 2013 db_install.rsp
-rwxr-xr-x 1 oracle oinstall 5871 Aug 27 2013 netca.rsp
[oracle@rac1 response]$ cp db_install.rsp db_install.rsp.bak
[oracle@rac1 response]$ ll
total 108
-rwxr-xr-x 1 oracle oinstall 44533 Aug 27 2013 dbca.rsp
-rw-r--r-- 1 oracle oinstall 25116 Aug 27 2013 db_install.rsp
-rw-r--r-- 1 oracle oinstall 25116 Jun 13 21:51 db_install.rsp.bak
-rwxr-xr-x 1 oracle oinstall 5871 Aug 27 2013 netca.rsp
[oracle@rac1 response]$ vi db_install.rsp
文件 db_install.rsp 的内容如下：
# 标注响应文件版本（不要修改）
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
# 选择安装类型：INSTALL_DB_SWONLY（只安装数据库软件 ）
oracle.install.option=INSTALL_DB_SWONLY
# 指定主机名：rac1
ORACLE_HOSTNAME=rac1
#指定oracle inventory目录的所有者：oinstall
UNIX_GROUP_NAME=oinstall
#指定产品清单oracle inventory目录的路径：/u01/app/oraInventory
INVENTORY_LOCATION=/u01/app/oraInventory
#指定数据库语言：en,zh_CN
SELECTED_LANGUAGES=en,zh_CN
# 设置ORALCE_HOME的路径：/u01/app/oracle/product/11.2.0/db_1
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
# 设置ORALCE_BASE的路径：/u01/app/oracle
ORACLE_BASE=/u01/app/oracle
#选择Oracle安装数据库软件的版本：EE（企业版）
oracle.install.db.InstallEdition=EE
# 是否自定义Oracle的组件：false（安装默认组件）
oracle.install.db.EEOptionsSelection=false
# 要安装的组件列表（不要修改）
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0
#指定拥有OSDBA权限的用户组：dba
oracle.install.db.DBA_GROUP=dba
#指定拥有OSOPER权限的用户组：oinstall
oracle.install.db.OPER_GROUP=oinstall
#指定要安装oracle软件的节点：rac1,rac2
oracle.install.db.CLUSTER_NODES=rac1,rac2
# 是否安装单节点rac：false
oracle.install.db.isRACOneInstall=
# 安装单节点rac的服务名称
oracle.install.db.racOneServiceName=
#选择数据库的用途：GENERAL_PURPOSE（一般用途/事务处理）
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
# 指定数据库的GlobalName（全局名称）：不创建数据库，不用设置
oracle.install.db.config.starterdb.globalDBName=
# 指定数据库的SID：不创建数据库，不用设置
oracle.install.db.config.starterdb.SID=
#选择字符集：AL32UTF8
oracle.install.db.config.starterdb.characterSet=AL32UTF8
#11g的新特性：自动内存管理：true
oracle.install.db.config.starterdb.memoryOption=true
#指定Oracle自动管理内存的大小：800MB
oracle.install.db.config.starterdb.memoryLimit=800
#是否载入模板示例：false
oracle.install.db.config.starterdb.installExampleSchemas=false
#是否启用安全设置：true
oracle.install.db.config.starterdb.enableSecuritySettings=true
#设置数据库用户密码
#设定所有数据库用户使用同一个密码，其它数据库用户就不用单独设置了。
oracle.install.db.config.starterdb.password.ALL=oracle
#设定SYS用户的密码：不用设定，统一使用 oracle 作为密码
oracle.install.db.config.starterdb.password.SYS=
#设定SYSTEM用户的密码：不用设定，统一使用 oracle 作为密码
oracle.install.db.config.starterdb.password.SYSTEM=
#设定SYSMAN用户的密码：不用设定，统一使用 oracle 作为密码
oracle.install.db.config.starterdb.password.SYSMAN=
#设定DBSNMP用户的密码：不用设定，统一使用 oracle 作为密码
oracle.install.db.config.starterdb.password.DBSNMP=
# 使用数据库本地管理工具：DB_CONTROL
oracle.install.db.config.starterdb.control=DB_CONTROL
#当上一个选项设置为GRID_CONTROL时，才需要设定grid control的远程路径URL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
# 设置自动备份：false
oracle.install.db.config.starterdb.automatedBackup.enable=false
# 不是自动备份：不用设置
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
#指定存储类型：ASM_STORAGE
oracle.install.db.config.starterdb.storageType=ASM_STORAGE
# 不使用文件系统：不用设置
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
#指定ASM的磁盘组：DATA
oracle.install.db.config.asm.diskGroup=DATA
#指定ASM实例密码：oracle
oracle.install.db.config.asm.ASMSNMPPassword=oracle
# 不使用metalink账户：不用设置
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
# 是否设置安全更新
# False表示不需要设置安全更新，在11.2的静默安装中必须指定为true，否则会提示错误
DECLINE_SECURITY_UPDATES=true
# 不使用代理服务器，不用设置
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
# 自动更新：SKIP_UPDATES
oracle.installer.autoupdates.option=SKIP_UPDATES
# 不使用自动：不用设置
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
三、开始安装 oracle 软件
1、执行 runInstaller 命令开始安装 oracle
[oracle@rac1 database]$ pwd
/home/oracle/database
[oracle@rac1 database]$ ll
total 44
drwxr-xr-x 4 oracle oinstall 248 Aug 27 2013 install
-rw-r--r-- 1 oracle oinstall 30016 Aug 27 2013 readme.html
drwxr-xr-x 2 oracle oinstall 87 Jun 13 22:00 response
drwxr-xr-x 2 oracle oinstall 34 Aug 27 2013 rpm
-rwxr-xr-x 1 oracle oinstall 3267 Aug 27 2013 runInstaller
drwxr-xr-x 2 oracle oinstall 29 Aug 27 2013 sshsetup
drwxr-xr-x 14 oracle oinstall 4096 Aug 27 2013 stage
-rw-r--r-- 1 oracle oinstall 500 Aug 27 2013 welcome.html
[oracle@rac1 database]$ ./runInstaller -showProgress -ignorePrereq -silent -responseFile /
home/oracle/database/response/db_install.rspStarting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 12158 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4195 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-06-13_10-13-47PM.
Please wait ...[oracle@rac1 database]$ [FATAL] [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster. CAUSE: Before you can install Oracle RAC, you must install Oracle Grid Infrastructure on all servers (Oracle Clusterware and Oracle ASM) to cr
eate a cluster. ACTION: Oracle Grid Infrastructure is not installed. Install it either from the separate installation media included in your media pack, or in
stall it by downloading it from Electronic Product Delivery (EPD) or the Oracle Technology Network (OTN). Oracle Grid Infrastructure normally is installed by a different operating system user than the one used for Oracle Database. It may need to be installed by your system administrator. See the installation guide for more details.
# 安装时出现问题：[FATAL] [INS-35354] 集群无效，节点没有准备好！
[oracle@rac1 database]$ cd /u01/app/oraInventory/ContentsXML
[oracle@rac1 ContentsXML]$ ls
comps.xml inventory.xml libs.xml
[oracle@rac1 ContentsXML]$ ll
total 12
-rw-rw---- 1 grid oinstall 329 Jun 13 20:21 comps.xml
-rw-rw---- 1 grid oinstall 558 Jun 13 20:20 inventory.xml
-rw-rw---- 1 grid oinstall 292 Jun 13 20:21 libs.xml
[oracle@rac1 ContentsXML]$ vi inventory.xml
# ===========================================================================================
# ===========================================================================================
2、修改之后重新执行 runInstaller 命令
[oracle@rac1 ContentsXML]$ cd ~
[oracle@rac1 ~]$ cd database
[oracle@rac1 database]$ ls
install readme.html response rpm runInstaller sshsetup stage welcome.html
[oracle@rac1 database]$ ./runInstaller -showProgress -ignorePrereq -silent -responseFile /home/oracle/database/response/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 12152 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4195 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-06-13_10-28-40PM. Please wait ...[oracle@rac1 database]$ You can find the
log of this install session at: /u01/app/oraInventory/logs/installActions2022-06-13_10-28-40PM.log
Prepare in progress.
.................................................. 9% Done.
Prepare successful.
Copy files in progress.
.................................................. 14% Done.
.................................................. 19% Done.
.................................................. 25% Done.
.................................................. 30% Done.
.................................................. 36% Done.
.................................................. 41% Done.
.................................................. 46% Done.
.................................................. 51% Done.
.................................................. 56% Done.
Copy files successful.
..........
Link binaries in progress.
Link binaries successful.
.................................................. 77% Done.
Setup files in progress.
.................................................. 94% Done.
Setup files successful.
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2022-06-13_10-28-40PM.log' for more details.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /u01/app/oracle/product/11.2.0/db_1/root.sh
Execute /u01/app/oracle/product/11.2.0/db_1/root.sh on the following nodes:
[rac1, rac2]
.................................................. 100% Done.
Execute Root Scripts successful.
Successfully Setup Software.
3、切换到 root 用户，在 rac1、rac2 执行以下脚本
# 节点1
[root@rac1 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Check /u01/app/oracle/product/11.2.0/db_1/install/root_rac1_2022-06-13_22-51-13.log for the output of root script
# 节点2
[root@rac2 ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Check /u01/app/oracle/product/11.2.0/db_1/install/root_rac2_2022-06-13_22-51-29.log for the output of root script
四、查看集群状态
[grid@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.BAK.dg ora....up.type ONLINE ONLINE rac1
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac1
ora.OCR.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type ONLINE ONLINE rac2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac2
ora.ons ora.ons.type ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora.scan1.vip ora....ip.type ONLINE ONLINE rac1
推荐阅读
您阅读本篇文章共花了：
发表评论