非图形方式静默安装与配置 Oracle 11g RAC（11）——静默安装 oracle 软件
·
非图形方式静默安装与配置 Oracle 11g RAC（11）——静默安装 oracle 软件
文章目录
一、创建磁盘组
1、通过节点 rac1 创建两个磁盘组 DATA 和 BAK
也可以通过节点 rac2 创建磁盘组，因为操作的都是同一块共享磁盘。
--###登录
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 12 19:44:44 2021
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
--创建磁盘组 DATA
SQL> create diskgroup data external redundancy disk '/dev/raw/raw4';
Diskgroup created.
SQL> alter diskgroup data add disk '/dev/raw/raw5';
Diskgroup altered.
--创建磁盘组 BAK
SQL> create diskgroup bak external redundancy disk '/dev/raw/raw6';
Diskgroup created.
SQL> alter diskgroup bak add disk '/dev/raw/raw7';
Diskgroup altered.
--查看磁盘组
SQL> select INST_ID,name,free_mb,state from gv$asm_diskgroup;
INST_ID NAME FREE_MB STATE
---------- ------------------------------ ---------- -----------
1 OCR 2179 MOUNTED
1 DATA 8152 MOUNTED
1 BAK 8152 MOUNTED
2 OCR 2179 MOUNTED
2 DATA 0 DISMOUNTED
2 BAK 0 DISMOUNTED
6 rows selected.
2、在节点 rac2 上修改磁盘组的状态为 mount
在添加了磁盘组后在另一个节点是处于unmount 状态，所以需要在另一个节点将磁盘组设置为 mount 状态。在个节点 rac2 上执行如下操作：
[root@rac2 grid]# su - grid
[grid@rac2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 12 19:56:18 2021
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
---------- ------------------------------ ---------- -----------
1 OCR 2179 MOUNTED
1 DATA 8109 MOUNTED
1 BAK 8109 MOUNTED
2 OCR 2179 MOUNTED
2 DATA 8109 MOUNTED
2 BAK 8109 MOUNTED
6 rows selected.
二、修改 oracle 静默安装响应文件
### 切换到 oracle 用户
[grid@rac1 ~]$ su - oracle
Password:
[oracle@rac1 ~]$ cd /soft/oracle/database/response/
[oracle@rac1 response]$ ls
dbca.rsp db_install.rsp netca.rsp
[oracle@rac1 response]$ vi 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 用户
[oracle@rac1 database]$ pwd
/soft/oracle/database
[oracle@rac1 database]$ ll
total 60
drwxr-xr-x 4 oracle oinstall 4096 Aug 27 2013 install
-rw-r--r-- 1 oracle oinstall 30016 Aug 27 2013 readme.html
drwxr-xr-x 2 oracle oinstall 4096 Apr 19 20:19 response
drwxr-xr-x 2 oracle oinstall 4096 Aug 27 2013 rpm
-rwxr-xr-x 1 oracle oinstall 3267 Aug 27 2013 runInstaller
drwxr-xr-x 2 oracle oinstall 4096 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 /soft/oracle/database/response/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 11207 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4200 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-04-19_08-22-55PM. Please wait ...[oracle@rac1 database]$ You c
an find the log of this install session at: /u01/app/oraInventory/logs/installActions2021-04-19_08-22-55PM.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/silentInstall2021-04-19_08-22-55PM.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.
安装过程中可以查看日志文件：
cat /u01/app/oraInventory/logs/installActions2021-04-19_08-22-55PM.log
2、切换到 root 用户，在 rac1、rac2 执行以下脚本
[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_2021-04-19_20-55-08.log for the output of root script
[root@rac1 ~]# cat /u01/app/oracle/product/11.2.0/db_1/install/root_rac1_2021-04-19_20-55-08.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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.
Finished product-specific root actions.
Finished product-specific root actions.
[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_2021-04-19_20-55-44.log for the output of root script
[root@rac2 ~]# cat /u01/app/oracle/product/11.2.0/db_1/install/root_rac2_2021-04-19_20-55-44.log
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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.
Finished product-specific root actions.
Finished product-specific root actions.
四、查看 grid 集群状态
[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....ER.lsnr ora....er.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 rac1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr 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....C2.lsnr 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
北京人形旗下天工造物具身智能开源社区，聚焦具身天工与慧思开物两大平台
更多推荐
2
0- 0
已为社区贡献5条内容
所有评论(0)