Oracle 19c rac集群靜默安裝
操作手冊
for redhat7
系統運維操作手冊
(v2.0)
2020年11月30日
作者：龍龍
南京邁特望科技股份有限公司
一、安裝準備
1.1.RHEL版本及IP規劃
1.1.1.OS版本信息
[root@localhost ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.6 (Maipo)
[root@localhost ~]# uname -r
3.10.0-957.el7.x86_64
1.1.2.IP規劃
主機
Public
VIP
Scanip
Private
ydb01
192.168.10.91
192.168.10.93
192.168.10.95
172.16.16.91/92
ydb02
192.168.10.92
192.168.10.94
192.168.10.95
172.16.16.93/94
2.硬體檢查1.2.1.硬碟空間檢查1./tmp目錄大小至少：1GB
2.安裝Grid Infrastracture所需空間：12GB
3.安裝Oracle Database所需空間：7.3GB
4.此外安裝過程中分析、收集、跟蹤文件所需空間：10GB
5.建議總共至少100GB（此處不包含ASM或NFS的空間需求）
1.2.2.內存檢查1.內存大小：至少8GB
2.Swap大小：
3.當內存為4GB-16GB時，Swap需要大於等於系統內存。
4.當內存大於16GB時，Swap等於16GB即可。
1.3.創建用戶和組創建用戶和組,用戶uid和組gid所有節點需要相同。
1.3.1.添加用戶和用戶組1.
/usr/sbin/groupadd -g 50001 oinstall
2./usr/sbin/groupadd -g 50002 dba
3./usr/sbin/groupadd -g 50003 oper
4./usr/sbin/groupadd -g 50004 backupdba
5./usr/sbin/groupadd -g 50005 dgdba
6./usr/sbin/groupadd -g 50006 kmdba
7./usr/sbin/groupadd -g 50007 asmdba
8./usr/sbin/groupadd -g 50008 asmoper
9./usr/sbin/groupadd -g 50009 asmadmin
10./usr/sbin/groupadd -g 50010 racdba
11./usr/sbin/useradd -u 50011 -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid
12./usr/sbin/useradd -u 50012 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,racdba oracle
13.echo "oracle" | passwd --stdin oracle
14.echo "oracle" | passwd --stdin grid
常見用戶組說明
組
角色
權限
oinstall
安裝和升級oracle軟體
dba
sysdba
創建、刪除、修改、啟動、關閉資料庫，切換日誌歸檔模式，備份恢復資料庫
oper
sysoper
啟動、關閉、修改、備份、恢復資料庫，修改歸檔模式
asmdba
sysdba自動存儲管理
管理ASM實例
asmoper
sysoper自動存儲管理
啟動、停止ASM實例
asmadmin
sysasm
掛載、卸載磁碟組，管理其他存儲設備
backupdba
sysbackup
啟動關閉和執行備份恢復（12c）
dgdba
sysdg
管理Data Guard（12c）
kmdba
syskm
加密管理相關操作
racdba
rac管理
1.3.2.創建安裝目錄1.
# mkdir /opt/oracle
2.# mkdir /opt/oracle/dbbase
3.# mkdir /opt/oracle/gbase
4.# mkdir /opt/oracle/ghome
5.# mkdir /opt/oracle/oraInventory
6.# chown -R grid:oinstall /opt/oracle
7.# chown -R oracle:oinstall /opt/oracle/dbbase
8.# chmod -R g+w /opt/oracle
1.3.3.1. vi /etc/fstab
2.tmpfs /dev/shm tmpfs defaults,size=10g 0 0
3.
4.mount -o remount /dev/shm
5.
6.[root@ydb01 ~]# df -h
7.Filesystem Size Used Avail Use% Mounted on
8./dev/sda2 268G 16G 253G 6% /
9.devtmpfs 7.9G 0 7.9G 0% /dev
10.tmpfs 10G 0 10G 0% /dev/shm
11.tmpfs 7.9G 13M 7.9G 1% /run
12.tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup
13.tmpfs 1.6G 12K 1.6G 1% /run/user/42
14.tmpfs 1.6G 0 1.6G 0% /run/user/0
1.3.4.修改用戶環境變量1.
vi /home/oracle/.bash_profile
2.export ORACLE_BASE=/opt/oracle/dbbase
3.export ORACLE_HOME=$ORACLE_BASE/19c/db_1
4.export ORACLE_SID=emrep
5.export PATH=$ORACLE_HOME/bin:$PATH
6.export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
7.export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
8.export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
9.umask 0022
10.# export DISPLAY=0.0.0.0:0.0
11.export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
12.export LC_ALL=en_US.UTF-8
13.
14.vi /home/grid/.bash_profile
15.export ORACLE_BASE=/opt/oracle/gbase
16.export ORACLE_HOME=/opt/oracle/ghome
17.export GI_HOME=$ORACLE_HOME
18.export PATH=$ORACLE_HOME/bin:$PATH
19.export ORACLE_SID=+ASM1
20.export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
21.export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
22.export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
23.umask 0022
24.# export DISPLAY=0.0.0.0:0.0
25.export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
26.export LC_ALL=en_US.UTF-8
1.4.主機名與hosts1.4.1.修改主機名1.# hostname
2.# hostnamectl --static set-hostname ydb01
1.4.2.添加Hosts解析1.# vi /etc/hosts
2.#Public
3.192.168.10.91 ydb01.localdomain ydb01
4.192.168.10.92 ydb02.localdomain ydb02
5.#Virtual
6.192.168.10.93 ydb01-vip.localdomain ydb01-vip
7.192.168.10.94 ydb01-vip.localdomain ydb02-vip
8.#Private
9. 172.16.16.91 ydb01-priv1.localdomain ydb01-priv1
10.172.16.16.92 ydb01-priv2.localdomain ydb01-priv2
11.172.16.16.93 ydb02-priv1.localdomain ydb02-priv1
12.172.16.16.94 ydb02-priv2.localdomain ydb02-priv2
13.#Scanip
14.192.168.10.95 ydb-scan.localdomain ydb-scan
1.4.3.關閉ZEROCONFecho "NOZEROCONF=yes" >>/etc/sysconfig/network
1.5.配置用戶limits1.
vi /etc/security/limits.conf
2.#for oracle 19c rac @Yong @20190509
3.grid soft nproc 16384
4.grid hard nproc 65536
5.grid soft nofile 32768
6.grid hard nofile 65536
7.grid soft stack 32768
8.grid hard stack 65536
9.grid soft memlock -1
10.grid hard memlock -1
11.oracle soft nproc 16384
12.oracle hard nproc 65536
13.oracle soft nofile 32768
14.oracle hard nofile 65536
15.oracle soft stack 32768
16.oracle hard stack 65536
17.oracle soft memlock -1
18.oracle hard memlock -1
19.
20.vi /etc/pam.d/login
21.#for oracle 19c rac @Yong @20190509
22.session required pam_limits.so
1.6.防火牆與Selinux1.6.1.關閉selinuxsed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config
1.6.2.關閉防火牆1.systemctl stop firewalld
2.systemctl disable firewalld
1.7.設置OS內核參數1.vi /etc/sysctl.conf
2.#for oracle 19c rac @Yong @20190509
3.####fs setting
4.fs.aio-max-nr = 4194304
5.fs.file-max = 6815744
6.####kernel setting
7.kernel.shmall = 4194304
8.kernel.shmmax = 16106127360
9.kernel.shmmni = 4096
10.kernel.sem = 250 32000 100 128
11.kernel.panic_on_oops = 1
12.kernel.panic = 10
13.#### Net Setting
14.net.ipv4.ip_local_port_range = 9000 65500
15.net.core.rmem_default = 262144
16.net.core.rmem_max = 4194304
17.net.core.wmem_default = 262144
18.net.core.wmem_max = 4194304
19.##TCP Cache Setting
20.net.ipv4.tcp_moderate_rcvbuf=1
21.net.ipv4.tcp_rmem = 4096 87380 4194304
22.net.ipv4.tcp_wmem = 4096 16384 4194304
23.net.ipv4.conf.ens36.rp_filter = 2
24.net.ipv4.conf.ens35.rp_filter = 2
25.net.ipv4.conf.ens34.rp_filter = 1
26.####Memory Setting
27.vm.vfs_cache_pressure=200
28.vm.swappiness=10
29.vm.min_free_kbytes=102400
30.#vm.nr_hugepages=10
1.8.安裝必要的rpm包1.8.1.配置本地yum源1.
[root@localhost ~]# df -h
2.Filesystem Size Used Avail Use% Mounted on
3./dev/sda2 268G 4.3G 264G 2% /
4.devtmpfs 7.9G 0 7.9G 0% /dev
5.tmpfs 7.9G 0 7.9G 0% /dev/shm
6.tmpfs 7.9G 13M 7.9G 1% /run
7.tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup
8.tmpfs 1.6G 56K 1.6G 1% /run/user/0
9./dev/sr0 4.2G 4.2G 0 100% /run/media/root/RHEL-7.6 Server.x86_64
10.
11.vi /etc/yum.repos.d/rhel-iso.repo
12.[ISO-DVD]
13.name=Red Hat Enterprise Linux $releasever - $basearch - Source
14.baseurl=file:///run/media/root/RHEL-7.6\ Server.x86_64/
15.enabled=1
16.gpgcheck=0
17.如果沒有光碟機可以將RHEL的安裝ISO文件上傳到伺服器上，然後通過下列命令掛載ISO
18.mkdir /mnt/rhel76iso
19.mount -o loop -t iso9660 /root/rhel-server-7.6-x86_64-dvd.iso /mnt/rhel76iso
20.vi /etc/yum.repos.d/rhel-iso.repo
21.[ISO-DVD]
22.name=Red Hat Enterprise Linux $releasever - $basearch - Source
23.baseurl=file:///mnt/rhel76iso
24.enabled=1
25.gpgcheck=0
1.8.2.安裝rpm包1.
yum install bc gcc gcc-c++ binutils make gdb cmake glibc ksh \
2.elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc-devel \
3.libaio libaio-devel libXrender libXrender-devel libX11 libXau sysstat \
4.libXi libXtst libgcc librdmacm-devel libstdc++ libstdc++-devel libxcb \
5.net-tools nfs-utils compat-libcap1 compat-libstdc++ smartmontools targetcli \
6.python python-configshell python-rtslib python-six unixODBC unixODBC-devel
7.由於RHEL7 缺失compat-libstdc+±33包，需要單獨下載安裝
8.wget ftp://ftp.pbone.net/mirror/ftp5.gwdg.de/pub/opensuse/repositories/home:/matthewdva:/build:/RedHat:/RHEL-7/complete/x86_64/compat-libstdc++-33-3.2.3-71.el7.x86_64.rpm
9.yum localinstall compat-libstdc++-33-3.2.3-71.el7.x86_64.rpm
1.9. ASM磁碟初始化1.
如果不部署mgmtdb,3塊5G的磁碟用於OCR和voting disk即可，如果部署mgmtdb
2.mgmtdb獨立磁碟的情況下，normal冗餘需要53G+存儲，external冗餘需要27G+存儲
3.mgmtdb與ocr及vote disk在同一磁碟組的情況下，normal的磁碟需要56G+存儲
4.本次安裝不部署mgmtdb，規劃四塊存儲，3塊5G和1塊50G,採用udev映射
1.9.1.初始化磁碟5.
[root@ydb01 ~]# echo -e "n\np\n1\n\n\nw" | fdisk /dev/sdb
6.[root@ydb01 ~]# echo -e "n\np\n1\n\n\nw" | fdisk /dev/sdc
7.[root@ydb01 ~]# echo -e "n\np\n1\n\n\nw" | fdisk /dev/sdd
8.[root@ydb01 ~]# echo -e "n\np\n1\n\n\nw" | fdisk /dev/sde
1.9.2. udev映射1.
vi /etc/scsi_id.config
2.options=-g
3.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb1
4.36000c29a5fe67df9fac43441beb4280f
5.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc1
6.36000c29474a249ab2c6f9b2977d040b3
7.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd
8.36000c2925df7736e997e8e6a89865539
9.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb1
10.36000c29a5fe67df9fac43441beb4280f
11.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc1
12.36000c29474a249ab2c6f9b2977d040b3
13.[root@ydb01 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd
14.36000c2925df7736e997e8e6a89865539
15.
16.vi /etc/udev/rules.d/99-oracle-asmdevices.rules
17.
18.KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$parent", RESULT=="36000c29a5fe67df9fac43441beb4280f", SYMLINK+="asmdisks/asmdisk01", OWNER="grid", GROUP="asmadmin", MODE="0660"
19.KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$parent", RESULT=="36000c29474a249ab2c6f9b2977d040b3", SYMLINK+="asmdisks/asmdisk02", OWNER="grid", GROUP="asmadmin", MODE="0660"
20.KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$parent", RESULT=="36000c2925df7736e997e8e6a89865539", SYMLINK+="asmdisks/asmdisk03", OWNER="grid", GROUP="asmadmin", MODE="0660"
21.KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$parent", RESULT=="36000c2930898d85d2050c12f7eb96ef9", SYMLINK+="asmdisks/asmdisk04", OWNER="grid", GROUP="asmadmin", MODE="0660"
22.
23.[root@ydb01 ~]# partprobe
24.[root@ydb01 ~]# /sbin/partprobe /dev/sdb1
25.[root@ydb01 ~]# /sbin/partprobe /dev/sdc1
26.[root@ydb01 ~]# /sbin/partprobe /dev/sdd1
27.[root@ydb01 ~]# /sbin/partprobe /dev/sde1
28.
29.[root@ydb01 ~]# ls -alrth /dev/asmdisks/*
30.lrwxrwxrwx 1 root root 7 May 9 16:10 /dev/asmdisks/asmdisk01 -> ../sdb1
31.lrwxrwxrwx 1 root root 7 May 9 16:10 /dev/asmdisks/asmdisk02 -> ../sdc1
32.lrwxrwxrwx 1 root root 7 May 9 16:10 /dev/asmdisks/asmdisk03 -> ../sdd1
33.lrwxrwxrwx 1 root root 7 May 9 16:10 /dev/asmdisks/asmdisk04 -> ../sde1
1.10.其他優化1.10.1.關閉THP及NUMA1.vi /etc/default/grub
2.在GRUB_CMDLINE_LINUX添加下列選項，用於關閉THP和NUMA
3.transparent_hugepage=never numa=off
4.編譯並重啟主機
5.On BIOS: ~]# grub2-mkconfig -o /boot/grub2/grub.cfg
6.On UEFI: ~]# grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg
1.10.2.NTP配置如果使用CTSS來同步集群間的時間則可以關閉時間同步
1.systemctl stop chronyd
2.systemctl disable chronyd
3.
4.mv /etc/chrony.conf /etc/chrony.conf.bak
1.10.3.禁用avahi1.
systemctl stop avahi-dnsconfd
2.systemctl stop avahi-daemon
3.systemctl disable avahi-dnsconfd
4.systemctl disable avahi-daemon
二. 安裝部署Grid2.1.解壓軟體1.[grid@ydb01 ~]$ cd /opt/software/
2.[grid@ydb01 software]$ ls -alrth
3.total 5.6G
4.-rwxrwxr-x 1 oracle oinstall 2.7G May 9 11:46 LINUX.X64_193000_grid_home.zip
5.-rwxrwxr-x 1 oracle oinstall 2.9G May 9 11:48 LINUX.X64_193000_db_home.zip
6.drwxr-xr-x. 5 root root 46 May 9 16:33 ..
7.drwxrwxr-x 2 oracle oinstall 80 May 9 16:45 .
8.[grid@ydb01 software]$ unzip LINUX.X64_193000_grid_home.zip -d $ORACLE_HOME
2.2.配置互信1.
$ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user grid -hosts "ydb01 ydb02" -advanced -noPromptPassphrase
2.
3.[grid@ydb01 ghome]$ ssh ydb02 date
4.Thu May 9 05:26:35 EDT 2019
5.[grid@ydb01 ghome]$ ssh ydb02-priv1 date
6.Thu May 9 05:26:38 EDT 2019
7.[grid@ydb01 ghome]$ ssh ydb02-priv2 date
8.Thu May 9 05:26:41 EDT 2019
9.[grid@ydb01 ghome]$ ssh ydb01 date
10.Thu May 9 17:25:59 CST 2019
11.[grid@ydb01 ghome]$ ssh ydb01-priv1 date
12.Thu May 9 17:26:01 CST 2019
13.[grid@ydb01 ghome]$ ssh ydb01-priv2 date
14.Thu May 9 17:26:04 CST 2019
2.3.安裝前檢查1.$ORACLE_HOME/runcluvfy.sh stage -pre crsinst -n "ydb01,ydb02" -verbose
2...............
3...............
4...............
5.Failures were encountered during execution of CVU verification request "stage -pre crsinst".
6.
7.Verifying Package: cvuqdisk-1.0.10-1 ...FAILED
8.ydb02: PRVG-11550 : Package "cvuqdisk" is missing on node "ydb02"
9.
10.ydb01: PRVG-11550 : Package "cvuqdisk" is missing on node "ydb01"
11.
12.Verifying Time zone consistency ...FAILED
13.PRVF-5479 : Time zone is not the same on all cluster nodes.
14.Found time zone "CST-8CDT" on nodes "ydb01".
15.Found time zone "EST5EDT" on nodes "ydb02".
16.
17.Verifying resolv.conf Integrity ...FAILED
18.ydb02: PRVF-5636 : The DNS response time for an unreachable node exceeded
19. "15000" ms on following nodes: ydb01,ydb02
20.ydb02: PRVG-10048 : Name "ydb02" was not resolved to an address of the
21. specified type by name servers "192.168.194.2".
22.
23.ydb01: PRVF-5636 : The DNS response time for an unreachable node exceeded
24. "15000" ms on following nodes: ydb01,ydb02
25.ydb01: PRVG-10048 : Name "ydb01" was not resolved to an address of the
26. specified type by name servers "192.168.194.2".
27.
28.Verifying RPM Package Manager database ...INFORMATION
29.PRVG-11250 : The check "RPM Package Manager database" was not performed because
30.it needs 'root' user privileges.
31.
32.Verifying /dev/shm mounted as temporary file system ...FAILED
33.ydb02: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm
34.
35.ydb01: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm
36.
37.
38.CVU operation performed: stage -pre crsinst
39.Date: May 9, 2019 5:29:53 PM
40.CVU home: /opt/oracle/ghome/
41.User: grid
42.根據檢查結果修正作業系統即可
43.2.4.Grid軟體安裝44.安裝前需要在兩節點上安裝cvuqdisk-1.0.10-1.x86_64,軟體在￥ORACLE_HOME//cv/rpm/下
45.
${ORACLE_HOME}/gridSetup.sh -ignorePrereq -waitforcompletion -silent \
46. -responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
47. INVENTORY_LOCATION=/opt/oracle/oraInventory \
48. SELECTED_LANGUAGES=en,en_GB \
49. oracle.install.option=CRS_CONFIG \
50. ORACLE_BASE=/opt/oracle/gbase \
51. oracle.install.asm.OSDBA=asmdba \
52. oracle.install.asm.OSASM=asmadmin \
53. oracle.install.asm.OSOPER=asmoper \
54. oracle.install.crs.config.scanType=LOCAL_SCAN \
55. oracle.install.crs.config.gpnp.scanName=ydb-scan \
56. oracle.install.crs.config.gpnp.scanPort=1521 \
57. oracle.install.crs.config.ClusterConfiguration=STANDALONE \
58. oracle.install.crs.config.configureAsExtendedCluster=false \
59. oracle.install.crs.config.clusterName=ora19c-cluster \
60. oracle.install.crs.config.gpnp.configureGNS=false \
61. oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
62. oracle.install.crs.config.clusterNodes=ydb01:ydb01-vip:HUB,ydb02:ydb02-vip:HUB \
63. oracle.install.crs.config.networkInterfaceList=ens34:192.168.10.0:1,ens35:172.16.16.0:5,ens36:172.16.16.0:5 \
64. oracle.install.asm.configureGIMRDataDG=false \
65. oracle.install.crs.config.useIPMI=false \
66. oracle.install.asm.storageOption=ASM \
67. oracle.install.asmOnNAS.configureGIMRDataDG=false \
68. oracle.install.asm.SYSASMPassword=Oracle_2019 \
69. oracle.install.asm.diskGroup.name=OCRDG \
70. oracle.install.asm.diskGroup.redundancy=NORMAL \
71. oracle.install.asm.diskGroup.AUSize=4 \
72. oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/asmdisks/asmdisk01,,/dev/asmdisks/asmdisk02,,/dev/asmdisks/asmdisk03, \
73. oracle.install.asm.diskGroup.disks=/dev/asmdisks/asmdisk01,/dev/asmdisks/asmdisk02,/dev/asmdisks/asmdisk03 \
74. oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asmdisks/* \
75. oracle.install.asm.configureAFD=false \
76. oracle.install.asm.monitorPassword=Oracle_2019 \
77. oracle.install.crs.configureRHPS=false \
78. oracle.install.crs.config.ignoreDownNodes=false \
79. oracle.install.config.managementOption=NONE \
80. oracle.install.config.omsPort=0 \
81. oracle.install.crs.rootconfig.executeRootScript=false \
82.
安裝日誌如下，需要root用戶執行下列腳本
1.Launching Oracle Grid Infrastructure Setup Wizard...
2.
3.[WARNING] [INS-32047] The location (/opt/oracle/oraInventory) specified for the central inventory is not empty.
4. ACTION: It is recommended to provide an empty location for the inventory.
5.[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
6. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /tmp/GridSetupActions2019-05-09_05-57-03PM/gridSetupActions2019-05-09_05-57-03PM.log
7. ACTION: Identify the list of failed prerequisite checks from the log: /tmp/GridSetupActions2019-05-09_05-57-03PM/gridSetupActions2019-05-09_05-57-03PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
8.The response file for this session can be found at:
9. /opt/oracle/ghome/install/response/grid_2019-05-09_05-57-03PM.rsp
10.
11.You can find the log of this install session at:
12. /tmp/GridSetupActions2019-05-09_05-57-03PM/gridSetupActions2019-05-09_05-57-03PM.log
13.
14.As a root user, execute the following script(s):
15. 1. /opt/oracle/oraInventory/orainstRoot.sh
16. 2. /opt/oracle/ghome/root.sh
17.
18.Execute /opt/oracle/oraInventory/orainstRoot.sh on the following nodes:
19.[ydb01, ydb02]
20.Execute /opt/oracle/ghome/root.sh on the following nodes:
21.[ydb01, ydb02]
22.
23.Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes.
24.
25.Successfully Setup Software with warning(s).
26.As install user, execute the following command to complete the configuration.
27. /opt/oracle/ghome/gridSetup.sh -executeConfigTools -responseFile /opt/oracle/ghome/install/response/gridsetup.rsp [-silent]
28.
29.
30.Moved the install session logs to:
31. /opt/oracle/oraInventory/logs/GridSetupActions2019-05-09_05-57-03PM
2.5.運行root.sh腳本節點1
1.
[root@ydb01 rpm]# /opt/oracle/oraInventory/orainstRoot.sh
2.Changing permissions of /opt/oracle/oraInventory.
3.Adding read,write permissions for group.
4.Removing read,write,execute permissions for world.
5.
6.Changing groupname of /opt/oracle/oraInventory to oinstall.
7.The execution of the script is complete.
8.[root@ydb01 rpm]# /opt/oracle/ghome/root.sh
9.Check /opt/oracle/ghome/install/root_ydb01_2019-05-09_18-08-42-494250060.log for the output of root script
10.[root@ydb01 rpm]#
日誌如下
1.
[root@ydb01 ~]# tail -1000f /opt/oracle/ghome/install/root_ydb01_2019-05-09_18-08-42-494250060.log
2.Performing root user operation.
3.
4.The following environment variables are set as:
5. ORACLE_OWNER= grid
6. ORACLE_HOME= /opt/oracle/ghome
7. Copying dbhome to /usr/local/bin ...
8. Copying oraenv to /usr/local/bin ...
9. Copying coraenv to /usr/local/bin ...
10.
11.
12.Creating /etc/oratab file...
13.Entries will be added to the /etc/oratab file as needed by
14.Database Configuration Assistant when a database is created
15.Finished running generic part of root script.
16.Now product-specific root actions will be performed.
17.Relinking oracle with rac_on option
18.Using configuration parameter file: /opt/oracle/ghome/crs/install/crsconfig_params
19.The log of current session can be found at:
20. /opt/oracle/gbase/crsdata/ydb01/crsconfig/rootcrs_ydb01_2019-05-09_06-08-59PM.log
21.2019/05/09 18:09:11 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
22.2019/05/09 18:09:11 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
23.2019/05/09 18:09:11 CLSRSC-363: User ignored prerequisites during installation
24.2019/05/09 18:09:11 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
25.2019/05/09 18:09:14 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
26.2019/05/09 18:09:15 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
27.2019/05/09 18:09:15 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
28.2019/05/09 18:09:15 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
29.2019/05/09 18:09:40 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
30.2019/05/09 18:09:43 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
31.2019/05/09 18:09:45 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
32.2019/05/09 18:09:57 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
33.2019/05/09 18:09:57 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
34.2019/05/09 18:10:04 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
35.2019/05/09 18:10:04 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
36.2019/05/09 18:10:55 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
37.2019/05/09 18:11:02 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
38.2019/05/09 18:12:07 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
39.2019/05/09 18:12:13 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
40.
41.ASM has been created and started successfully.
42.
43.[DBT-30001] Disk groups created successfully. Check /opt/oracle/gbase/cfgtoollogs/asmca/asmca-190509PM061247.log for details.
44.
45.2019/05/09 18:13:46 CLSRSC-482: Running command: '/opt/oracle/ghome/bin/ocrconfig -upgrade grid oinstall'
46.CRS-4256: Updating the profile
47.Successful addition of voting disk 017fc3cc7d164fb5bf872733c61934dd.
48.Successful addition of voting disk 6a40f886828b4f36bfedfadafd0274a1.
49.Successful addition of voting disk 9f457e5961804fbabf20c7a7a2cc3304.
50.Successfully replaced voting disk group with +OCRDG.
51.CRS-4256: Updating the profile
52.CRS-4266: Voting file(s) successfully replaced
53.## STATE File Universal Id File Name Disk group
54.-- -- ---- ----
55. 1. ONLINE 017fc3cc7d164fb5bf872733c61934dd (/dev/asmdisks/asmdisk03) [OCRDG]
56. 2. ONLINE 6a40f886828b4f36bfedfadafd0274a1 (/dev/asmdisks/asmdisk01) [OCRDG]
57. 3. ONLINE 9f457e5961804fbabf20c7a7a2cc3304 (/dev/asmdisks/asmdisk02) [OCRDG]
58.Located 3 voting disk(s).
59.2019/05/09 18:15:27 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
60.2019/05/09 18:16:37 CLSRSC-343: Successfully started Oracle Clusterware stack
61.2019/05/09 18:16:37 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
62.2019/05/09 18:18:35 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
63.2019/05/09 18:19:13 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
節點2
1.
[root@ydb02 ~]# /opt/oracle/oraInventory/orainstRoot.sh
2.Changing permissions of /opt/oracle/oraInventory.
3.Adding read,write permissions for group.
4.Removing read,write,execute permissions for world.
5.
6.Changing groupname of /opt/oracle/oraInventory to oinstall.
7.The execution of the script is complete.
8.[root@ydb02 ~]#
9.[root@ydb02 ~]# /opt/oracle/ghome/root.sh
10.Check /opt/oracle/ghome/install/root_ydb02_2019-05-09_18-21-00-812198655.log for the output of root script
日誌如下
1.[root@ydb02 ~]# tail -1000f /opt/oracle/ghome/install/root_ydb02_2019-05-09_18-21-00-812198655.log
2.Performing root user operation.
3.
4.The following environment variables are set as:
5. ORACLE_OWNER= grid
6. ORACLE_HOME= /opt/oracle/ghome
7. Copying dbhome to /usr/local/bin ...
8. Copying oraenv to /usr/local/bin ...
9. Copying coraenv to /usr/local/bin ...
10.
11.Entries will be added to the /etc/oratab file as needed by
12.Database Configuration Assistant when a database is created
13.Finished running generic part of root script.
14.Now product-specific root actions will be performed.
15.Relinking oracle with rac_on option
16.Using configuration parameter file: /opt/oracle/ghome/crs/install/crsconfig_params
17.The log of current session can be found at:
18. /opt/oracle/gbase/crsdata/ydb02/crsconfig/rootcrs_ydb02_2019-05-09_06-21-38PM.log
19.2019/05/09 18:21:44 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
20.2019/05/09 18:21:45 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
21.2019/05/09 18:21:45 CLSRSC-363: User ignored prerequisites during installation
22.2019/05/09 18:21:45 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
23.2019/05/09 18:21:46 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
24.2019/05/09 18:21:46 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
25.2019/05/09 18:21:47 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
26.2019/05/09 18:21:47 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
27.2019/05/09 18:21:51 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
28.2019/05/09 18:21:51 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
29.2019/05/09 18:22:01 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
30.2019/05/09 18:22:01 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
31.2019/05/09 18:22:04 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
32.2019/05/09 18:22:05 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
33.2019/05/09 18:22:19 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
34.2019/05/09 18:22:54 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
35.2019/05/09 18:22:56 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
36.2019/05/09 18:23:57 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
37.2019/05/09 18:23:59 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
38.2019/05/09 18:24:11 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
39.2019/05/09 18:25:51 CLSRSC-343: Successfully started Oracle Clusterware stack
40.2019/05/09 18:25:51 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
41.2019/05/09 18:26:30 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
42.2019/05/09 18:26:41 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
2.6.集群ConfigTools在節點1執行
1.
[grid@ydb01 ~]$ ${ORACLE_HOME}/gridSetup.sh -silent -executeConfigTools -waitforcompletion \
2.> -responseFile ${ORACLE_HOME}/install/response/gridsetup.rsp \
3.> INVENTORY_LOCATION=/opt/oracle/oraInventory \
4.> SELECTED_LANGUAGES=en,en_GB \
5.> oracle.install.option=CRS_CONFIG \
6.> ORACLE_BASE=/opt/oracle/gbase \
7.> oracle.install.asm.OSDBA=asmdba \
8.> oracle.install.asm.OSASM=asmadmin \
9.> oracle.install.asm.OSOPER=asmoper \
10.> oracle.install.crs.config.scanType=LOCAL_SCAN \
11.> oracle.install.crs.config.gpnp.scanName=ydb-scan \
12.> oracle.install.crs.config.gpnp.scanPort=1521 \
13.> oracle.install.crs.config.ClusterConfiguration=STANDALONE \
14.> oracle.install.crs.config.configureAsExtendedCluster=false \
15.> oracle.install.crs.config.clusterName=ora19c-cluster \
16.> oracle.install.crs.config.gpnp.configureGNS=false \
17.> oracle.install.crs.config.autoConfigureClusterNodeVIP=false \
18.> oracle.install.crs.config.clusterNodes=ydb01:ydb01-vip:HUB,ydb02:ydb02-vip:HUB \
19.> oracle.install.crs.config.networkInterfaceList=ens34:192.168.10.0:1,ens35:172.16.16.0:5,ens36:172.16.16.0:5 \
20.> oracle.install.asm.configureGIMRDataDG=false \
21.> oracle.install.crs.config.useIPMI=false \
22.> oracle.install.asm.storageOption=ASM \
23.> oracle.install.asmOnNAS.configureGIMRDataDG=false \
24.> oracle.install.asm.SYSASMPassword=Oracle_2019 \
25.> oracle.install.asm.diskGroup.name=OCRDG \
26.> oracle.install.asm.diskGroup.redundancy=NORMAL \
27.> oracle.install.asm.diskGroup.AUSize=4 \
28.> oracle.install.asm.diskGroup.disksWithFailureGroupNames=/dev/asmdisks/asmdisk01,,/dev/asmdisks/asmdisk02,,/dev/asmdisks/asmdisk03, \
29.> oracle.install.asm.diskGroup.disks=/dev/asmdisks/asmdisk01,/dev/asmdisks/asmdisk02,/dev/asmdisks/asmdisk03 \
30.> oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asmdisks/* \
31.> oracle.install.asm.configureAFD=false \
32.> oracle.install.asm.monitorPassword=Oracle_2019 \
33.> oracle.install.crs.configureRHPS=false \
34.> oracle.install.crs.config.ignoreDownNodes=false \
35.> oracle.install.config.managementOption=NONE \
36.> oracle.install.config.omsPort=0 \
37.> oracle.install.crs.rootconfig.executeRootScript=false \
38.>
39.Launching Oracle Grid Infrastructure Setup Wizard...
40.
41.You can find the logs of this session at:
42./opt/oracle/oraInventory/logs/GridSetupActions2019-05-09_06-31-24PM
43.
44.You can find the log of this install session at:
45. /opt/oracle/oraInventory/logs/UpdateNodeList2019-05-09_06-31-24PM.log
46.Configuration failed.
47.[WARNING] [INS-43080] Some of the configuration assistants failed, were cancelled or skipped.
48. ACTION: Refer to the logs or contact Oracle Support Services.
49.[grid@ydb01 ~]$
集群狀態如下
1.[grid@ydb01 ~]$ crsctl query crs activeversion
2.Oracle Clusterware active version on the cluster is [19.0.0.0.0]
3.[grid@ydb01 ~]$ crsctl check crs
4.CRS-4638: Oracle High Availability Services is online
5.CRS-4537: Cluster Ready Services is online
6.CRS-4529: Cluster Synchronization Services is online
7.CRS-4533: Event Manager is online
8.[grid@ydb01 ~]$ crsctl status res -t
9.
10.Name Target State Server State details
11.
12.Local Resources
13.
14.ora.LISTENER.lsnr
15. ONLINE ONLINE ydb01 STABLE
16. ONLINE ONLINE ydb02 STABLE
17.ora.chad
18. ONLINE ONLINE ydb01 STABLE
19. ONLINE ONLINE ydb02 STABLE
20.ora.net1.network
21. ONLINE ONLINE ydb01 STABLE
22. ONLINE ONLINE ydb02 STABLE
23.ora.ons
24. ONLINE ONLINE ydb01 STABLE
25. ONLINE ONLINE ydb02 STABLE
26.ora.proxy_advm
27. OFFLINE OFFLINE ydb01 STABLE
28. OFFLINE OFFLINE ydb02 STABLE
29.
30.Cluster Resources
31.
32.ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
33. 1 ONLINE ONLINE ydb01 STABLE
34. 2 ONLINE ONLINE ydb02 STABLE
35. 3 OFFLINE OFFLINE STABLE
36.ora.LISTENER_SCAN1.lsnr
37. 1 ONLINE ONLINE ydb01 STABLE
38.ora.OCRDG.dg(ora.asmgroup)
39. 1 ONLINE ONLINE ydb01 STABLE
40. 2 ONLINE ONLINE ydb02 STABLE
41. 3 OFFLINE OFFLINE STABLE
42.ora.asm(ora.asmgroup)
43. 1 ONLINE ONLINE ydb01 Started,STABLE
44. 2 ONLINE ONLINE ydb02 Started,STABLE
45. 3 OFFLINE OFFLINE STABLE
46.ora.asmnet1.asmnetwork(ora.asmgroup)
47. 1 ONLINE ONLINE ydb01 STABLE
48. 2 ONLINE ONLINE ydb02 STABLE
49. 3 OFFLINE OFFLINE STABLE
50.ora.cvu
51. 1 ONLINE ONLINE ydb01 STABLE
52.ora.qosmserver
53. 1 ONLINE ONLINE ydb01 STABLE
54.ora.scan1.vip
55. 1 ONLINE ONLINE ydb01 STABLE
56.ora.ydb01.vip
57. 1 ONLINE ONLINE ydb01 STABLE
58.ora.ydb02.vip
59. 1 ONLINE ONLINE ydb02 STABLE
60.
61.[grid@ydb01 ~]$
2.7.安裝後檢查1.
[grid@ydb01 ~]$ $ORACLE_HOME/runcluvfy.sh stage -post crsinst -n "ydb01,ydb02" -verbose
2...............
3...............
4...............
5.Post-check for cluster services setup was unsuccessful.
6.Checks did not pass for the following nodes:
7. ydb02,ydb01
8.
9.Failures were encountered during execution of CVU verification request "stage -post crsinst".
10.
11.Verifying Single Client Access Name (SCAN) ...FAILED
12.PRVG-11372 : Number of SCAN IP addresses that SCAN "ydb-scan" resolved to did
13.not match the number of SCAN VIP resources
14. Verifying DNS/NIS name service 'ydb-scan' ...FAILED
15. PRVG-1101 : SCAN name "ydb-scan" failed to resolve
16.
17.CVU operation performed: stage -post crsinst
18.Date: May 9, 2019 6:37:30 PM
19.CVU home: /opt/oracle/ghome/
20.User: grid
21.[grid@ydb01 ~]$
三.安裝部署database3.1.解壓軟體1.mkdir -p $ORACLE_HOME
2.unzip LINUX.X64_193000_db_home.zip -d $ORACLE_HOME
3.2.配置互信1.
$ORACLE_HOME/oui/prov/resources/scripts/sshUserSetup.sh -user oracle -hosts "ydb01 ydb02" -advanced -noPromptPassphrase
2.
3.[oracle@ydb01 scripts]$ ssh ydb02 date
4.Thu May 9 20:34:44 CST 2019
5.[oracle@ydb01 scripts]$ ssh ydb02-priv1 date
6.Thu May 9 20:34:51 CST 2019
7.[oracle@ydb01 scripts]$ ssh ydb02-priv2 date
8.Thu May 9 20:34:58 CST 2019
9.[oracle@ydb01 scripts]$ ssh ydb01 date
10.Thu May 9 20:35:02 CST 2019
11.[oracle@ydb01 scripts]$ ssh ydb01-priv1 date
12.Thu May 9 20:35:11 CST 2019
13.[oracle@ydb01 scripts]$ ssh ydb01-priv2 date
14.Thu May 9 20:35:17 CST 2019
3.3.安裝前檢查1.
[oracle@ydb01 ~]$ /opt/oracle/ghome/runcluvfy.sh stage -pre dbinst -n "ydb01,ydb02" -verbose
2.......................
3.......................
4.......................
5.Failures were encountered during execution of CVU verification request "stage -pre dbinst".
6.
7.Verifying resolv.conf Integrity ...FAILED
8.ydb02: PRVF-5636 : The DNS response time for an unreachable node exceeded
9. "15000" ms on following nodes: ydb01,ydb02
10.
11.ydb01: PRVF-5636 : The DNS response time for an unreachable node exceeded
12. "15000" ms on following nodes: ydb01,ydb02
13.
14.Verifying Single Client Access Name (SCAN) ...FAILED
15.PRVG-11372 : Number of SCAN IP addresses that SCAN "ydb-scan" resolved to did
16.not match the number of SCAN VIP resources
17.
18. Verifying DNS/NIS name service 'ydb-scan' ...FAILED
19. PRVG-1101 : SCAN name "ydb-scan" failed to resolve
20.
21.Verifying Maximum locked memory check ...FAILED
22.ydb02: PRVE-0042 : Maximum locked memory "HARD" limit when automatic memory
23. management is enabled is less than the recommended value in the file
24. "/etc/security/limits.conf" [Expected = "3145728", Retrieved="-1"] on
25. node "ydb02"
26.
27.ydb01: PRVE-0042 : Maximum locked memory "HARD" limit when automatic memory
28. management is enabled is less than the recommended value in the file
29. "/etc/security/limits.conf" [Expected = "3145728", Retrieved="-1"] on
30. node "ydb01"
31.
32.
33.CVU operation performed: stage -pre dbinst
34.Date: May 9, 2019 8:41:25 PM
35.CVU home: /opt/oracle/ghome/
36.User: oracle
3.4.安裝database軟體1.
[oracle@ydb01 ~]$ ${ORACLE_HOME}/runInstaller -ignorePrereq -waitforcompletion -silent \
2.> -responseFile ${ORACLE_HOME}/install/response/db_install.rsp \
3.> oracle.install.option=INSTALL_DB_SWONLY \
4.> ORACLE_HOSTNAME=/opt/oracle/oraInventory \
5.> UNIX_GROUP_NAME=oinstall \
6.> INVENTORY_LOCATION=/opt/oracle/oraInventory \
7.> SELECTED_LANGUAGES=en,en_GB \
8.> ORACLE_HOME=/opt/oracle/dbbase/19c/db_1 \
9.> ORACLE_BASE=/opt/oracle/dbbase \
10.> oracle.install.db.InstallEdition=EE \
11.> oracle.install.db.OSDBA_GROUP=dba \
12.> oracle.install.db.OSOPER_GROUP=oper \
13.> oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
14.> oracle.install.db.OSDGDBA_GROUP=dgdba \
15.> oracle.install.db.OSKMDBA_GROUP=kmdba \
16.> oracle.install.db.OSRACDBA_GROUP=racdba\
17.> oracle.install.db.CLUSTER_NODES=ydb01,ydb02 \
18.> oracle.install.db.isRACOneInstall=false \
19.> oracle.install.db.rac.serverpoolCardinality=0 \
20.> oracle.install.db.config.starterdb.type=GENERAL_PURPOSE \
21.> oracle.install.db.ConfigureAsContainerDB=false \
22.> SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
23.> DECLINE_SECURITY_UPDATES=true \
24.>
25.Launching Oracle Database Setup Wizard...
26.
27.[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
28. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /opt/oracle/oraInventory/logs/InstallActions2019-05-09_09-00-49PM/installActions2019-05-09_09-00-49PM.log
29. ACTION: Identify the list of failed prerequisite checks from the log: /opt/oracle/oraInventory/logs/InstallActions2019-05-09_09-00-49PM/installActions2019-05-09_09-00-49PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
30.The response file for this session can be found at:
31. /opt/oracle/dbbase/19c/db_1/install/response/db_2019-05-09_09-00-49PM.rsp
32.
33.You can find the log of this install session at:
34. /opt/oracle/oraInventory/logs/InstallActions2019-05-09_09-00-49PM/installActions2019-05-09_09-00-49PM.log
35.
36.As a root user, execute the following script(s):
37. 1. /opt/oracle/dbbase/19c/db_1/root.sh
38.
39.Execute /opt/oracle/dbbase/19c/db_1/root.sh on the following nodes:
40.[ydb01, ydb02]
41.
42.
43.Successfully Setup Software with warning(s).
44.[oracle@ydb01 ~]$
四.創建資料庫4.1.普通資料庫1.dbca -silent -createDatabase \
2. -templateName General_Purpose.dbc \
3. -gdbname emrep -responseFile NO_VALUE \
4. -characterSet AL32UTF8 \
5. -sysPassword Oracle_2019 \
6. -systemPassword Oracle_2019 \
7. -createAsContainerDatabase false \
8. -databaseType MULTIPURPOSE \
9. -automaticMemoryManagement false \
10. -totalMemory 1024 \
11. -redoLogFileSize 50 \
12. -emConfiguration NONE \
13. -ignorePreReqs \
14. -nodelist ydb01,ydb02 \
15. -storageType ASM \
16. -diskGroupName +DATADG \
17. -asmsnmpPassword Oracle_2019 \
18. -recoveryAreaDestination NONE \
19.
1.dbca -silent -createDatabase \
2. -templateName General_Purpose.dbc \
3. -gdbname emrep -responseFile NO_VALUE \
4. -characterSet AL32UTF8 \
5. -sysPassword Oracle_2019 \
6. -systemPassword Oracle_2019 \
7. -createAsContainerDatabase true \
8. -numberOfPDBs 1 \
9. -pdbName yong \
10. -pdbAdminPassword Oracle_2019 \
11. -databaseType MULTIPURPOSE \
12. -automaticMemoryManagement false \
13. -totalMemory 1024 \
14. -redoLogFileSize 50 \
15. -emConfiguration NONE \
16. -ignorePreReqs \
17. -nodelist ydb01,ydb02 \
18. -storageType ASM \
19. -diskGroupName +DATADG \
20. -asmsnmpPassword Oracle_2019 \
21. -recoveryAreaDestination NONE \
22.
至此部署完畢！