[关闭]
@clisdodo 2019-11-19T02:44:40.000000Z 字数 15829 阅读 1260

Oracle 12cR2 SI ASM UDEV方式图形化搭建(OEL 7.7)

OEL7.7 12cR2 SingleInstance ASM


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

你要知道的

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

1 操作系统安装

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

  1. # 为方便理解,将贴出针对磁盘 /dev/sdb 的具体分区操作信息
  2. [root@asmsi12c ~]# fdisk /dev/sdb
  3. Welcome to fdisk (util-linux 2.23.2).
  4. Changes will remain in memory only, until you decide to write them.
  5. Be careful before using the write command.
  6. Device does not contain a recognized partition table
  7. Building a new DOS disklabel with disk identifier 0x91c3f3dd.
  8. Command (m for help): n
  9. Partition type:
  10. p primary (0 primary, 0 extended, 4 free)
  11. e extended
  12. Select (default p):
  13. Using default response p
  14. Partition number (1-4, default 1):
  15. First sector (2048-62914559, default 2048):
  16. Using default value 2048
  17. Last sector, +sectors or +size{K,M,G} (2048-62914559, default 62914559):
  18. Using default value 62914559
  19. Partition 1 of type Linux and of size 30 GiB is set
  20. Command (m for help): w
  21. The partition table has been altered!
  22. Calling ioctl() to re-read partition table.
  23. 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存储。

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

挂载文件系统

观察13行

  1. [root@asmsi12c ~]# mkdir /u01
  2. [root@asmsi12c ~]# mount /dev/sdb1 /u01/
  3. [root@asmsi12c ~]# df -Th
  4. Filesystem Type Size Used Avail Use% Mounted on
  5. devtmpfs devtmpfs 3.9G 0 3.9G 0% /dev
  6. tmpfs tmpfs 3.9G 0 3.9G 0% /dev/shm
  7. tmpfs tmpfs 3.9G 9.5M 3.9G 1% /run
  8. tmpfs tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup
  9. /dev/sda3 xfs 34G 21G 13G 62% /
  10. /dev/sda1 xfs 297M 195M 103M 66% /boot
  11. tmpfs tmpfs 797M 12K 797M 1% /run/user/42
  12. tmpfs tmpfs 797M 0 797M 0% /run/user/0
  13. /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 主机环境设置

  1. [root@asmsi12c ~]# echo "192.168.1.110 asmsi12c" >> /etc/hosts
  1. /usr/sbin/groupadd -g 54321 oinstall
  2. /usr/sbin/groupadd -g 54322 dba
  3. /usr/sbin/groupadd -g 54323 oper
  4. /usr/sbin/groupadd -g 54324 asmadmin
  5. /usr/sbin/groupadd -g 54325 asmoper
  6. /usr/sbin/groupadd -g 54326 asmdba
  7. /usr/sbin/useradd -g oinstall -G dba,asmdba,oper oracle
  8. /usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
  9. passwd oracle --> Changing password for user oracle.
  10. passwd grid --> Changing password for user grid.
  1. mkdir -p /u01/app/grid
  2. mkdir -p /u01/app/12.2.0.1/grid
  3. mkdir -p /u01/app/oracle/product/12.2.0.1/db_1
  4. mkdir -p /u01/app/oraInventory
  5. chown -R oracle:oinstall /u01
  6. chown -R grid:oinstall /u01/app/grid
  7. chown -R grid:oinstall /u01/app/12.2.0.1
  8. chmod -R 775 /u01/
  1. yum -y install autoconf
  2. yum -y install automake
  3. yum -y install binutils
  4. yum -y install binutils-devel
  5. yum -y install bison
  6. yum -y install cpp
  7. yum -y install dos2unix
  8. yum -y install ftp
  9. yum -y install gcc
  10. yum -y install gcc-c++
  11. yum -y install lrzsz
  12. yum -y install python-devel
  13. yum -y install compat-libcap1
  14. yum -y install compat-libstdc++-33
  15. yum -y install compat-libstdc++-33.i686
  16. yum -y install glibc-*
  17. yum -y install glibc-*.i686
  18. yum -y install libXpm-*.i686
  19. yum -y install libXext
  20. yum -y install libXext.i686
  21. yum -y install libXtst
  22. yum -y install libXtst.i686
  23. yum -y install libX11
  24. yum -y install libX11.i686
  25. yum -y install libXau
  26. yum -y install libXau.i686
  27. yum -y install libxcb
  28. yum -y install libxcb.i686
  29. yum -y install libXi
  30. yum -y install libXi.i686
  31. yum -y install libstdc++.i686
  32. yum -y install libstdc++-devel
  33. yum -y install libstdc++-devel.i686
  34. yum -y install libaio
  35. yum -y install libaio.i686
  36. yum -y install libaio-devel
  37. yum -y install libaio-devel.i686
  38. yum -y install ksh
  39. yum -y install libXp
  40. yum -y install libaio-devel
  41. yum -y install numactl
  42. yum -y install numactl-devel
  43. yum -y install make -y
  44. yum -y install sysstat -y
  45. yum -y install unixODBC
  46. yum -y install unixODBC-devel
  47. yum -y install elfutils-libelf-devel
  48. yum -y install redhat-lsb-core
  49. yum -y install unzip
  50. yum -y install libXrender
  51. yum -y install libXrender-devel
  52. yum -y install nfs-utils
  53. yum -y install smartmontools
  54. yum -y install tigervnc

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

  1. rpm -q autoconf \
  2. automake \
  3. binutils \
  4. binutils-devel \
  5. bison \
  6. cpp \
  7. dos2unix \
  8. ftp \
  9. gcc \
  10. gcc-c++ \
  11. lrzsz \
  12. python-devel \
  13. compat-libcap1 \
  14. compat-libstdc++-33 \
  15. compat-libstdc++-33.i686 \
  16. glibc-* \
  17. glibc-*.i686 \
  18. libXpm-*.i686 \
  19. libXext \
  20. libXext.i686 \
  21. libXtst \
  22. libXtst.i686 \
  23. libX11 \
  24. libX11.i686 \
  25. libXau \
  26. libXau.i686 \
  27. libxcb \
  28. libxcb.i686 \
  29. libXi \
  30. libXi.i686 \
  31. libstdc++.i686 \
  32. libstdc++-devel \
  33. libstdc++-devel.i686 \
  34. libaio \
  35. libaio.i686 \
  36. libaio-devel \
  37. libaio-devel.i686 \
  38. ksh \
  39. libXp \
  40. libaio-devel \
  41. numactl \
  42. numactl-devel \
  43. make \
  44. sysstat \
  45. unixODBC \
  46. unixODBC-devel \
  47. elfutils-libelf-devel \
  48. redhat-lsb-core \
  49. unzip \
  50. libXrender \
  51. libXrender-devel \
  52. nfs-utils \
  53. smartmontools \
  54. tigervnc | grep "not installed" | cut -d ' ' -f 2 | sed 's/^/yum install -y /g'

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

  1. grid soft nproc 2047
  2. grid hard nproc 16384
  3. grid soft nofile 1024
  4. grid hard nofile 65536
  5. grid soft stack 10240
  6. grid hard stack 32768
  7. oracle soft nproc 2047
  8. oracle hard nproc 16384
  9. oracle soft nofile 1024
  10. oracle hard nofile 65536
  11. oracle soft stack 10240
  12. oracle hard stack 32768

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

  1. fs.aio-max-nr = 1048576
  2. fs.file-max = 6815744
  3. kernel.sem = 250 32000 100 128
  4. net.ipv4.ip_local_port_range = 9000 65500
  5. net.core.rmem_default = 262144
  6. net.core.rmem_max = 4194304
  7. net.core.wmem_default = 262144
  8. net.core.wmem_max = 1048586
  9. kernel.panic_on_oops = 1
  10. kernel.shmmax = 7730941132
  11. kernel.shmall = 1887436
  12. kernel.shmmni = 4096

执行 sysctl -p 生效

  1. echo "session required pam_limits.so" >> /etc/pam.d/login
  1. systemctl status firewalld.service
  2. systemctl stop firewalld.service
  3. systemctl disable firewalld.service
  1. vim /etc/selinux/config
  2. SELINUX=disabled
  1. [root@asmsi12c ~]# su - oracle
  2. [oracle@asmsi12c ~]$ vim .bash_profile

添加以下行

  1. PS1="[`whoami`@`hostname`:"'$PWD]$'
  2. export PS1
  3. export TMP=/tmp
  4. export TMPDIR=$TMP
  5. ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  6. ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1; export ORACLE_HOME
  7. ORACLE_SID=SIASMCDB; export ORACLE_SID
  8. ORACLE_TERM=xterm; export ORACLE_TERM
  9. NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
  10. NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
  11. PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/12.2.0.1/db_1/bin:$ORACLE_HOME/bin; export PATH
  12. THREADS_FLAG=native; export THREADS_FLAG
  13. if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
  14. if [ $SHELL = "/bin/ksh" ]; then
  15. ulimit -p 16384
  16. ulimit -n 65536
  17. else
  18. ulimit -u 16384 -n 65536
  19. fi
  20. umask 022
  21. fi
  1. [root@asmsi12c ~]# su - grid
  2. [grid@asmsi12c ~]$ vim .bash_profile

添加以下行

  1. PS1="[`whoami`@`hostname`:"'$PWD]$'
  2. export PS1
  3. umask 022
  4. export TMP=/tmp
  5. export TMPDIR=$TMP
  6. ORACLE_SID=+ASM; export ORACLE_SID
  7. ORACLE_TERM=xterm; export ORACLE_TERM
  8. ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
  9. ORACLE_HOME=/u01/app/12.2.0.1/grid; export ORACLE_HOME
  10. NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
  11. PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/bin; export PATH
  12. THREADS_FLAG=native; export THREADS_FLAG
  13. if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
  14. if [ $SHELL = "/bin/ksh" ]; then
  15. ulimit -p 16384
  16. ulimit -n 65536
  17. else
  18. ulimit -u 16384 -n 65536
  19. fi
  20. umask 022
  21. fi

3 ASM 磁盘配置

  1. [root@asmsi12c ~]# echo "options=-g" > /etc/scsi_id.config
  1. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc1
  2. 36000c29817c724249fffa2aff9f16ebc
  3. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd1
  4. 36000c29a2b56e5768a39dfc8ff0f9818
  5. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde1
  6. 36000c29254011ae2772b0a142552cf5c
  7. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf1
  8. 36000c29c74cca73378c5ab985257bef8
  9. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdg1
  10. 36000c29c4ddc31debc42547ac0474b45
  11. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdh1
  12. 36000c292f96acc701bd3f61592504ae7
  13. #[root@asmsi12c ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdi1
  14. 36000c2910aa2ef2126ad1eb6c5420de2
  1. 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"
  2. 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"
  3. 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"
  4. 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"
  5. 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"
  6. 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"
  7. 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 命令重新识别

  1. [root@asmsi12c ~]# /sbin/partprobe /dev/sdc1
  2. [root@asmsi12c ~]# /sbin/partprobe /dev/sdd1
  3. [root@asmsi12c ~]# /sbin/partprobe /dev/sde1
  4. [root@asmsi12c ~]# /sbin/partprobe /dev/sdf1
  5. [root@asmsi12c ~]# /sbin/partprobe /dev/sdg1
  6. [root@asmsi12c ~]# /sbin/partprobe /dev/sdh1
  7. [root@asmsi12c ~]# /sbin/partprobe /dev/sdi1

重启UDEV服务

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

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

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

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

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

4 数据库软件安装

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

  1. [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 用的家目录

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

运行可执行程序

  1. [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 文件夹里面)

  1. [root@asmsi12c ~]# cd /soft/database/rpm/
  2. [root@asmsi12c rpm]# ls
  3. cvuqdisk-1.0.10-1.rpm
  4. [root@asmsi12c rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm
  5. Preparing... ################################# [100%]
  6. Updating / installing...
  7. 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 软件安装完成后,可使用下面命令进行查看状态

  1. [grid@asmsi12c:/home/grid]$crsctl stat res -t
  2. --------------------------------------------------------------------------------
  3. Name Target State Server State details
  4. --------------------------------------------------------------------------------
  5. Local Resources
  6. --------------------------------------------------------------------------------
  7. ora.LISTENER.lsnr
  8. ONLINE ONLINE asmsi12c STABLE
  9. ora.OCR.dg
  10. ONLINE ONLINE asmsi12c STABLE
  11. ora.asm
  12. ONLINE ONLINE asmsi12c Started,STABLE
  13. ora.ons
  14. OFFLINE OFFLINE asmsi12c STABLE
  15. --------------------------------------------------------------------------------
  16. Cluster Resources
  17. --------------------------------------------------------------------------------
  18. ora.cssd
  19. 1 ONLINE ONLINE asmsi12c STABLE
  20. ora.diskmon
  21. 1 OFFLINE OFFLINE STABLE
  22. ora.evmd
  23. 1 ONLINE ONLINE asmsi12c STABLE
  24. --------------------------------------------------------------------------------

查看 ASM 实例监听状态

  1. [grid@asmsi12c grid]$ lsnrctl status
  2. LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-OCT-2019 12:13:43
  3. Copyright (c) 1991, 2016, Oracle. All rights reserved.
  4. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asmsi12c)(PORT=1522)))
  5. STATUS of the LISTENER
  6. ------------------------
  7. Alias LISTENER
  8. Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
  9. Start Date 25-OCT-2019 12:06:11
  10. Uptime 0 days 0 hr. 7 min. 31 sec
  11. Trace Level off
  12. Security ON: Local OS Authentication
  13. SNMP OFF
  14. Listener Parameter File /u01/app/12.2.0.1/grid/network/admin/listener.ora
  15. Listener Log File /u01/app/grid/diag/tnslsnr/asmsi12c/listener/alert/log.xml
  16. Listening Endpoints Summary...
  17. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asmsi12c)(PORT=1522)))
  18. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
  19. Services Summary...
  20. Service "+ASM" has 1 instance(s).
  21. Instance "+ASM", status READY, has 1 handler(s) for this service...
  22. Service "+ASM_OCR" has 1 instance(s).
  23. Instance "+ASM", status READY, has 1 handler(s) for this service...
  24. 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

  1. [oracle@asmsi12c:/home/oracle]$sqlplus / as sysdba
  2. SQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 25 12:47:59 2019
  3. Copyright (c) 1982, 2016, Oracle. All rights reserved.
  4. Connected to:
  5. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  6. SQL> show pdbs
  7. CON_ID CON_NAME OPEN MODE RESTRICTED
  8. --------------------------- ---------- ----------
  9. 2 PDB$SEED READ ONLY NO
  10. 3 ERP1 READ WRITE NO
  11. SQL> select name from v$datafile;
  12. NAME
  13. --------------------------------------------------------------------------------
  14. +DATA/SIASMCDB/DATAFILE/system.256.1022589149
  15. +DATA/SIASMCDB/DATAFILE/sysaux.257.1022589231
  16. +DATA/SIASMCDB/DATAFILE/undotbs1.258.1022589267
  17. +DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/system.266.1022589329
  18. +DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/sysaux.265.1022589329
  19. +DATA/SIASMCDB/DATAFILE/users.259.1022589267
  20. +DATA/SIASMCDB/4700A987085B3DFAE05387E5E50A8C7B/DATAFILE/undotbs1.267.1022589329
  21. +DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/system.271.1022589707
  22. +DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/sysaux.272.1022589707
  23. +DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/undotbs1.270.1022589707
  24. +DATA/SIASMCDB/95B5C4601FB02104E0536E01A8C01658/DATAFILE/users.274.1022589719
  25. 11 rows selected.
添加新批注
在作者公开此批注前,只有你和作者可见。
回复批注