1. 目标说明
本文档旨在帮助Oracle管理及维护人员标准、高效安装Oracle 11G/19C/21C 数据库，实现单机/RAC集群/standalone一键安装。
2. 软件目录规划
创建软件包目录并上传Oracle安装文件
[root@ora11g ~]# mkdir -p /soft
[root@snyxdb1 ~]# tree /soft
/soft
|-- LINUX.X64_193000_db_home.zip
|-- LINUX.X64_193000_grid_home.zip
|-- LINUX.X64_213000_db_home.zip
|-- LINUX.X64_213000_grid_home.zip
|-- p13390677_112040_Linux-x86-64_1of7.zip
|-- p13390677_112040_Linux-x86-64_2of7.zip
|-- p13390677_112040_Linux-x86-64_3of7.zip
`-- x_onekey.sh
3. 安装说明
[root@snyxdb1 soft]# sh x_onekey.sh
##################################################################################################################
# Author/Wechat : xidoublestar #
# Version : 0.2 #
# Function : Oracle 11g/19c/21c(Single/Standalone/Rac) install on Linux 7/8 #
##################################################################################################################
NOTE: we can use this tool to install Oracle DataBase 11G/19C/21C onekey
**************** if you need any support,contact my wechat: xidoublestar ********************
number: 0
error: command not format
Usage:
x_onekey [-options=<value>]
Where options include:
-dt
database type: oracle/gaussdb/opengauss/pg/mysql
-op
operation type: install/upgrade/patch/check
-ht
ha type: single/rac/restart(single gi)
-v
version: 11G/19C/21C
-i
Public ip
-n
hostname: will aoto add "db" for single/ha,add "db1/db2"for rac
-rp
root password: Oracle rac install need
-dp
db password for os and db level: os(oracle/grid ) db(SYS/SYSTEM/SYSMAN/DBSNMP),can change later,only need for install
-o
oracle_sid
-cdb
whether user cdb or not: true/false
-pdbname
-cs
characterset: ZHS16GBK/AL32UTF8
-ncs
NCHARACTERSET: AL16UTF16/UTF8
-yum
yum location: /dev/cdrom or /tmp/yum.iso
-pu1 <public_ip_node1> -pu2 <public_ip_node2>
public ip for node1/node2
-vip1 <vip_node1> -vip2 <vip_node2>
virtual ip
-pr1 <private_ip_node1> -pr2 <private_ip_node2>
private ip
-scan <scan_ip>
scan ip
-puf <ifname_public> -prf <ifname_private>
network fcname
-or <HIGH/NORMAL/EXTERNAL>
asm ocr redundancy: HIGH/NORMAL/EXTERNAL
-od <[/dev/sd?,]*>
asm ocr disk
-dr <HIGH/NORMAL/EXTERNAL>
asm data redundancy: HIGH/NORMAL/EXTERNAL
-dd <[/dev/sd?,]*>
asm data disk
example 1. install Oracle single(12 params):
sh x_onekey.sh -dt=oracle \
-op=install \
-ht=single `#type: single/rac/ha` \
-v=11G `# version: 11G/19C/21C` \
-i=192.168.1.115 `#Public ip` \
-n=orcl `# hostname: will aotu add "db" for single/ha,add "db1/db2"for rac` \
-dp=Enmo_1234 `# db password: os: oracle/grid db: SYS/SYSTEM/SYSMAN/DBSNMP ` \
-o=orcl `# oraclesid` \
-cdb=false `# createAsContainerDatabase: true/false` \
-pdbname=pdb \
-cs=ZHS16GBK `# characterset: ZHS16GBK/AL32UTF8 ` \
-ncs=AL16UTF16 `# NCHARACTERSET: AL16UTF16/UTF8 ` \
-yum=/dev/cdrom `# yum location: /dev/cdrom or /tmp/yum.iso`
example 2. install Oracle rac(26 params):
sh x_onekey.sh -dt=oracle \
-op=install \
-ht=rac `#type: single/rac/ha` \
-v=11G `# version: 11G/19C/21C` \
-i=192.168.1.115 `#Public ip` \
-n=enmo `# hostname: will aotu add "db" for single/ha,add "db1/db2"for rac` \
-rp=123456 `# root password` \
-dp=Enmo_1234 `# db password: os: oracle/grid db: SYS/SYSTEM/SYSMAN/DBSNMP ` \
-o=orcl `# oraclesid` \
-cdb=false `# createAsContainerDatabase: true/false` \
-cs=ZHS16GBK `# characterset: ZHS16GBK/AL32UTF8 ` \
-ncs=AL16UTF16 `# NCHARACTERSET: AL16UTF16/UTF8 ` \
-yum=/dev/cdrom `# yum location: /dev/cdrom or /tmp/yum.iso` \
-pu1=192.168.1.115 -pu2=192.168.1.117 `#public ip` \
-vi1=192.168.1.116 -vi2=192.168.1.118 `#virtual ip` \
-pr1=10.10.1.115 -pr2=10.10.1.117 `#private ip` \
-si=192.168.1.120 `# scan ip` \
-puf=eth0 -prf=eth1 `# network fcname` \
-or=EXTERNAL `# asm ocr redundancy: HIGH/NORMAL/EXTERNAL` \
-od=/dev/sdb,/dev/sdc,/dev/sdd `# asm ocr disk` \
-dr=EXTERNAL `# asm data redundancy: HIGH/NORMAL/EXTERNAL` \
-dd=/dev/sde,/dev/sdf `# asm data disk`
[root@snyxdb1 soft]#
4. Oracle 21C RAC安装过程
cd /soft
chmod a+x x_onekey.sh
sh x_onekey.sh -dt=oracle \
-op=install \
-ht=rac `#type: single/rac/ha` \
-v=11G `# version: 11G/19C/21C` \
-i=192.168.1.115 `#Public ip` \
-n=enmo `# hostname: will aotu add "db" for single/ha,add "db1/db2"for rac` \
-rp=123456 `# root password` \
-dp=Enmo_1234 `# db password: os: oracle/grid db: SYS/SYSTEM/SYSMAN/DBSNMP ` \
-o=orcl `# oraclesid` \
-cdb=false `# createAsContainerDatabase: true/false` \
-cs=ZHS16GBK `# characterset: ZHS16GBK/AL32UTF8 ` \
-ncs=AL16UTF16 `# NCHARACTERSET: AL16UTF16/UTF8 ` \
-yum=/dev/cdrom `# yum location: /dev/cdrom or /tmp/yum.iso` \
-pu1=192.168.1.115 -pu2=192.168.1.117 `#public ip` \
-vi1=192.168.1.116 -vi2=192.168.1.118 `#virtual ip` \
-pr1=10.10.1.115 -pr2=10.10.1.117 `#private ip` \
-si=192.168.1.120 `# scan ip` \
-puf=eth0 -prf=eth1 `# network fcname` \
-or=EXTERNAL `# asm ocr redundancy: HIGH/NORMAL/EXTERNAL` \
-od=/dev/sdb,/dev/sdc,/dev/sdd `# asm ocr disk` \
-dr=EXTERNAL `# asm data redundancy: HIGH/NORMAL/EXTERNAL` \
-dd=/dev/sde,/dev/sdf `# asm data disk`
******* 19.db check ********
******* 19.1 check db instance
SQL*Plus: Release 21.0.0.0.0 - Production on Fri Nov 19 20:40:32 2021
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
SQL>
INSTANCE_NAME STATUS
---------------- ------------
orcl2 OPEN
orcl1 OPEN
SQL>
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ENMO READ WRITE NO
SQL>
LSNRCTL for Linux: Version 21.0.0.0.0 - Production on 19-NOV-2021 20:40:32
Copyright (c) 1991, 2021, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 21.0.0.0.0 - Production
Start Date 19-NOV-2021 20:23:37
Uptime 0 days 0 hr. 16 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/21.3.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/snyxdb1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.115)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.116)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA01" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR_VOT" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "c8209f27c6b16005e053362ee80ae60e" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "d12493753c5c6966e0537301a8c024b8" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "enmo" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
SQL> Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
******* 19.2 check HugePage info
AnonHugePages: 0 kB
HugePages_Total: 3064
HugePages_Free: 511
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
************** complete install Oracle db 21.3.0 on Linux 7.x *********************
************** if you need any support,contact my wechat: xidoublestar *************
db install used: 1731 seconds
[root@racdb1 soft]# su - grid
Last login: Fri Nov 19 20:38:36 CST 2021
[grid@snyxdb1 ~]$
[grid@snyxdb1 ~]$
5. 集群信息检查
[grid@snyxdb1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE snyxdb1 STABLE
ONLINE ONLINE snyxdb2 STABLE
ora.chad
ONLINE ONLINE snyxdb1 STABLE
ONLINE ONLINE snyxdb2 STABLE
ora.net1.network
ONLINE ONLINE snyxdb1 STABLE
ONLINE ONLINE snyxdb2 STABLE
ora.ons
ONLINE ONLINE snyxdb1 STABLE
ONLINE ONLINE snyxdb2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE snyxdb1 STABLE
2 ONLINE ONLINE snyxdb2 STABLE
ora.DATA01.dg(ora.asmgroup)
1 ONLINE ONLINE snyxdb1 STABLE
2 ONLINE ONLINE snyxdb2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE snyxdb1 STABLE
ora.OCR_VOT.dg(ora.asmgroup)
1 ONLINE ONLINE snyxdb1 STABLE
2 ONLINE ONLINE snyxdb2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE snyxdb1 Started,STABLE
2 ONLINE ONLINE snyxdb2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE snyxdb1 STABLE
2 ONLINE ONLINE snyxdb2 STABLE
ora.cdp1.cdp
1 ONLINE ONLINE snyxdb1 STABLE
ora.cvu
1 ONLINE ONLINE snyxdb1 STABLE
ora.orcl.db
1 ONLINE ONLINE snyxdb1 Open,HOME=/u01/app/o
racle/product/21.3.0
/dbhome_1,STABLE
2 ONLINE ONLINE snyxdb2 Open,HOME=/u01/app/o
racle/product/21.3.0
/dbhome_1,STABLE
ora.orcl.enmo.pdb
1 ONLINE ONLINE snyxdb1 STABLE
2 ONLINE ONLINE snyxdb2 STABLE
ora.qosmserver
1 ONLINE ONLINE snyxdb1 STABLE
ora.scan1.vip
1 ONLINE ONLINE snyxdb1 STABLE
ora.snyxdb1.vip
1 ONLINE ONLINE snyxdb1 STABLE
ora.snyxdb2.vip
1 ONLINE ONLINE snyxdb2 STABLE
--------------------------------------------------------------------------------
[grid@snyxdb1 ~]$
[grid@snyxdb1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [21.0.0.0.0]
[grid@snyxdb1 ~]$ crsctl query crs softwareversion -all
Oracle Clusterware version on node [snyxdb1] is [21.0.0.0.0]
Oracle Clusterware version on node [snyxdb2] is [21.0.0.0.0]
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
