笔记111111111111111111
资源内容介绍
11111111111 # 一、介绍本脚本旨在通过无人值守方式初始化安装Oracle软件。修改版，添加-iso N 不验证挂载盘如需开启大内存页需手动配置### 功能： 1.配置操作系统 2.安装Grid软件 3.安装Oracle软件 4.安装PSU&&RU补丁 5.创建数据库 6.数据库优化### 目前支持：##### ORACLE版本： 11GR2、12CR2、18C、19C。##### 操作系统版本： Linux6(x86_64)、Linux7(x86_64)、Linux8(x86_64)。```##19C 操作系统要求Red Hat Enterprise Linux 8: 4.18.0-80.el8.x86_64 or laterRed Hat Enterprise Linux 7.5: 3.10.0-862.11.6.el7.x86_64 or later```##### 包括Single、Oracle Restart、Oracle Real Cluster模式。<font color='red'>***目前RAC只支持双节点安装。***</font># 二、使用### 2.1 安装准备#### 2.1.1 创建软件目录，例如：/soft`mkdir /soft`#### 2.1.2 挂载镜像 ISO```shell script## 通过cdrom挂载mount /dev/cdrom /mntor##通过安装镜像源挂载mount -o loop /soft/rhel-server-7.9-x86_64-dvd.iso /mnt```#### 2.1.3 上传安装介质和脚本到软件目录#### 2.1.4 设置好主机IP（Public&&Private）```shell script#For Example:##Linux 6vi /etc/sysconfig/network-scripts/ifcfg-eth0IPADDR=10.211.55.100NETMASK=255.255.255.0GATEWAY=10.211.55.1##Linux 7nmcli connection modify eth0 ipv4.addresses 10.211.55.100/24 ipv4.gateway 10.211.55.1 ipv4.method manual autoconnect yes```#### 2.1.5 如果需要安装Rac，需提前配置ASM共享磁盘```##For Example##通过iscsi配置共享盘1.StarWind(Windows)2.Openfiler(Linux)##假设已配置好共享存储服务器，IP为10.211.55.18。##配置iscsi连接共享存储yum install -y iscsi-initiator-utils*##输出targetnameiscsiadm -m discovery -t st -p 10.211.55.18##连接共享存储iscsiadm -m node -T iqn.2008-08.com.starwindsoftware:10.211.55.18-lucifer -p 10.211.55.18 -l```[共享存储之--StarWind高级配置](https://blog.csdn.net/m0_50546016/article/details/116135134)[共享存储之--Openfiler高级配置](https://www.bilibili.com/video/BV1oJ411q7h3?p=2)### 2.2 脚本参数##### 2.2.1 通过运行 `./OracleShellInstall --help` 可以查看参数：```Para-i,--PUBLICIPPUBLICIP NETWORK ADDRESS-n,--HOSTNAMEHOSTNAME(orcl)-rs,--ROOTPASSWDROOT USER PASSWORD(oracle)-gp,--GRIDPASSWDGRID USER PASSWORD(oracle)-op,--ORAPASSWDORACLE USER PASSWORD(oracle)-b,--ENV_BASE_DIRORACLE BASE DIR(/u01/app)-d,--DATAFILE_DIRORACLE DATAFILE DIR(/oradata)-a,--ARCHIVELOG_DIRORACLE ARCHIVELOG DIR(/archivelog)-bk,--BACKUP_DIRORACLE BACKUP DIR(/backup)-o,--ORACLE_SIDORACLE_SID(orcl)-s,--CHARACTERSETORACLE CHARACTERSET(AL32UTF8)-c,--ISCDBIS CDB OR NOT(FALSE)-pb,--PDBNAMEPDBNAME(pdb01)-pb1,--RAC1PUBLICIPRAC NODE ONE PUBLIC IP-pb2,--RAC2PUBLICIPRAC NODE SECONED PUBLIC IP-vi1,--RAC1VIPRAC NODE ONE VIRTUAL IP-vi2,--RAC2VIPRAC NODE SECOND VIRTUAL IP-pi1,--RAC1PRIVIPRAC NODE ONE PRIVATE IP-pi2,--RAC2PRIVIPRAC NODE SECOND PRIVATE IP-pi3,--RAC1PRIVIP1RAC NODE ONE PRIVATE IP-pi4,--RAC2PRIVIP1RAC NODE SECOND PRIVATE IP-puf,--RACPUBLICFCNAME RAC PUBLIC FC NAME-prf,--RACPRIVFCNAMERAC PRIVATE FC NAME-prf1,--RACPRIVFCNAME1RAC PRIVATE FC NAME-si,--RACSCANIPRAC SCAN IP-dn,--ASMDATANAMERAC ASM DATADISKGROUP NAME(DATA)-on,--ASMOCRNAMERAC ASM OCRDISKGROUP NAME(OCR)-dd,--DATA_BASEDISKRAC DATADISK DISKNAME-od,--OCRP_BASEDISKRAC OCRDISK DISKNAME-or,--OCRREDUNRAC OCR REDUNDANCY(EXTERNAL|NORMAL|HIGH)-dr,--DATAREDUNRAC DATA REDUNDANCY(EXTERNAL|NORMAL|HIGH)-ts, --TIMESERVER RAC TIME SERVER IP-txh --TuXingHua Tu Xing Hua Install-udev --UDEV Whether Auto Set UDEV-dns --DNS RAC CONFIGURE DNS(Y|N)-dnss --DNSSERVER RAC CONFIGURE DNSSERVER LOCAL(Y|N)-dnsn --DNSNAME RAC DNSNAME(orcl.com)-dnsi --DNSIP RAC DNS IP-m,--ONLYCONFIGOSONLY CONFIG SYSTEM PARAMETER(Y|N)-g,--ONLYINSTALLGRID ONLY INSTALL GRID SOFTWARE(Y|N)-w,--ONLYINSTALLORACLE ONLY INSTALL ORACLE SOFTWARE(Y|N)-ocd,--ONLYCREATEDB ONLY CREATE DATABASE(Y|N)-gpa,--GRID RELEASE UPDATEGRID RELEASE UPDATE(32072711)-opa,--ORACLE RELEASE UPDATEORACLE RELEASE UPDATE(32072711)```### 2.3 脚本运行<font color=#FF000 >***Notes：必须提前上传所需安装介质，否则安装失败！***</font>___cdb 12C后开始支持容器，只需要加上如下参数即可：___```shellscript-c TRUE `# cdb` \-pb singlepdb `# pdbname` \```<font color=#FF000 >***脚本须Root用户下执行：***</font>`chmod +x OracleShellInstall.sh`#### 2.3.1 Single模式安装```shellscriptcd /soft./OracleShellInstall.sh -i 10.211.55.100 `#Public ip`\-n single `# hostname`\-o nocdb `# oraclesid`\-op oracle `# oracle user password`\-b /oracle/app `# install basedir`\-d /oradata `# datafile dir`\-a /archivelog `#archivelog dir`\-bk /backup `#backup dir`\-s AL32UTF8 `# characterset`\-opa 31537677 `# oracle psu number`\-iso N```./OracleShellInstall.sh -i 10.164.1.232 `#Public ip`\-n CNSZPLORARS01 `# hostname`\-o orcl19c `# oraclesid`\-op User123$ `# oracle user password`\-b /app/u01 `# install basedir`\-d /app/oradata `# datafile dir`\-a /app/archivelog `#archivelog dir`\-bk /app/backup `#backup dir`\-s AL32UTF8 `# characterset`\-opa 34765931 `# oracle psu number`\-iso N ./OracleShellInstall.sh -i 10.164.1.217 `#Public ip`\-n CNSZPLORARS02 `# hostname`\-o orcl19c `# oraclesid`\-op User123$ `# oracle user password`\-b /app/u01 `# install basedir`\-d /app/oradata c`# datafile dir`\-a /app/archivelog `#archivelog dir`\-bk /app/backup `#backup dir`\-s AL32UTF8 `# characterset`\-iso N #### 2.3.2 Oracle Restart模式安装```shellscriptcd /soft./OracleShellInstall.sh -i 10.211.55.100 `#Public ip`\-n restart `# hostname`\-o nocdb `# oraclesid`\-gp oracle `# grid user password`\-op oracle `# oracle user password`\-b /u01/app `# install basedir`\-s AL32UTF8 `# characterset`\-dd /dev/sde,/dev/sdf `# asm data disk`\-dn DATA `# asm data diskgroupname`\-dr EXTERNAL `# asm data redundancy`\-gpa 31718723 `# grid psu number````#### 2.3.3 Oracle Rac模式安装```shellscriptcd /soft./OracleShellInstall.sh -i 10.211.55.100 `#Public ip`\-n rac `# hostname`\-rs oracle `# root password`\-op oracle `# oracle password`\-gp oracle `# grid password`\-b /u01/app `# install basedir`\-o nocdb `# oraclesid`\-s AL32UTF8 `# characterset`\-pb1 10.211.55.100 -pb2 10.211.55.101 `# node public ip`\-vi1 10.211.55.102 -vi2 10.211.55.103 `# node virtual ip`\-pi1 10.10.1.1 -pi2 10.10.1.2 `# node private ip`\-puf eth0 -prf eth1 `# network fcname`\-si 10.211.55.105 `# scan ip`\-dd /dev/sde,/dev/sdf `# asm data disk`\-od /dev/sdb,/dev/sdc,/dev/sdd `# asm ocr disk`\-or EXTERNAL `# asm ocr redundancy`\-dr EXTERNAL `# asm data redundancy`\-on OCR `# asm ocr diskgroupname`\-dn DATA `# asm data diskgroupname`\-gpa 32580003 `# GRID PATCH````## 三. 功能介绍#### 3.1 配置节点间互信RAC模式自动配置节点间互信#### 3.2 配置DNS服务器```-dns Y `# DNS` \-dnss Y `# LOCAL DNSSERVER` \-dnsn lucifer.com `# DNS SERVER NAME` \-dnsi 10.211.55.200 `# DNS SERVER IP` \```#### 3.3 记录安装日志日志记录在软件目录中，格式为：`oracleAllSilent_$(date +"20%y%m%d%H%M%S").log`#### 3.4 可重复执行执行失败支持多次执行安装。#### 3.5 帮助功能`./OracleShellInstall --help`#### 3.6 自动配置Multipath+UDEV绑盘```shellscript-dd /dev/sde,/dev/sdf `# asm data disk`\-od /dev/sdb,/dev/sdc,/dev/sdd `# asm ocr disk`\```#### 3.7 配置时间同步crontab```shellscript-tsi 10.211.55.18 `# timese