20211119_一键安装Oracle 21C RAC_1731秒完成

原创惠星星云和恩墨技术服务团队 2021-11-19

4850

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]
复制