@clisdodo 2019-11-19T10:44:40.000000Z 字数 15829 阅读 2584

Oracle 12cR2 SI ASM UDEV方式图形化搭建（OEL 7.7）

OEL7.7 12cR2 SingleInstance ASM

AskScuti ：搭建类 2-0-1 Oracle 12cR2 单实例ASM采用UDEV方式图形化搭建

Oracle 12cR2 SI ASM UDEV方式图形化搭建（OEL 7.7）
你要知道的
1 操作系统安装
2 相关环境配置
- 2.1 磁盘分区及格式化
- 2.2 主机环境设置
3 ASM 磁盘配置
4 数据库软件安装
5 创建并启动监听
6 GI 软件安装
7 ASM 磁盘组创建
8 数据库创建

你要知道的

如果Linux操作系统的安装对您来说操作困难，请先移至 0级搭建类
如果在Linux操作系统上安装Oracle（图形、静默）对您来说操作困难，请先移至 1级搭建类
如果上述对您来说可以轻松应对，请跟随文档继续部署，2级搭建类将是您未来面对集群RAC（Real Application Cluster）环境的基础
为ASM配置设备持久化请参阅在线官文 Configuring Device Persistence Manually for Oracle ASM

另外您需要了解：Oracle标准版本的RAC环境中 ASM 为强制使用；Oracle 企业版本的RAC环境中，您可以选择其他替代存储。

1 操作系统安装

Linux操作系统安装您可参考 0级搭建类 相关文档，示例环境为 OEL7.7

2 相关环境配置

2.1 磁盘分区及格式化

[root@asmsi12c ~]# fdisk -l |grep "32.2 GB"
Disk /dev/sdb: 32.2 GB, 32212254720 bytes, 62914560 sectors
[root@asmsi12c ~]# fdisk -l |grep "1073 MB"
Disk /dev/sdc: 1073 MB, 1073741824 bytes, 2097152 sectors
Disk /dev/sdd: 1073 MB, 1073741824 bytes, 2097152 sectors
Disk /dev/sde: 1073 MB, 1073741824 bytes, 2097152 sectors
[root@asmsi12c ~]# fdisk -l |grep "214.7 GB"
Disk /dev/sdf: 214.7 GB, 214748364800 bytes, 419430400 sectors
Disk /dev/sdg: 214.7 GB, 214748364800 bytes, 419430400 sectors
[root@asmsi12c ~]# fdisk -l |grep "107.4 GB"
Disk /dev/sdh: 107.4 GB, 107374182400 bytes, 209715200 sectors
[root@asmsi12c ~]# fdisk -l |grep "536.9 GB"
Disk /dev/sdi: 536.9 GB, 536870912000 bytes, 1048576000 sectors

规划（你需要知道，这是实验测试环境，网络、存储等具体规划请结合实际业务场景进行）

/dev/sdb: 32.2 GB --> Oracle Software
/dev/sdc: 1073 MB --> OCR1
/dev/sdd: 1073 MB --> OCR2
/dev/sde: 1073 MB --> OCR3
/dev/sdf: 214.7 GB --> Data1
/dev/sdg: 214.7 GB --> Data2
/dev/sdh: 107.4 GB --> Archived
/dev/sdi: 536.9 GB --> Backup

分区（专盘专用，对所有磁盘进行分区）

02行：分区命令
11行：添加分区 n
15行：默认主分区回车
17行：默认第一个分区号回车
18行：默认第一扇区值回车
20行：专盘专用（直接回车将使用所有空间），您也可以 +10G +1024M +1024K 等操作
24行：保存并退出 w

# 为方便理解，将贴出针对磁盘 /dev/sdb 的具体分区操作信息
[root@asmsi12c ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x91c3f3dd.
Command (m for help): n
Partition type:
   p   primary (0 primary, 0 extended, 4 free)
   e   extended
Select (default p): 
Using default response p
Partition number (1-4, default 1): 
First sector (2048-62914559, default 2048): 
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559): 
Using default value 62914559
Partition 1 of type Linux and of size 30 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.

操作方法如上：将剩余 /dev/sdc /dev/sdd /dev/sde /dev/sdf /dev/sdg /dev/sdh /dev/sdi 磁盘进行分区。
您可以通过 ls 命令查看，最终磁盘分区格式呈现如下

[root@asmsi12c ~]# ls /dev/sd*
/dev/sda   /dev/sda2  /dev/sdb   /dev/sdc   /dev/sdd   /dev/sde   /dev/sdf   /dev/sdg   /dev/sdh   /dev/sdi
/dev/sda1  /dev/sda3  /dev/sdb1  /dev/sdc1  /dev/sdd1  /dev/sde1  /dev/sdf1  /dev/sdg1  /dev/sdh1  /dev/sdi1

格式化（仅 /dev/sdb1）

根据规划，/dev/sdb 下的 /dev/sdb1 分区将作为存放Oracle数据库软件安装文件的盘符（分区），其他分区用于ASM存储。

[root@asmsi12c ~]# mkfs.xfs /dev/sdb1
meta-data=/dev/sdb1              isize=256    agcount=4, agsize=1966016 blks
         =                       sectsz=512   attr=2, projid32bit=1
         =                       crc=0        finobt=0, sparse=0
data     =                       bsize=4096   blocks=7864064, imaxpct=25
         =                       sunit=0      swidth=0 blks
naming   =version 2              bsize=4096   ascii-ci=0 ftype=1
log      =internal log           bsize=4096   blocks=3839, version=2
         =                       sectsz=512   sunit=0 blks, lazy-count=1
realtime =none                   extsz=4096   blocks=0, rtextents=0

挂载文件系统

观察13行

[root@asmsi12c ~]# mkdir /u01
[root@asmsi12c ~]# mount /dev/sdb1 /u01/
[root@asmsi12c ~]# df -Th
Filesystem     Type      Size  Used Avail Use% Mounted on
devtmpfs       devtmpfs  3.9G     0  3.9G   0% /dev
tmpfs          tmpfs     3.9G     0  3.9G   0% /dev/shm
tmpfs          tmpfs     3.9G  9.5M  3.9G   1% /run
tmpfs          tmpfs     3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/sda3      xfs        34G   21G   13G  62% /
/dev/sda1      xfs       297M  195M  103M  66% /boot
tmpfs          tmpfs     797M   12K  797M   1% /run/user/42
tmpfs          tmpfs     797M     0  797M   0% /run/user/0
/dev/sdb1      xfs        30G   33M   30G   1% /u01

添加开机自启

获取 Block ID 添加至 /etc/fstab

[root@asmsi12c ~]# blkid /dev/sdb1
/dev/sdb1: UUID="e3af79a0-858f-440a-ac86-9645ac460755" TYPE="xfs" 
[root@asmsi12c ~]# vim /etc/fstab

添加行

UUID=e3af79a0-858f-440a-ac86-9645ac460755 /u01       xfs      defaults    0 0

2.2 主机环境设置

主机名及IP

[root@asmsi12c ~]# echo "192.168.1.110 asmsi12c" >> /etc/hosts

用户和组

/usr/sbin/groupadd -g 54321 oinstall
/usr/sbin/groupadd -g 54322 dba
/usr/sbin/groupadd -g 54323 oper
/usr/sbin/groupadd -g 54324 asmadmin
/usr/sbin/groupadd -g 54325 asmoper
/usr/sbin/groupadd -g 54326 asmdba
/usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle
/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
passwd oracle --> Changing password for user oracle.
passwd grid --> Changing password for user grid.

创建文件夹及授权

mkdir -p /u01/app/grid
mkdir -p /u01/app/12.2.0.1/grid
mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01
chown -R grid:oinstall /u01/app/grid
chown -R grid:oinstall /u01/app/12.2.0.1
chmod -R 775 /u01/

RPM包安装

yum -y install autoconf
yum -y install automake
yum -y install binutils
yum -y install binutils-devel
yum -y install bison
yum -y install cpp
yum -y install dos2unix
yum -y install ftp
yum -y install gcc
yum -y install gcc-c++
yum -y install lrzsz
yum -y install python-devel
yum -y install compat-libcap1
yum -y install compat-libstdc++-33
yum -y install compat-libstdc++-33.i686
yum -y install glibc-*
yum -y install glibc-*.i686
yum -y install libXpm-*.i686
yum -y install libXext
yum -y install libXext.i686
yum -y install libXtst
yum -y install libXtst.i686
yum -y install libX11
yum -y install libX11.i686
yum -y install libXau
yum -y install libXau.i686
yum -y install libxcb
yum -y install libxcb.i686
yum -y install libXi
yum -y install libXi.i686
yum -y install libstdc++.i686
yum -y install libstdc++-devel
yum -y install libstdc++-devel.i686
yum -y install libaio
yum -y install libaio.i686
yum -y install libaio-devel
yum -y install libaio-devel.i686
yum -y install ksh
yum -y install libXp
yum -y install libaio-devel
yum -y install numactl
yum -y install numactl-devel
yum -y install make -y
yum -y install sysstat -y
yum -y install unixODBC
yum -y install unixODBC-devel
yum -y install elfutils-libelf-devel
yum -y install redhat-lsb-core
yum -y install unzip
yum -y install libXrender
yum -y install libXrender-devel
yum -y install nfs-utils
yum -y install smartmontools
yum -y install tigervnc

您还通过以下脚本直接进行检测和安装

rpm -q autoconf \
automake \
binutils \
binutils-devel \
bison \
cpp \
dos2unix \
ftp \
gcc \
gcc-c++ \
lrzsz \
python-devel \
compat-libcap1 \
compat-libstdc++-33 \
compat-libstdc++-33.i686 \
glibc-* \
glibc-*.i686 \
libXpm-*.i686 \
libXext \
libXext.i686 \
libXtst \
libXtst.i686 \
libX11 \
libX11.i686 \
libXau \
libXau.i686 \
libxcb \
libxcb.i686 \
libXi \
libXi.i686 \
libstdc++.i686 \
libstdc++-devel \
libstdc++-devel.i686 \
libaio \
libaio.i686 \
libaio-devel \
libaio-devel.i686 \
ksh \
libXp \
libaio-devel \
numactl \
numactl-devel \
make \
sysstat \
unixODBC \
unixODBC-devel \
elfutils-libelf-devel \
redhat-lsb-core \
unzip \
libXrender \
libXrender-devel \
nfs-utils \
smartmontools \
tigervnc | grep "not installed" | cut -d ' ' -f 2 | sed 's/^/yum install -y /g'

资源限制

编辑文件 /etc/security/limits.conf 添加以下行

grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
grid hard stack 32768
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768

内核参数

编辑文件 /etc/sysctl.conf 添加以下行

fs.aio-max-nr = 1048576
fs.file-max = 6815744
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 = 1048586
kernel.panic_on_oops = 1
kernel.shmmax = 7730941132
kernel.shmall = 1887436
kernel.shmmni = 4096

执行 sysctl -p 生效

SHELL限制

echo "session required pam_limits.so" >> /etc/pam.d/login

关闭防火墙

systemctl status firewalld.service
systemctl stop firewalld.service
systemctl disable firewalld.service

关闭SELinux

vim /etc/selinux/config
SELINUX=disabled

Oracle用户环境变量
切换至 Oracle 用户，编辑 .bash_profile

[root@asmsi12c ~]# su - oracle
[oracle@asmsi12c ~]$ vim .bash_profile

添加以下行

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
export TMP=/tmp
export TMPDIR=$TMP
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1; export ORACLE_HOME
ORACLE_SID=SIASMCDB; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/12.2.0.1/db_1/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

Grid用户环境变量
切换至 Grid 用户，编辑 .bash_profile

[root@asmsi12c ~]# su - grid
[grid@asmsi12c ~]$ vim .bash_profile

添加以下行

PS1="[`whoami`@`hostname`:"'$PWD]$'
export PS1
umask 022
export TMP=/tmp
export TMPDIR=$TMP
ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/12.2.0.1/grid; export ORACLE_HOME
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi

3 ASM 磁盘配置

3.1 设置受信任白名单
编辑文件 /etc/scsi_id 添加选项 options=-g，如果没有那么创建它。

[root@asmsi12c ~]# echo "options=-g" > /etc/scsi_id.config

3.2 确认SCSI标识符
通过命令 /usr/lib/udev/scsi_id -g -u -d 分区名 确认标识符
以下 2,4,6,8,10,12,14 行为标识符

#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc1
36000c29817c724249fffa2aff9f16ebc
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd1
36000c29a2b56e5768a39dfc8ff0f9818
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde1
36000c29254011ae2772b0a142552cf5c
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf1
36000c29c74cca73378c5ab985257bef8
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdg1
36000c29c4ddc31debc42547ac0474b45
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdh1
36000c292f96acc701bd3f61592504ae7
#[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdi1
36000c2910aa2ef2126ad1eb6c5420de2

3.3 创建编辑UDEV规则文件
创建文件 vim /etc/udev/rules.d/99-oracle-asmdevices.rules ，并将获取到的SCSI标识符添加进该文件的 RESULT 参数中。需要注意的是：每个SCSI标识符占用一个条目，且每个条目必须在同一行，不可换行。你可以根据实际情况修改 SYMLINK+ 对应的显示名字。

KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29817c724249fffa2aff9f16ebc", SYMLINK+="oracleasm/asm-ocr1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29a2b56e5768a39dfc8ff0f9818", SYMLINK+="oracleasm/asm-ocr2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29254011ae2772b0a142552cf5c", SYMLINK+="oracleasm/asm-ocr3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29c74cca73378c5ab985257bef8", SYMLINK+="oracleasm/asm-data1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c29c4ddc31debc42547ac0474b45", SYMLINK+="oracleasm/asm-data2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c292f96acc701bd3f61592504ae7", SYMLINK+="oracleasm/asm-archived", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="36000c2910aa2ef2126ad1eb6c5420de2", SYMLINK+="oracleasm/asm-backup", OWNER="grid", GROUP="asmadmin", MODE="0660"

通过 root 用户执行 partprobe 命令重新识别

[root@asmsi12c ~]# /sbin/partprobe /dev/sdc1
[root@asmsi12c ~]# /sbin/partprobe /dev/sdd1
[root@asmsi12c ~]# /sbin/partprobe /dev/sde1
[root@asmsi12c ~]# /sbin/partprobe /dev/sdf1
[root@asmsi12c ~]# /sbin/partprobe /dev/sdg1
[root@asmsi12c ~]# /sbin/partprobe /dev/sdh1
[root@asmsi12c ~]# /sbin/partprobe /dev/sdi1

重启UDEV服务

[root@asmsi12c ~]# udevadm control --reload-rules

查看设备
请确保所有链接磁盘均可见，并具有对应的正确权限，否则，在进行下一步之前请解决该问题。

[root@asmsi12c ~]# ls -lathr /dev/oracleasm/*
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-data2 -> ../sdg1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-ocr3 -> ../sde1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-data1 -> ../sdf1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-ocr1 -> ../sdc1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-ocr2 -> ../sdd1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-archived -> ../sdh1
lrwxrwxrwx. 1 root root 7 Oct 25 10:24 /dev/oracleasm/asm-backup -> ../sdi1

上面链接归 root 用户所有，但是链接所指向的磁盘是拥有正确权限的

[root@asmsi12c ~]# ls -lathr /dev/sd*1 |grep -v sda1 |grep -v sdb1
brw-rw----. 1 grid asmadmin 8,  97 Oct 25 10:24 /dev/sdg1
brw-rw----. 1 grid asmadmin 8,  65 Oct 25 10:24 /dev/sde1
brw-rw----. 1 grid asmadmin 8,  81 Oct 25 10:24 /dev/sdf1
brw-rw----. 1 grid asmadmin 8,  33 Oct 25 10:24 /dev/sdc1
brw-rw----. 1 grid asmadmin 8,  49 Oct 25 10:24 /dev/sdd1
brw-rw----. 1 grid asmadmin 8, 113 Oct 25 10:24 /dev/sdh1
brw-rw----. 1 grid asmadmin 8, 129 Oct 25 10:24 /dev/sdi1

4 数据库软件安装

Oracle 12cR2 具体图形化安装请参考 1级搭建类103

使用 oracle 用户进行安装，运行可执行程序

[oracle@asmsi12c database]$ ./runInstaller

image_1do0d5fr31daakb0q90h316flm.png-355.7kB

image_1do0d6012ik2in1nv11vtv18gn13.png-343.3kB

image_1do0d6bb43n01f071vs61qdr78k1g.png-342.1kB

image_1do0d7nhd8vb1ock1df714ag1i6o1t.png-355.5kB

image_1do0d81nsc0ord1bj91ha7eq62a.png-358kB

image_1do0d8fh71pq1vim5aua2t1ium2n.png-358.2kB

image_1do0d8pb31a5b18bu1kb1vh79ns34.png-372.4kB

image_1do0d9bld1v7h6tb1qog1bn9p9n3h.png-363.7kB

image_1do0e6f7c10k3h8e18vb2j71jqq4e.png-319.4kB

image_1do0e9lbv143g45s1g446u018bn4r.png-266.6kB

image_1do0ea7oj1c72livhrs1doa1f3358.png-335kB

5 创建并启动监听

运行 netca 进行监听文件创建

image_1do0eju1kblkj0vf1b1cba13k75l.png-462.1kB

image_1do0ek86i8jr1ck0nard73ns62.png-455.6kB

image_1do0eki0jfvt1k3drjfjbn1sc36f.png-449.7kB

image_1do0ekvo31n9r1ag81glr1v901vtv6s.png-453.6kB

image_1do0el7e5rrm1bat2l0103inv879.png-451kB

image_1do0eldr81svmi521h5ptv71pb17m.png-445.7kB

image_1do0elubpmcb10s11o0f1ioc2pq83.png-463.5kB

6 GI 软件安装

使用 grid 用户进行安装

将软件解压至 grid 用的家目录

[grid@asmsi12c ~]$ cd $ORACLE_HOME/
[grid@asmsi12c grid]$ unzip -q /soft/linuxx64_12201_grid_home.zip

运行可执行程序

[grid@asmsi12c grid]$ ./gridSetup.sh

image_1do0fanhurtic3qjp71egn170l8g.png-346.4kB

image_1do0fbomrfvtgu3rpmu2498t.png-379.2kB

image_1do0fcgn31uu91bl7gbljijqtb9a.png-379.8kB

image_1do0fd9rmh5e172nk5llm8lki9n.png-364.5kB

image_1do0fdr4j1l1fnbouitogr1aq4a4.png-350.5kB

image_1do0fe3h02ncs0i5lt14gb1i7rah.png-354.1kB

image_1do0ffcih14tra93ptesk28mgau.png-362.6kB

image_1do0ffu3c5asnhs1qt7j0r176sbb.png-359.2kB

image_1do0fgc251umt1e9l17hovo41lpubo.png-345.9kB

image_1do0fhmja1vf6m031q937de1577c5.png-362.2kB

注意：集群验证包您可以选择忽略，当然，为了完整性，也可以选择安装

使用 root 用户，按以下操作（该包在官方自带的数据库软件解压后的 database-->rpm 文件夹里面）

[root@asmsi12c ~]# cd /soft/database/rpm/
[root@asmsi12c rpm]# ls
cvuqdisk-1.0.10-1.rpm
[root@asmsi12c rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm 
Preparing...                          ################################# [100%]
Updating / installing...
   1:cvuqdisk-1.0.10-1                ################################# [100%]

重新点击 Check Again 顺利通过

image_1do0ftu0b11kpa4j1hhh1o541mrbci.png-368.2kB

image_1do0fvd6i1gaq1u33i18uvj3lidf.png-371.9kB

image_1do0g4doh5flu81ijn1s6qbh8ds.png-316.8kB

image_1do0g78m91nab1sbm120211do1qjqe9.png-281.3kB

image_1do0hcugt8lg2kj1hlk1oldcbef6.png-289.6kB

image_1do0heu7dni17c89td11dc1i9vfj.png-385.7kB

image_1do0hj4dofrm577dlo1m6f63dg0.png-351.2kB

GI 软件安装完成后，可使用下面命令进行查看状态

[grid@asmsi12c:/home/grid]$crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       asmsi12c                 STABLE
ora.OCR.dg
               ONLINE  ONLINE       asmsi12c                 STABLE
ora.asm
               ONLINE  ONLINE       asmsi12c                 Started,STABLE
ora.ons
               OFFLINE OFFLINE      asmsi12c                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       asmsi12c                 STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       asmsi12c                 STABLE
--------------------------------------------------------------------------------

查看 ASM 实例监听状态

[grid@asmsi12c grid]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-OCT-2019 12:13:43
Copyright (c) 1991, 2016, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asmsi12c)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date                25-OCT-2019 12:06:11
Uptime                    0 days 0 hr. 7 min. 31 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12.2.0.1/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/asmsi12c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asmsi12c)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully

7 ASM 磁盘组创建

使用 grid 用户，执行 asmca 创建ASM磁盘组

image_1do0i19at5ui1p7h14k81auq16vrgd.png-266.9kB

image_1do0i1r1p1qt814eq1jner6ipp9gq.png-217.6kB

image_1do0i2ta01617q7b106l1v6g1qpuh7.png-246.5kB

按照以上方法，继续创建磁盘组，最终结果如下图，注意冗余方式

image_1do0i9479duc1kbu1jfb1tkr1ltdij.png-235.9kB

8 数据库创建

使用 oracle 用户，执行 dbca 创建数据库

image_1do0igfv71r0ncta1rvvbhm1o9qj0.png-358.8kB

image_1do0igun1t1bcl12vr3ln10p5jd.png-359.4kB

image_1do0ihojo11iq1dnbhiu8ln1vujq.png-371.3kB

image_1do0iioiibo517aphcqtf44ouk7.png-368.1kB

image_1do0ik1jh7e7pag1dnutrhqn6kk.png-341.3kB

image_1do0imfe9pqa1d4t1r2d3pkaqlr.png-373.4kB

image_1do0imucb4g6utq2n1l5o1egdm8.png-354.1kB

image_1do0inc3k1qi3nd61oe611q4eu3ml.png-358.3kB

image_1do0ino06fqc8a610bu8ab1supn2.png-356.9kB

image_1do0ipvjs1hern921jboucspvtnf.png-380.6kB

image_1do0iqeje6mmmr9inenra419ns.png-356.4kB

image_1do0ir4b9pn7uk81slv1ae7182ao9.png-368.1kB

image_1do0iriv318pgoo5nbpmps1dbvom.png-382.9kB

image_1do0itu9lh9t127lc60161d19dp3.png-393.1kB

image_1do0jrp9e12d61o31mvp7p79ggpg.png-374.5kB

[oracle@asmsi12c:/home/oracle]$sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 25 12:47:59 2019
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> show pdbs
    CON_ID CON_NAME          OPEN MODE  RESTRICTED
---------------------------  ---------- ----------
     2 PDB$SEED              READ ONLY  NO
     3 ERP1                  READ WRITE NO
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
+DATA/SIASMCDB/DATAFILE/system.256.1022589149
+DATA/SIASMCDB/DATAFILE/sysaux.257.1022589231
+DATA/SIASMCDB/DATAFILE/undotbs1.258.1022589267
+DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/system.266.1022589329
+DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/sysaux.265.1022589329
+DATA/SIASMCDB/DATAFILE/users.259.1022589267
+DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/undotbs1.267.1022589329
+DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/system.271.1022589707
+DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/sysaux.272.1022589707
+DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/undotbs1.270.1022589707
+DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/users.274.1022589719
11 rows selected.