admin 管理员组文章数量: 1184232
目录
1、安装准备工作
1.1、配置本地YUM源
1.2、安装rpm依赖包
1.3、创建用户
1.4、配置host表
1.5、禁用NTP
1.6、创建所需要目录
1.7、其它配置：
1.8、关闭防火墙与selinux
1.9、配置环境变量
1.10、配置共享磁盘权限
1.11、配置互信
1.12、在grid安装文件中安装 cvuqdisk
2、开始安装grid
2.1、安装检查
2.2、安装grid脚本
2.3、安装日志
2.4、执行脚本
2.5、安装后检查状态
3、创建ASM磁盘
4、安装数据库软件
4.1、安装数据库软件
3.2、安装日志
5、建立数据库
5.1、创建普通数据库
5.2、创建可插拔数据库
1、安装准备工作
1.1、配置本地YUM源
mount -t auto /dev/cdrom /mnt
rm -rf /etc/yum.repos.d/
mkdir -p /etc/yum.repos.d/
cat >> /etc/yum.repos.d/CentOS-Media.repo<<EOF
# CentOS-Media.repo
#
# This repo can be used with mounted DVD media, verify the mount point for
# CentOS-7. You can use this repo and yum to install items directly off the
# DVD ISO that we release.
#
# To use this repo, put in your DVD and use it with the other repos too:
# yum --enablerepo=c7-media [command]
#
# or for ONLY the media repo, do this:
#
# yum --disablerepo=\* --enablerepo=c7-media [command]
[c7-media]
name=CentOS-$releasever - Media
baseurl=file:///mnt/
gpgcheck=0
enabled=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
EOF
yum clean all
yum makecache1.2、安装rpm依赖包
yum -y install dstat iotop bc gcc gcc-c++ binutils make gdb cmake glibc ksh elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc-devel libaio libaio-devel libXrender libXrender-devel libX11 libXau sysstat libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb net-tools nfs-utils compat-libcap1 compat-libstdc++ smartmontools targetcli python python-configshell python-rtslib python-six unixODBC unixODBC-devel iscsi-initiator-utils
ls -l compat* elfutils* | awk -v rpmpackage="" '{rpmpackage=$NF" "rpmpackage}END{print "yum -y localinstall "rpmpackage}' | bash1.3、创建用户
groupadd -g 11001 oinstall
groupadd -g 11002 dba
groupadd -g 11003 oper
groupadd -g 11004 backupdba
groupadd -g 11005 dgdba
groupadd -g 11006 kmdba
groupadd -g 11007 asmdba
groupadd -g 11008 asmoper
groupadd -g 11009 asmadmin
groupadd -g 11010 racdba
useradd -u 11011 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle
useradd -u 11012 -g oinstall -G asmadmin,asmdba,asmoper,dba grid1.4、配置bond
#!/bin/bash
service NetworkManager stop
chkconfig NetworkManager off
cat >/etc/sysconfig/network-scripts/ifcfg-bond0<<EOF1
BOOTPROTO=static
DEVICE=bond0
IPADDR=192.168.33.10
PREFIX=255.255.255.0
GATEWAY=192.168.33.1
USERCTL=no
ONBOOT=yes
EOF1
cat >/etc/sysconfig/network-scripts/ifcfg-eth0<<EOF2
DEVICE=eth0
PREFIX=24
BOOTPROTO=static
MASTER=bond0
SLAVE=yes
ONBOOT=yes
EOF2
cat >/etc/sysconfig/network-scripts/ifcfg-eth2<<EOF3
DEVICE=eth2
PREFIX=24
BOOTPROTO=static
MASTER=bond0
SLAVE=yes
ONBOOT=yes
EOF3
cat >/etc/sysconfig/network-scripts/ifcfg-bond1<<EOF1
BOOTPROTO=static
DEVICE=bond1
IPADDR=19.21.68.10
PREFIX=255.255.255.0
USERCTL=no
ONBOOT=yes
EOF1
cat >/etc/sysconfig/network-scripts/ifcfg-eth1<<EOF2
DEVICE=eth1
PREFIX=24
BOOTPROTO=static
MASTER=bond1
SLAVE=yes
ONBOOT=yes
EOF2
cat >/etc/sysconfig/network-scripts/ifcfg-eth3<<EOF3
DEVICE=eth3
PREFIX=24
BOOTPROTO=static
MASTER=bond1
SLAVE=yes
ONBOOT=yes
EOF3
#配置bond模式1主备方式
cat >/etc/modprobe.d/bonding.conf<<EOF4
alias bond0 bonding
alias bond1 bonding
options bond0 miimon=100 mode=1 primary=eth0
options bond1 miimon=100 mode=1 primary=eth1
EOF4
echo "ifenslave bond0 eth0 eth2">>/etc/rc.d/rc.local
echo "ifenslave bond1 eth1 eth2">>/etc/rc.d/rc.local
echo "/etc/init.d/network restart">>/etc/rc.d/rc.local
chmod 550 /etc/rc.d/rc.local
chmod 550 /etc/rc.local
reboot
cat /proc/net/bonding/bond0
cat /proc/net/bonding/bond1
bond1配置HAIP
net.ipv4.conf.ens13f1.rp_filter = 2
net.ipv4.conf.ens9f0.rp_filter = 21.5、配置host表
cat >>/etc/hosts<<EOF
192.168.33.21 rac19c1
192.168.33.23 rac19c2
192.168.33.22 rac19c1-vip
192.168.33.24 rac19c2-vip
192.168.33.25 rac19c-scan
19.21.68.21 rac19c1-priv
19.21.68.22 rac19c2-priv
EOF
hostnamectl set-hostname rac19c1
hostnamectl set-hostname rac19c21.6、禁用NTP
systemctl stop ntpd.service
systemctl disable ntpd.service
mv /etc/ntp.conf /etc/ntp.conf.orig1.7、创建所需要目录
mkdir -p /u01/app/19.0.0/grid
mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.0.0/db_1
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/19.0.0/grid
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
mkdir -p /u01/app/oraInventory
chown -R grid:oinstall /u01/app/oraInventory- 1.6、创建所需要目录
1.8、其它配置：
cat>>/etc/security/limits.d/20-nproc.conf<<EOF
* - nproc 16384
EOFcat>>/etc/security/limits.conf<<EOF
# End of file
grid soft nproc 16384
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 4194304
oracle soft memlock 4194304
EOFcat >>/etc/pam.d/login<<EOF
#ORACLE SETTING
session required pam_limits.so
EOFcat>>/etc/sysctl.conf<<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 18446744073692774399
kernel.shmmax = 18446744073692774399
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF
配置HAIP
net.ipv4.conf.ens13f1.rp_filter = 2
net.ipv4.conf.ens9f0.rp_filter = 2停止avahi-daemon服务
systemctl disable avahi-daemon.socket
systemctl disable avahi-daemon.service
ps -ef|grep avahi-daemon
avahi 2674 1 0 18:28 ? 00:00:00 avahi-daemon: running [linux.local]
avahi 2704 2674 0 18:28 ? 00:00:00 avahi-daemon: chroot helper
root 16251 15578 0 18:45 pts/1 00:00:00 grep --color=auto avahi-daemon
[root@rac19c1 ~]# kill -9 2674 2704
[root@rac19c1 ~]# ps -ef|grep avahi-daemon
root 16254 15578 0 18:45 pts/1 00:00:00 grep --color=auto avahi-daemoncat>>/etc/fstab<<EOF
tmpfs /dev/shm tmpfs defaults,size=8G 0 0
EOF
mount -o remount /dev/shm编辑network文件
cat >>/etc/sysconfig/network<<EOF
NOZEROCONF=yes
EOF1.9、关闭防火墙与selinux
systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
sed -i 's/=enforcing/=disabled/g' /etc/selinux/config
setenforce 0
getenforce1.10、配置环境变量
cat>>/home/grid/.bash_profile<<EOF
export PATH
export ORACLE_SID=+ASM1;
export ORACLE_BASE=/u01/app/grid;
export ORACLE_HOME=/u01/app/19.0.0/grid;
export NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS";
export PATH=.:\$PATH:\$HOME/bin:\$ORACLE_HOME/bin
export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF
cat>>/home/oracle/.bash_profile<<EOF
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=\$ORACLE_BASE/product/19.0.0/db_1
export ORACLE_SID=orcl1
export PATH=\$ORACLE_HOME/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin
export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
EOF1.11、配置共享磁盘权限
iscsiadm -m discovery -t sendtargets -p 192.168.33.250:3260
iscsiadm -m node --loginall=all
[root@rac19c1 oracle]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb
360003ff44dc75adc8cec9cce0033f402
[root@rac19c1 oracle]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc
360003ff44dc75adc9ba684d395391bae
[root@rac19c1 oracle]#
无多路径
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="sdb", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$name",RESULT=="33000000035230a3a", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sdc", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$name",RESULT=="330000000da136123", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root@rac19c1 dev]# /sbin/partprobe
[root@rac19c1 oracle]# systemctl restart systemd-udev-trigger.service
[root@rac19c1 dev]# ll |grep asm
brw-rw----. 1 grid asmadmin 8, 16 Mar 18 18:51 sdb
brw-rw----. 1 grid asmadmin 8, 32 Mar 18 18:51 sdc
多路径配置
[root@rac19c1 dev]# vi /etc/multipath.conf
multipaths {
multipath {
wwid 360003ff44dc75adc8cec9cce0033f402
alias crs1
}
multipath {
wwid 360003ff44dc75adc9ba684d395391bae
alias data1
}
}
[root@rac19c2 dev]# cat /etc/udev/rules.d/12-dm-permissions.rules
ENV{DM_NAME}=="crs1",OWNER:="grid",GROUP:="asmadmin",MODE:="660",SYMLINK+="mapper/$env{DM_NAME}"
ENV{DM_NAME}=="data1",OWNER:="grid",GROUP:="asmadmin",MODE:="660",SYMLINK+="mapper/$env{DM_NAME}"
[root@rac19c1 Packages]# systemctl start multipathd.service
[root@rac19c1 Packages]# multipath -ll
crs1 (360003ff44dc75adc8cec9cce0033f402) dm-3 MSFT ,Virtual HD
size=30G features='0' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=1 status=active
`- 1:0:0:0 sdb 8:16 active ready running
data1 (360003ff44dc75adc9ba684d395391bae) dm-4 MSFT ,Virtual HD
size=25G features='0' hwhandler='0' wp=rw
`-+- policy='service-time 0' prio=1 status=active
`- 1:0:0:1 sdc 8:32 active ready running
[root@rac19c2 dev]# /sbin/udevadm trigger --type=devices --action=change
[root@rac19c2 dev]#
[root@rac19c2 dev]#
[root@rac19c2 dev]# ll |grep dm
crw------- 1 root root 10, 61 Mar 27 18:33 cpu_dma_latency
brw-rw---- 1 root disk 253, 0 Mar 27 18:33 dm-0
brw-rw---- 1 root disk 253, 1 Mar 27 18:33 dm-1
brw-rw---- 1 root disk 253, 2 Mar 27 18:33 dm-2
brw-rw---- 1 grid asmadmin 253, 3 Mar 27 18:33 dm-3
brw-rw---- 1 grid asmadmin 253, 4 Mar 27 18:33 dm-4
crw------- 1 root root 1, 12 Mar 27 18:33 oldmem
brw-rw---- 1 grid asmadmin 8, 16 Mar 27 18:33 sdb
brw-rw---- 1 grid asmadmin 8, 32 Mar 27 18:33 sdc1.12、配置互信
grid:
cd /home/grid
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
cat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keys
ssh rac19c2 cat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keys
ssh rac19c2 cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys rac19c2:~/.ssh/authorized_keys
ssh rac19c1 date;ssh rac19c2 date;ssh rac19c1-priv date;ssh rac19c2-priv date
[grid@rac19c1 ~]$ ssh rac19c1 date;ssh rac19c2 date;ssh rac19c1-priv date;ssh rac19c2-priv date
Wed Mar 18 19:27:32 CST 2020
Wed Mar 18 19:27:32 CST 2020
Wed Mar 18 19:27:33 CST 2020
Wed Mar 18 19:27:33 CST 2020
oracle:
cd /home/oracle
mkdir ~/.ssh
chmod 700 ~/.ssh
ssh-keygen -t rsa
ssh-keygen -t dsa
cat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keys
ssh rac19c2 cat ~/.ssh/id_rsa.pub >>~/.ssh/authorized_keys
ssh rac19c2 cat ~/.ssh/id_dsa.pub >>~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys rac19c2:~/.ssh/authorized_keys
ssh rac19c1 date;ssh rac19c2 date;ssh rac19c1-priv date;ssh rac19c2-priv date
[oracle@rac19c1 ~]$ ssh rac19c1 date;ssh rac19c2 date;ssh rac19c1-priv date;ssh rac19c2-priv date
Wed Mar 18 19:33:45 CST 2020
Wed Mar 18 19:33:45 CST 2020
Wed Mar 18 19:33:45 CST 2020
Wed Mar 18 19:33:45 CST 2020
1.13、在grid安装文件中安装 cvuqdisk
rpm -ivh /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
2、开始安装grid
2.1、安装检查
./runcluvfy.sh stage -pre crsinst -n rac19c1,rac19c2 -verbose >/home/grid/grid_check.log
cat /home/grid/grid_check.log
/etc/resolv.conf 报错可以忽略2.2、安装grid脚本
${ORACLE_HOME}/gridSetup.sh -ignorePrereq -waitforcompletion -silent \
-responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
oracle.install.option=CRS_CONFIG \
ORACLE_BASE=/u01/app/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSASM=asmadmin \
oracle.install.asm.OSOPER=asmoper \
oracle.install.crs.config.scanType=LOCAL_SCAN \
oracle.install.crs.config.gpnp.scanName=rac19c-scan \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.ClusterConfiguration=STANDALONE \
oracle.install.crs.config.configureAsExtendedCluster=false \
oracle.install.crs.config.clusterName=ora19c-cluster \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.crs.config.clusterNodes=rac19c1:rac19c1-vip,rac19c2:rac19c2-vip \
oracle.install.crs.configworkInterfaceList=ens33:192.168.33.0:1,ens37:19.21.68.0:5 \
oracle.install.asm.configureGIMRDataDG=false \
oracle.install.crs.config.useIPMI=false \
oracle.install.asm.storageOption=ASM \
oracle.install.asmOnNAS.configureGIMRDataDG=false \
oracle.install.asm.SYSASMPassword=Oracle_2019 \
oracle.install.asm.diskGroup.name=OCRDG \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.install.asm.diskGroup.AUSize=4 \
oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/sdb \
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/* \
oracle.install.asm.configureAFD=false \
oracle.install.asm.monitorPassword=Oracle_2019 \
oracle.install.crs.configureRHPS=false \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.config.managementOption=NONE \
oracle.install.config.omsPort=0 \
oracle.install.crs.rootconfig.executeRootScript=false \
2.3、安装日志
[grid@rac19c1 ~]$ ${ORACLE_HOME}/gridSetup.sh -ignorePrereq -waitforcompletion -silent \
> -responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> SELECTED_LANGUAGES=en,en_GB \
> oracle.install.option=CRS_CONFIG \
> ORACLE_BASE=/u01/app/grid \
> oracle.install.asm.OSDBA=asmdba \
> oracle.install.asm.OSASM=asmadmin \
> oracle.install.asm.OSOPER=asmoper \
> oracle.install.crs.config.scanType=LOCAL_SCAN \
> oracle.install.crs.config.gpnp.scanName=rac19c-scan \
> oracle.install.crs.config.gpnp.scanPort=1521 \
> oracle.install.crs.config.ClusterConfiguration=STANDALONE \
> oracle.install.crs.config.configureAsExtendedCluster=false \
> oracle.install.crs.config.clusterName=ora19c-cluster \
> oracle.install.crs.config.gpnp.configureGNS=false \
> oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
> oracle.install.crs.config.clusterNodes=rac19c1:rac19c1-vip,rac19c2:rac19c2-vip \
> oracle.install.crs.configworkInterfaceList=ens33:192.168.33.0:1,ens37:19.21.68.0:5 \
> oracle.install.asm.configureGIMRDataDG=false \
> oracle.install.crs.config.useIPMI=false \
> oracle.install.asm.storageOption=ASM \
> oracle.install.asmOnNAS.configureGIMRDataDG=false \
> oracle.install.asm.SYSASMPassword=Oracle_2019 \
> oracle.install.asm.diskGroup.name=OCRDG \
> oracle.install.asm.diskGroup.redundancy=EXTERNAL \
> oracle.install.asm.diskGroup.AUSize=4 \
> oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/sdb \
> oracle.install.asm.diskGroup.diskDiscoveryString=/dev/* \
> oracle.install.asm.configureAFD=false \
> oracle.install.asm.monitorPassword=Oracle_2019 \
> oracle.install.crs.configureRHPS=false \
> oracle.install.crs.config.ignoreDownNodes=false \
> oracle.install.config.managementOption=NONE \
> oracle.install.config.omsPort=0 \
> oracle.install.crs.rootconfig.executeRootScript=false \
>
Launching Oracle Grid Infrastructure Setup Wizard...
[WARNING] [INS-40109] The specified Oracle Base location is not empty on this server.
ACTION: Specify an empty location for Oracle Base.
[WARNING] [INS-32047] The location (/u01/app/oraInventory) specified for the central inventory is not empty.
ACTION: It is recommended to provide an empty location for the inventory.
[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /tmp/GridSetupActions2020-04-23_06-35-19AM/gridSetupActions2020-04-23_06-35-19AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /tmp/GridSetupActions2020-04-23_06-35-19AM/gridSetupActions2020-04-23_06-35-19AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/app/19.0.0/grid/install/response/grid_2020-04-23_06-35-19AM.rsp
You can find the log of this install session at:
/tmp/GridSetupActions2020-04-23_06-35-19AM/gridSetupActions2020-04-23_06-35-19AM.log
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/19.0.0/grid/root.sh
Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
[rac19c1, rac19c2]
Execute /u01/app/19.0.0/grid/root.sh on the following nodes:
[rac19c1, rac19c2]
Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.
Successfully Setup Software with warning(s).
As install user, execute the following command to complete the configuration.
/u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -responseFile /u01/app/19.0.0/grid/install/response/gridsetup.rsp [-silent]
Moved the install session logs to:
/u01/app/oraInventory/logs/GridSetupActions2020-04-23_06-35-19AM
2.4、执行脚本
按上面提示分别在[rac19c1, rac19c2]以rott账户执行
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/19.0.0/grid/root.sh
执行完成后
再以grid账户在一号机执行
/u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -silent \
-responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
oracle.install.option=CRS_CONFIG \
ORACLE_BASE=/u01/app/grid \
oracle.install.asm.OSDBA=asmdba \
oracle.install.asm.OSASM=asmadmin \
oracle.install.asm.OSOPER=asmoper \
oracle.install.crs.config.scanType=LOCAL_SCAN \
oracle.install.crs.config.gpnp.scanName=rac19c-scan \
oracle.install.crs.config.gpnp.scanPort=1521 \
oracle.install.crs.config.ClusterConfiguration=STANDALONE \
oracle.install.crs.config.configureAsExtendedCluster=false \
oracle.install.crs.config.clusterName=ora19c-cluster \
oracle.install.crs.config.gpnp.configureGNS=false \
oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
oracle.install.crs.config.clusterNodes=rac19c1:rac19c1-vip,rac19c2:rac19c2-vip \
oracle.install.crs.configworkInterfaceList=ens33:192.168.33.0:1,ens37:19.21.68.0:5 \
oracle.install.asm.configureGIMRDataDG=false \
oracle.install.crs.config.useIPMI=false \
oracle.install.asm.storageOption=ASM \
oracle.install.asmOnNAS.configureGIMRDataDG=false \
oracle.install.asm.SYSASMPassword=Oracle_2019 \
oracle.install.asm.diskGroup.name=OCRDG \
oracle.install.asm.diskGroup.redundancy=EXTERNAL \
oracle.install.asm.diskGroup.AUSize=4 \
oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/sdb \
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/* \
oracle.install.asm.configureAFD=false \
oracle.install.asm.monitorPassword=Oracle_2019 \
oracle.install.crs.configureRHPS=false \
oracle.install.crs.config.ignoreDownNodes=false \
oracle.install.config.managementOption=NONE \
oracle.install.config.omsPort=0 \
oracle.install.crs.rootconfig.executeRootScript=false \
[grid@rac19c1 ~]$ /u01/app/19.0.0/grid/gridSetup.sh -executeConfigTools -silent \
> -responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> SELECTED_LANGUAGES=en,en_GB \
> oracle.install.option=CRS_CONFIG \
> ORACLE_BASE=/u01/app/grid \
> oracle.install.asm.OSDBA=asmdba \
> oracle.install.asm.OSASM=asmadmin \
> oracle.install.asm.OSOPER=asmoper \
> oracle.install.crs.config.scanType=LOCAL_SCAN \
> oracle.install.crs.config.gpnp.scanName=rac19c-scan \
> oracle.install.crs.config.gpnp.scanPort=1521 \
> oracle.install.crs.config.ClusterConfiguration=STANDALONE \
> oracle.install.crs.config.configureAsExtendedCluster=false \
> oracle.install.crs.config.clusterName=ora19c-cluster \
> oracle.install.crs.config.gpnp.configureGNS=false \
> oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
> oracle.install.crs.config.clusterNodes=rac19c1:rac19c1-vip,rac19c2:rac19c2-vip \
> oracle.install.crs.configworkInterfaceList=ens33:192.168.33.0:1,ens37:19.21.68.0:5 \
> oracle.install.asm.configureGIMRDataDG=false \
> oracle.install.crs.config.useIPMI=false \
> oracle.install.asm.storageOption=ASM \
> oracle.install.asmOnNAS.configureGIMRDataDG=false \
> oracle.install.asm.SYSASMPassword=Oracle_2019 \
> oracle.install.asm.diskGroup.name=OCRDG \
> oracle.install.asm.diskGroup.redundancy=EXTERNAL \
> oracle.install.asm.diskGroup.AUSize=4 \
> oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/sdb \
> oracle.install.asm.diskGroup.diskDiscoveryString=/dev/* \
> oracle.install.asm.configureAFD=false \
> oracle.install.asm.monitorPassword=Oracle_2019 \
> oracle.install.crs.configureRHPS=false \
> oracle.install.crs.config.ignoreDownNodes=false \
> oracle.install.config.managementOption=NONE \
> oracle.install.config.omsPort=0 \
> oracle.install.crs.rootconfig.executeRootScript=false \
>
Launching Oracle Grid Infrastructure Setup Wizard...
You can find the logs of this session at:
/u01/app/oraInventory/logs/GridSetupActions2020-04-23_06-53-18AM
You can find the log of this install session at:
/u01/app/oraInventory/logs/UpdateNodeList2020-04-23_06-53-18AM.log
Configuration failed.
[WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped.
ACTION: Refer to the logs or contact Oracle Support Services.
2.5、安装后检查状态
[grid@rac19c1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.chad
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora1work
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.ons
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac19c1 STABLE
ora.OCRDG.dg(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac19c1 Started,STABLE
2 ONLINE ONLINE rac19c2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac19c1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac19c1 STABLE
ora.rac19c1.vip
1 ONLINE ONLINE rac19c1 STABLE
ora.rac19c2.vip
1 ONLINE ONLINE rac19c2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac19c1 STABLE
--------------------------------------------------------------------------------3、创建ASM磁盘
CREATE DISKGROUP DATADG external REDUNDANCY disk '/dev/sdc' ATTRIBUTE 'au_size'='1M', 'compatible.asm' = '19.2';
[grid@rac19c1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 23 07:12:39 2020
Version 19.2.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0
SQL> CREATE DISKGROUP DATADG external REDUNDANCY disk '/dev/sdc' ATTRIBUTE 'au_size'='1M', 'compatible.asm' = '19.2';
Diskgroup created.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0
[grid@rac19c1 ~]$ asmcmd
lsdg
ASMCMD> State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 1048576 28672 28618 0 28618 0 N DATADG/
MOUNTED EXTERN N 512 512 4096 4194304 8192 7856 0 7856 0 Y OCRDG/
ASMCMD>
[root@rac19c2 ~]# su - grid
Last login: Thu Apr 23 07:13:31 CST 2020 on pts/1
[grid@rac19c2 ~]$ asmcmd
lsdg
ASMCMD> State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 4194304 8192 7856 0 7856 0 Y OCRDG/
ASMCMD> exit
[grid@rac19c2 ~]$ sqlplus / as sysasm
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 23 07:14:20 2020
Version 19.2.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0
SQL> alter diskgroup datadg mount;
Diskgroup altered.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0
[grid@rac19c2 ~]$ asmcmd
lsdg
ASMCMD> State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 512 512 4096 1048576 28672 28574 0 28574 0 N DATADG/
MOUNTED EXTERN N 512 512 4096 4194304 8192 7856 0 7856 0 Y OCRDG/
ASMCMD>
[grid@rac19c2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.chad
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora1work
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
ora.ons
ONLINE ONLINE rac19c1 STABLE
ONLINE ONLINE rac19c2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATADG.dg(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac19c1 STABLE
ora.OCRDG.dg(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac19c1 Started,STABLE
2 ONLINE ONLINE rac19c2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac19c1 STABLE
2 ONLINE ONLINE rac19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac19c1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac19c1 STABLE
ora.rac19c1.vip
1 ONLINE ONLINE rac19c1 STABLE
ora.rac19c2.vip
1 ONLINE ONLINE rac19c2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac19c1 STABLE
--------------------------------------------------------------------------------
[grid@rac19c2 ~]$ 4、安装数据库软件
4.1、安装数据库软件
.
./runInstaller -ignorePrereq -waitforcompletion -silent \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
oracle.install.option=INSTALL_DB_SWONLY \
UNIX_GROUP_NAME=oinstall \
INVENTORY_LOCATION=/u01/app/oraInventory \
SELECTED_LANGUAGES=en,en_GB \
ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 \
ORACLE_BASE=/u01/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.OSDBA_GROUP=dba \
oracle.install.db.OSOPER_GROUP=oper \
oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
oracle.install.db.OSDGDBA_GROUP=dgdba \
oracle.install.db.OSKMDBA_GROUP=kmdba \
oracle.install.db.OSRACDBA_GROUP=racdba\
oracle.install.db.CLUSTER_NODES=rac19c1,rac19c2 \
oracle.install.db.isRACOneInstall=false \
oracle.install.db.rac.serverpoolCardinality=0 \
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
oracle.install.db.ConfigureAsContainerDB=false \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
DECLINE_SECURITY_UPDATES=true \
3.2、安装日志
[oracle@rac19c1 db_1]$ pwd
/u01/app/oracle/product/19.0.0/db_1
[oracle@rac19c1 db_1]$ ./runInstaller -ignorePrereq -waitforcompletion -silent \
> -responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
> oracle.install.option=INSTALL_DB_SWONLY \
> UNIX_GROUP_NAME=oinstall \
> INVENTORY_LOCATION=/u01/app/oraInventory \
> SELECTED_LANGUAGES=en,en_GB \
> ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1 \
> ORACLE_BASE=/u01/app/oracle \
> oracle.install.db.InstallEdition=EE \
> oracle.install.db.OSDBA_GROUP=dba \
> oracle.install.db.OSOPER_GROUP=oper \
> oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
> oracle.install.db.OSDGDBA_GROUP=dgdba \
> oracle.install.db.OSKMDBA_GROUP=kmdba \
> oracle.install.db.OSRACDBA_GROUP=racdba\
> oracle.install.db.CLUSTER_NODES=rac19c1,rac19c2 \
> oracle.install.db.isRACOneInstall=false \
> oracle.install.db.rac.serverpoolCardinality=0 \
> oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
> oracle.install.db.ConfigureAsContainerDB=false \
> SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
> DECLINE_SECURITY_UPDATES=true \
>
Launching Oracle Database Setup Wizard...
[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2020-04-23_07-05-49AM/installActions2020-04-23_07-05-49AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2020-04-23_07-05-49AM/installActions2020-04-23_07-05-49AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/app/oracle/product/19.0.0/db_1/install/response/db_2020-04-23_07-05-49AM.rsp
You can find the log of this install session at:
/u01/app/oraInventory/logs/InstallActions2020-04-23_07-05-49AM/installActions2020-04-23_07-05-49AM.log
As a root user, execute the following script(s):
1. /u01/app/oracle/product/19.0.0/db_1/root.sh
Execute /u01/app/oracle/product/19.0.0/db_1/root.sh on the following nodes:
[rac19c1, rac19c2]
Successfully Setup Software with warning(s).
[root@rac19c1 ~]# sh /u01/app/oracle/product/19.0.0/db_1/root.sh
Check /u01/app/oracle/product/19.0.0/db_1/install/root_rac19c1_2020-04-23_07-16-06-305950040.log for the output of root script
[root@rac19c2 ~]# sh /u01/app/oracle/product/19.0.0/db_1/root.sh
Check /u01/app/oracle/product/19.0.0/db_1/install/root_rac19c2_2020-04-23_07-16-18-045049217.log for the output of root script
[root@rac19c2 ~]# 5、建立数据库
5.1、创建普通数据库
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname orcl -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword Oracle_2019 \
-systemPassword Oracle_2019 \
-createAsContainerDatabase false \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 4024 \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs \
-nodelist rac19c1,rac19c2 \
-storageType ASM \
-diskGroupName +DATADG \
-asmsnmpPassword Oracle_2019 \
-recoveryAreaDestination NONE \
日志
[oracle@rac19c1 db_1]$ dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -gdbname orcl -responseFile NO_VALUE \
> -characterSet AL32UTF8 \
> -sysPassword Oracle_2019 \
> -systemPassword Oracle_2019 \
> -createAsContainerDatabase false \
> -databaseType MULTIPURPOSE \
> -automaticMemoryManagement false \
> -totalMemory 4024 \
> -redoLogFileSize 50 \
> -emConfiguration NONE \
> -ignorePreReqs \
> -nodelist rac19c1,rac19c2 \
> -storageType ASM \
> -diskGroupName +DATADG \
> -asmsnmpPassword Oracle_2019 \
> -recoveryAreaDestination NONE \
>
Prepare for db operation
8% complete
Copying database files
33% complete
Creating and starting Oracle instance
34% complete
35% complete
39% complete
42% complete
45% complete
50% complete
Creating cluster database views
52% complete
67% complete
Completing Database Creation
71% complete
73% complete
75% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/orcl.
Database Information:
Global Database Name:orcl
System Identifier(SID) Prefix:orcl
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.5.2、创建可插拔数据库
dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname oracl -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword Oracle_2019 \
-systemPassword Oracle_2019 \
-createAsContainerDatabase true \
-numberOfPDBs 1 \
-pdbName orclpdb \
-pdbAdminPassword Oracle_2019 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 1024 \
-redoLogFileSize 50 \
-emConfiguration NONE \
-ignorePreReqs \
-nodelist rac19c1,rac19c2 \
-storageType ASM \
-diskGroupName +DATADG \
-asmsnmpPassword Oracle_2019 \
-recoveryAreaDestination NONE \
日志
[oracle@rac19c2 ~]$ dbca -silent -createDatabase \
> -templateName General_Purpose.dbc \
> -gdbname oracl -responseFile NO_VALUE \
> -characterSet AL32UTF8 \
> -sysPassword Oracle_2019 \
> -systemPassword Oracle_2019 \
> -createAsContainerDatabase true \
> -numberOfPDBs 1 \
> -pdbName orclpdb \
> -pdbAdminPassword Oracle_2019 \
> -databaseType MULTIPURPOSE \
> -automaticMemoryManagement false \
> -totalMemory 1024 \
> -redoLogFileSize 50 \
> -emConfiguration NONE \
> -ignorePreReqs \
> -nodelist rac19c1,rac19c2 \
> -storageType ASM \
> -diskGroupName +DATADG \
> -asmsnmpPassword Oracle_2019 \
> -recoveryAreaDestination NONE \
>
Prepare for db operation
7% complete
Copying database files
27% complete
Creating and starting Oracle instance
28% complete
31% complete
35% complete
37% complete
40% complete
Creating cluster database views
41% complete
53% complete
Completing Database Creation
57% complete
59% complete
60% complete
Creating Pluggable Databases
64% complete
80% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/oracl.
Database Information:
Global Database Name:oracl
System Identifier(SID) Prefix:oracl
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oracl/oracl.log" for further details.
[oracle@rac19c2 ~]$ dbca -silent -deleteDatabase -sourceDB oracl
[oracle@rac19c2 ~]$ dbca -silent -deleteDatabase -sourceDB oracl
Enter SYS user password:
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
39% complete
42% complete
45% complete
48% complete
52% complete
55% complete
58% complete
65% complete
Updating network configuration files
68% complete
Deleting instances and datafiles
77% complete
87% complete
97% complete
100% complete
Database deletion completed.
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/oracl/oracl0.log" for further details.
[oracle@rac19c2 ~]$
本文标签： RAC Oracle install silent
版权声明：本文标题：Oracle 19c RAC for Centos7.6 静默安装(silent install) 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.roclinux.cn/b/1766221918a3445337.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论