草庐IT

19c rac 安装实践

李石岩 2023-03-28 原文
集群安装实践

1. 集群软件配置规范

（1）基本说明

 

数据库安装包：LINUX.X64_193000_db_home.zip

集群安装包：LINUX.X64_193000_grid_home.zip

Grid用户，将LINUX.X64_193000_grid_home.zip放置于/grid目录：

集群安装包验证： sha256sum LINUX.X64_193000_grid_home.zip

d668002664d9399cf61eb03c0d1e3687121fc890b1ddd50b35dcbe13c5307d2e  LINUX.X64_193000_grid_home.zip

Oracle用户,将LINUX.X64_193000_db_home.zip放置于/oracle目录：

数据库安装包验证： sha256sum LINUX.X64_193000_db_home.zip

ba8329c757133da313ed3b6d7f86c5ac42cd9970a28bf2e6233f3235233aa8d8  LINUX.X64_193000_db_home.zip

项目

要求

检查命令

RAM

至少8G

# grep MemTotal /proc/meminfo

运行级别

3 or 5

# runlevel

Linux版本

Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 4:

4.1.12-112.16.7.el7uek.x86_64 or later

Oracle Linux 7.4 with the Unbreakable Enterprise Kernel 5:

4.14.35-1818.1.6.el7uek.x86_64 or later

Oracle Linux 7.4 with the Red Hat Compatible kernel:

3.10.0-693.5.2.0.1.el7.x86_64 or later

• Red Hat Enterprise Linux 7.4: 3.10.0-693.5.2.0.1.el7.x86_64

or later

• SUSE Linux Enterprise Server 12 SP3: 4.4.103-92.56-default

or later

 

# uname -mr

# cat /etc/redhat-release

 

/tmp

至少1G

# du -h /tmp

swap

SWAP Between 4 GB and 16 GB: Equal to RAM 

More than 16 GB: 16 GB，如果启用了Huge Page，则计算SWAP需要减去分配给HugePage的内存。

# grep SwapTotal /proc/meminfo

 

/dev/shm

检查/dev/shm挂载类型，以及权限。

# df -h /dev/shm

软件空间要求

grid至少12G，Oracle至少10g空间，建议分配100g预留

19c开始GIMR在standalone安装时变为可选项。

# df -h /u01

 

用户

操作系统

IP地址

VIP

SCANIP

心跳

root信息

Oracleroot

配置

主机名

Oracle RAC

Oracle Linx7.8

192.168.26.3

192.168.26.11

192.168.26.7

10.10.10.115

 

 

 

psbcdb19cr1

192.168.26.5

192.168.26.21

192.168.26.7

10.10.10.116

 

 

 

psbcdb19cr2

ASM存储

Oracle Linx7.8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

/etc/hosts 文件内容如下：

 

#public ip

192.168.26.10  psbcdb19cr1

192.168.26.20  psbcdb19cr2

#virtual ip

192.168.26.11  psbcdb19cr1-vip

192.168.26.21  psbcdb19cr2-vip

#scan ip

192.168.26.7  psbcdb-cluster-scan

 

#private ip

10.10.10.115    psbcdb19cr1-priv

10.10.10.116    psbcdb19cr2-priv

 

（2）安装目录规范

 

安装目录的规范原则是创建/oracle /grid文件系统。用来安装Oracle数据库软件的安装，基于本地存储新建文件系统，大小各为200G。

Oracle Base目录：/oracle/

Oracle Grid目录：/grid/grid_base、/grid/grid_home

Oracle Home目录：/oracle/db19c

 

（3）磁盘配置规范

ASM磁盘名称

ASM磁盘单个容量（GB）

ASM磁盘个数

用户与组的属性

用途说明

CRSDG

5G

5

grid:asmadmin

OCR(集群注册表)：维护集群的配置信息和集群中的数据库的配置信息

DGDATA01

200G

10

grid:asmadmin

用于存放数据库实例数据文件

DGARCH

200G

3

grid:asmadmin

用于存放归档日志

DGSYS

200G

3

grid:asmadmin

存放联机重做日志

 

（4）网络配置规范

IP地址

主机名

网卡名

用途说明

192.168.26.10

psbcdb19cr1

eth0

Public-ip（bond0）

192.168.26.20

psbcdb19cr2

eth0

10.10.10.115

psbcdb19cr1-priv

eth1

Private-ip(bond1)

10.10.10.116

psbcdb19cr2-priv

eth1

192.168.26.11

psbcdb19cr1-vip

/

Virtual-ip

192.168.26.21

psbcdb19cr2-vip

/

192.168.26.7

psbcdb-cluster-scan

/

Scan-ip

 

2. 操作系统配置规范

（1）系统硬件环境检查

[root@psbcdb19cr2 dev]# grep MemTotal /proc/meminfo

MemTotal:       32765892 kB

[root@psbcdb19cr2 dev]# grep SwapTotal /proc/meminfo

SwapTotal:       8388604 kB

[root@psbcdb19cr2 dev]# df -Th /tmp

Filesystem              Type  Size  Used Avail Use% Mounted on

/dev/mapper/asianux-tmp xfs    20G   33M   20G   1% /tmp

[root@psbcdb19cr2 dev]# date -R

Mon, 26 Jul 2021 23:56:55 +0800

[root@psbcdb19cr2 dev]# uname -m

x86_64

[root@psbcdb19cr2 dev]#

（2）关闭NetworkManager

[root@psbcdb19cr2 dev]# systemctl stop NetworkManager

[root@psbcdb19cr2 dev]# systemctl disable NetworkManager

[root@psbcdb19cr2 dev]# systemctl status NetworkManager

● NetworkManager.service - Network Manager

   Loaded: loaded (/usr/lib/systemd/system/NetworkManager.service; disabled; vendor preset: enabled)

   Active: inactive (dead)

     Docs: man:NetworkManager(8)

（3）操作系统依赖包检查

yum -y install openssh                                                   \

bc   \

binutils   \

compat-libcap1   \

compat-libstdc++   \

elfutils-libelf   \

elfutils-libelf-devel   \

fontconfig-devel   \

glibc   \

glibc-devel   \

ksh   \

libaio   \

libaio-devel   \

libX11   \

libXau   \

libXi   \

libXtst   \

libXrender   \

libXrender-devel   \

libgcc   \

librdmacm-devel   \

libstdc++   \

libstdc++-devel   \

libxcb   \

make   \

net-tools   \

nfs-utils   \

python   \

python-configshell   \

python-rtslib   \

python-six   \

targetcli   \

smartmontools   \

sysstat \

mod \

Compat-libstdc++33 \

（4）禁用selinux

getenforce

cat /etc/selinux/config

手工修改

/etc/selinux/config SELINUX=disabled，

或使用下面命令：

sed -i '/^SELINUX=.*/ s//SELINUX=disabled/' /etc/selinux/config

setenforce 0

 

 

（5）关闭透明大页

[root@psbcdb19cr1 ~]# grep AnonHugePages /proc/meminfo

AnonHugePages:         0 kB

[root@psbcdb19cr1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled

always madvise [never]

 <!--never表是已经关闭-->

（6）关闭防火墙

各节点关闭防火墙:

systemctl list-unit-files|grep firewalld

systemctl status firewalld

 

systemctl disable firewalld

systemctl stop firewalld

（7）关闭Chrony服务

 

各节点系统时间校对:

--检验时间和时区确认正确

date

 

--关闭chrony服务，移除chrony配置文件（后续使用ctss）

systemctl list-unit-files|grep chronyd

systemctl status chronyd

 

systemctl disable chronyd

systemctl stop chronyd

 

mv /etc/chrony.conf /etc/chrony.conf_bak

这里实验环境，选择不使用NTP和chrony，这样Oracle会自动使用自己的ctss服务。

（8）关闭NUMA

<!--查看default grub的入口信息-->

[root@psbcdb19cr1 ~]# grubby --default-kernel

/boot/vmlinuz-3.10.0-514.axs7.x86_64

<!--查看default grub的具体信息-->

[root@psbcdb19cr1 ~]# grubby --info /boot/vmlinuz-3.10.0-514.axs7.x86_64

index=0

kernel=/boot/vmlinuz-3.10.0-514.axs7.x86_64

args="ro crashkernel=auto rd.lvm.lv=asianux/root rd.lvm.lv=asianux/swap net.ifnames=0 biosdevname=0 rhgb quiet transparent_hugepage=never "

root=/dev/mapper/asianux-root

initrd=/boot/initramfs-3.10.0-514.axs7.x86_64.img

title=Asianux Server 7 (Lotus), with Linux 3.10.0-514.axs7.x86_64

<!--更新args,添加numa=off的参数-->

[root@psbcdb19cr1 ~]# grubby --args=numa=off --update-kernel /boot/vmlinuz-3.10.0-514.axs7.x86_64

<!--确认numa=off加入default grub中-->

[root@psbcdb19cr1 ~]# grubby --info /boot/vmlinuz-3.10.0-514.axs7.x86_64

index=0

kernel=/boot/vmlinuz-3.10.0-514.axs7.x86_64

args="ro crashkernel=auto rd.lvm.lv=asianux/root rd.lvm.lv=asianux/swap net.ifnames=0 biosdevname=0 rhgb quiet transparent_hugepage=never numa=off"

root=/dev/mapper/asianux-root

initrd=/boot/initramfs-3.10.0-514.axs7.x86_64.img

title=Asianux Server 7 (Lotus), with Linux 3.10.0-514.axs7.x86_64

<!--重启服务器-->

（9）创建用户和组

 

创建group & user，给oracle、grid设置密码：

 

groupadd -g 54321 oinstall  

groupadd -g 54322 dba  

groupadd -g 54323 oper  

groupadd -g 54324 backupdba  

groupadd -g 54325 dgdba  

groupadd -g 54326 kmdba  

groupadd -g 54327 asmdba  

groupadd -g 54328 asmoper  

groupadd -g 54329 asmadmin  

groupadd -g 54330 racdba  

  

useradd -u 54321 -g oinstall -G oinstall,dba,asmdba,backupdba,dgdba,kmdba,racdba,oper -d /home/oracle -s /bin/bash oracle  

useradd -u 54322 -g oinstall -G oinstall,racdba,asmadmin,asmdba,asmoper,dba -m -d /home/grid grid

 

echo oracle | passwd --stdin oracle

echo oracle | passwd --stdin grid

 

 

（10）设置目录

各节点创建安装目录

各节点创建安装目录(root用户)：

mkdir -p /grid/grid_base

mkdir -p /grid/grid_home

mkdir -p /grid/oraInventory

mkdir -p /oracle/db19c

chown -R grid:oinstall /grid

chown oracle:oinstall /oracle

chmod -R 775 /oracle

chmod -R 775 /grid

 

（11）用户变量设置

各节点设置用户的环境变量

第1个节点grid用户：

 

EDITOR=vi

export EDITOR

export PS1=`whoami`@`hostname`\['$ORACLE_SID'\]'$PWD$'

umask 022

export ORACLE_SID=+ASM1

export ORACLE_BASE=/grid/grid_base

export ORACLE_HOME=/grid/grid_home

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/rdbms/jlib

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

echo ' '

echo '$ORACLE_SID: '$ORACLE_SID

echo '$ORACLE_HOME: '$ORACLE_HOME

echo ' '

 

 

第2个节点grid用户：

 

EDITOR=vi

export EDITOR

export PS1=`whoami`@`hostname`\['$ORACLE_SID'\]'$PWD$'

umask 022

export ORACLE_SID=+ASM2

export ORACLE_BASE=/grid/grid_base

export ORACLE_HOME=/grid/grid_home

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_TERM=xterm

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/rdbms/jlib

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

echo ' '

echo '$ORACLE_SID: '$ORACLE_SID

echo '$ORACLE_HOME: '$ORACLE_HOME

echo ' '

 

 

 

 

第1个节点oracle用户：

 

EDITOR=vi

export EDITOR

export PS1=`whoami`@`hostname`\['$ORACLE_SID'\]'$PWD$'

umask 022

export ORACLE_SID=psbcdb19cr1

export ORACLE_BASE=/oracle

export GRID_HOME=/grid/grid_home

export ORACLE_HOME=$ORACLE_BASE/db19c

export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export ORACLE_OWNER=oracle

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

echo ' '

echo '$ORACLE_SID: '$ORACLE_SID

echo '$ORACLE_HOME: '$ORACLE_HOME

echo ' '

 

第2个节点oracle用户：

 

EDITOR=vi

export EDITOR

export PS1=`whoami`@`hostname`\['$ORACLE_SID'\]'$PWD$'

umask 022

export ORACLE_SID=psbcdb19cr2

export ORACLE_BASE=/oracle

export GRID_HOME=/grid/grid_home

export ORACLE_HOME=$ORACLE_BASE/db19c

export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export ORACLE_OWNER=oracle

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

echo ' '

echo '$ORACLE_SID: '$ORACLE_SID

echo '$ORACLE_HOME: '$ORACLE_HOME

echo ' '

 

添加root用户环境变量：

 

export GRID_HOME=/grid/grid_home

export PATH=$GRID_HOME/bin:$PATH

 

修改用户资源限制，以root用户登录操作系统，命令如下：

 

 

oracle soft nproc 16384

oracle hard nproc 16384

oracle soft nofile 65536

oracle hard nofile 65536

oracle soft memlock unlimited

oracle hard memlock unlimited

oracle soft stack 10240

oracle hard stack 32768

 

grid soft nproc 16384

grid hard nproc 16384

grid soft nofile 65536

grid hard nofile 65536

grid soft memlock unlimited

grid hard memlock unlimited

grid soft stack 10240

grid hard stack 32768

 

这些参数设置后会立即生效，但需注意，当前已登录再系统的oracle，grid，需要重新登录系统，修改才会生效

下面以oracle用户重新登录系统为例，检查命令及结果如下：

[root@psbcdb19cr1 ~]# vim /etc/security/limits.conf

[root@psbcdb19cr1 ~]# ulimit -a

core file size          (blocks, -c) 0

data seg size           (kbytes, -d) unlimited

scheduling priority             (-e) 0

file size               (blocks, -f) unlimited

pending signals                 (-i) 192371

max locked memory       (kbytes, -l) 64

max memory size         (kbytes, -m) unlimited

open files                      (-n) 1024

pipe size            (512 bytes, -p) 8

POSIX message queues     (bytes, -q) 819200

real-time priority              (-r) 0

stack size              (kbytes, -s) 8192

cpu time               (seconds, -t) unlimited

max user processes              (-u) 192371

virtual memory          (kbytes, -v) unlimited

file locks                      (-x) unlimited

 

（12）操作系统参数调整

vim /etc/sysctl.conf

 

net.ipv4.conf.all.accept_redirects = 0

net.ipv4.ip_local_port_range = 30000 61000

kernel.shmall = 7077888

kernel.shmmax = 28991029248

kernel.shmmni = 4096

kernel.sem = 250 32000 100 1284

fs.file-max = 8388608

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=4194304

net.core.rmem_max = 4194304

net.core.wmem_default=4194304

net.core.wmem_max = 4194304

fs.aio-max-nr = 262144

 

vm.nr_hugepages=14336

vm.hugetlb_shm_group =501

vm.swappiness =100

 

net.ipv4.tcp_max_syn_backlog=8196

net.core.netdev_max_backlog=8096

 

net.ipv4.tcp_keepalive_intvl=30

net.ipv4.tcp_fin_timeout=30

 

net.ipv4.tcp_retries2=5

net.ipv4.tcp_keepalive_probes=3

net.ipv4.tcp_tw_reuse=1

net.core.somaxconn=4096

net.ipv4.tcp_keepalive_time=1880

 

 

 

配置后sysctl -p

（13）设置大页

若操作系统内存大于32G，则建议开启大页，具体参照Linux内存大页配置部分。

# 查看透明大页面是否开启

# cat /sys/kernel/mm/transparent_hugepage/enabled

[always] madvise never

# 查看透明大页面整理碎片功能是否开启，THP defragmentation

# cat /sys/kernel/mm/transparent_hugepage/defrag   

[always] madvise never

 

将"transparent_hugepage=never"内核参数追加到GRUB_CMDLINE_LINUX选项后：

# vi /etc/default/grub

GRUB_CMDLINE_LINUX="rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap ... 

transparent_hugepage=never"

 

备份/boot/grub2/grub.cfg，通过grub2-mkconfig -o命令重建/boot/grub2/grub.cfg文件：

# grub2-mkconfig -o /boot/grub2/grub.cfg

# grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg

 

重启系统：

# shutdown -r now

验证参数设置是否正确：

# cat /proc/cmdline

 

注：如果还没有关闭THP，以下步骤提供关闭方案

If Transparent Huge Pages (THP) is still not disabled, continue and use one of the options below.

 

Option 1: (Recommended) create a customized tuned profile with disabled THP

 

With this resolution we will create a customized version of the currently running profile. The customized version

 

will disable THP.

 

Find out which profile is active, create a copy. In the following example we currently use

 

the throughput-performance profile:

 

# tuned-adm active

Current active profile: throughput-performance

 

To create customized profile, create a new directory in /etc/tuned directory with desired profile name.

 

# mkdir /etc/tuned/myprofile-nothp

Then create a new tuned.conf file for myprofile-nothp, and insert the new tuning info:

 

 

# cat /etc/tuned/myprofile-nothp/tuned.conf

[main]

include= throughput-performance

[vm]

transparent_hugepages=never

Make the script executable:

 

# chmod +x /etc/tuned/myprofile-nothp/tuned.conf

Enable myprofile like so:

 

# tuned-adm profile myprofile-nothp

This change will immediately take effect and persist reboots.

 

To verify if THP are disabled or not, run below command:

 

# cat /sys/kernel/mm/transparent_hugepage/enabled

Option 2: (Alternative) Disable tuned services

 

This resolution will disable the tuned services.

 

 

# systemctl stop tuned

# systemctl disable tuned

OR

 

# tuned-adm off

Now add "transparent_hugepage=never" kernel parameter in grub2 configuration file as explained in steps 1-3

 

above.

 

Reboot the server for changes to take effect.

 

 

开启大页面：

# vim /etc/sysctl.conf

vm.nr_hugepages = xxxx

 

# sysctl -p

vim /etc/security/limits.conf

oracle soft memlock xxxxxxxxxxx

oracle hard memlock xxxxxxxxxxx

3. GI软件安装

（1）创建软件安装目录

mkdir -p /grid/grid_base

mkdir -p /grid/grid_home

chown -R grid.oinstall /grid

chmod -R 775 /grid

 

 

mkdir -p /oracle/db19c

chown -R oracle.oinstall /oracle

chmod -R 775 /oracle

（2）解压软件包

仅在节点1上执行，命令如下：

su - grid

cd /grid/

unzip LINUX.X64_193000_grid_home.zip -d $ORACLE_HOME

（3）安装cvuqdisk软件包

su -

cd $GRID_HOME/cv/rpm

export CVUQDISK_GRP=oinstall

rpm -ivh cvuqdisk-1.0.10-1.rpm

rpm -q cvuqdisk

（4）配置磁盘权限

配置udev,设置磁盘权限，命令如下：

 

[root@psbcdb19cr1 ~]# cat /etc/udev/rules.d/99-oracle-asmdevices.rules

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552304d6d584f582d496a77752d62713844", SYMLINK+="asm-diskb", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552626e4d6656452d715467592d6a4c586d", SYMLINK+="asm-diskc", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c455242656f6a66782d757a754b2d577a4d48", SYMLINK+="asm-diskd", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552306530714e632d356753612d79706143", SYMLINK+="asm-diske", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45524c504d4f4b572d374d6e6a2d45397673", SYMLINK+="asm-diskf", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45526363736662632d4f6679782d356b3047", SYMLINK+="asm-diskg", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45524548626162762d4f744f382d656a6c33", SYMLINK+="asm-diskh", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45523876695434462d6d454a532d34524f56", SYMLINK+="asm-diski", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552644664524f512d576776692d67777a67", SYMLINK+="asm-diskj", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45526e66616579312d554e56652d63376c42", SYMLINK+="asm-diskk", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552634e316c67422d394c6a392d6d717149", SYMLINK+="asm-diskl", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45523137367443322d4a576d722d657a6d79", SYMLINK+="asm-diskm", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552457a574c4d712d55456c572d66336e36", SYMLINK+="asm-diskn", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45526f51683344432d616575762d70776131", SYMLINK+="asm-disko", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c4552454c52424e432d633668442d6c434e69", SYMLINK+="asm-diskp", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45525945665646492d703455432d76787645", SYMLINK+="asm-diskq", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c455239505838664c2d4153777a2d43487253", SYMLINK+="asm-diskr", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45525077444935772d694f58312d34525456", SYMLINK+="asm-disks", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c45527a4c6b386d372d56546d6e2d6a487171", SYMLINK+="asm-diskt", OWNER="grid", GROUP="asmadmin", MODE="0660"

KERNEL=="sd*", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name", RESULT=="14f504e46494c455264324a464d552d7941634e2d70786f48", SYMLINK+="asm-disku", OWNER="grid", GROUP="asmadmin", MODE="0660"

实际生产可以使用Linux自带的multipath（多路径），安装相关的RPM，基本配置如下：

device-mapper-1.02.170-6.el7.x86_64.rpm

device-mapper-event-1.02.170-6.el7.x86_64.rpm

device-mapper-event-libs-1.02.170-6.el7.x86_64.rpm

device-mapper-libs-1.02.170-6.el7.x86_64.rpm

device-mapper-multipath-0.4.9-133.el7.x86_64.rpm

device-mapper-multipath-libs-0.4.9-133.el7.x86_64.rpm

device-mapper-persistent-data-0.8.5-3.el7.x86_64.rpm

<!--启动和激活multipathd进程-->

Mpathconf --enable --with_multipathd y

在节点2上也执行同样的操作，配置完成后建议重新启动多路径软件，命令如下：

/etc/init.d/multipathd restart

 

启动完成后，系统会在/etc/下生成multipath.conf,以及在/etc/multipath下生成bingdings以及wwid，其中wwid会记录系统中所有挂载盘的唯一ID

 

 

（5）Grid软件安装

检查所有节点的配置文件/etc/oraInst.loc、/etc/oratab是否存在相关配置，或有则删除。

rm -rf /etc/oracle

rm -rf /tmp/.oracle  

rm -rf /var/tmp.oracle  

rm -rf /grid/oraInventory

ll -lrta  /grid/grid_home 清理隐藏文件

ll -lrta  /grid/grid_base 清理隐藏文件

ll -lrta  /oracle/db19c 清理隐藏文件

rm -rf /tmp/GridSetupActions*

 

 

 

使用grid用户登录节点1，执行如下命令：

​export SSH_AUTH_SOCK=0

exprot TMOUT=

cd $ORACLE_HOME

./gridSetup.sh

执行图形化安装，可以通过crsctl stat res -t命令可以检查集群状态。

 

4. 数据库软件安装

（1） 数据库选择说明

Oracle数据库版本选择19.3版本。数据库为RAC实例环境，根据项目需要安装组件。

（2） 安装Oracle数据库软件

使用runInstaller启动安装程序。Oracle用户登录节点1，执行命令如下：

cd /oracle

unzip LINUX.X64_193000_db_home.zip -d /oracle/db19c/

虚拟机中通过图形化界面安装

cd /oracle/db19c

./runInstaller

5. 数据库实例创建注意事项

（1） 数据库命名规则

 

（2） 表空间命名规则

数据和索引放在不同的表空间，建议分配固定数据文件大小31G。

（3） 应用表空间命名规则

（4） 在线日志

高并发环境redo和数据文件的I/O消耗比较大，建议redo和数据文件分开并存放与不同的磁盘，在线日志的大小初始化建议设置为2G，后期再根据每日的日志量进行调整。

（5） Oracle19c数据库参数配置

参数

建议值

备注

PGA_AGGREGATE_TARGET

物理内存*16%

OLTP:PGA_AGGREGATE_TARGET=(<总内存>*80%)*20%
OLAP:PGA_AGGREGATE_TARGET=(<总内存>*80%)*50%

SGA_TARGET/SGA_MAX_SIZE

不高于物理内存的64%

OLTP: SGA_TARGET=(<总内存>*80%)*80%
OLAP: SGA_TARGET=(<总内存>*80%)*50%

MEMORY_TARGET

0

启用大页时建议关闭

UNDO_RETENTION

86400

对于自动扩展的UNDO表空间，Oracle会根据该参数设定的阈值尽可能的保留UNDO信息时间，为86400，即1天

enable_ddl_logging

TRUE

启动DDL日志记录功能

optimizer_adaptive_plans

FALSE

仅用SQL自适应查询优化特性

parallel_force_local

TRUE

控制并行进程是否可以跨RAC节点

deferred_segment_creation

FALSE

推荐值为FALSE,即取消段延迟创建功能

_clusterwid_global_transactions

FALSE

集群范围全局事务

_datafile_write_errors_crash_instance

FALSE

防止PDB中数据文件写入异常导致整个CDB宕机

_optimizer_extended_cursor_sharing/_optimizer_extended_cursor_sharing_rel

none

避免子游标过多

_PX_use_large_pool

TRUE

将并行会话改为使用大池

_use_adaptive_log_file_sync

FALSE

控制提交时日志的写入极致

_serial_direct_read

nerver

达标倾向于直接读取路径

_use_single_log_writer

TRUE

Oracle12c引入了多日志写入进程的新特性，该新特性容易导致日志写入进程挂起

_gc_policy_time

0

关闭DRM特性，可以避免节点间频繁的重置，从而避免数据库挂起，性能不稳定等问题

_gc_undo_affinity

FALSE

 

数据库安装图1.  GI配置通过执行安装命令以后，我们通过图形化界面进行安装，选择第一项。

 

选择配置一个独立的集群

 

  

 

配置SCAN

 

  

 

注意：如果提前没有配置互信，则需要通过SSH connectivity进行setup。

 

 

 

 

由于之前进行配置过，主机名以及IP进行修改过，因此报错了，需要对root,grid,oracle的.ssh中进行清理，然后再进行设置互信。

 

GI runInstaller Fails with INS-6006 in VNC During SSH test even though SSH Setup is successful (文档 ID 2070270.1)

清理下grid中的.ssh

网络配置页面，我们采用bond0为Public-IP ,bond1为Private-IP。

其中bond1我们选择private和asm选项。

 

 我们选择ASM存储

 

 

选择No

 

选择No

 

 

创建OCR盘，High 5块

 

 

设置密码：

 

密码如果设置较为复杂，则不会出现这个INS-30011

 

 

设置复杂的密码：

 

下一步，我们选择Do

 

取消EM

 

默认：

 

默认下一步：

 

Grid_base目录

 

默认，下一步。

 

第一次安装不要点击自动安装

 

如果选择自动安装，则root密码需要输入。我们可以不选择配置，后期会手动输入。

 

 

 

告警较多，Fix&CheckAgent进行执行一次，会消去很多。

 

剩下的忽略。

 

安装页，选择安装。

 

 

 

弹出界面之后，打开root窗口，进行安装。

 

执行

[root@psbcdb19cr1 ~]# /grid/oraInventory/orainstRoot.sh

Changing permissions of /grid/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /grid/oraInventory to oinstall.

The execution of the script is complete.

[root@psbcdb19cr1 ~]# /grid/grid_home/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /grid/grid_home

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.

   Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.  

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /grid/grid_home/crs/install/crsconfig_params

The log of current session can be found at:

  /grid/grid_base/crsdata/psbcdb19cr1/crsconfig/rootcrs_psbcdb19cr1_2021-07-27_01-08-20AM.log

2021/07/27 01:08:26 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2021/07/27 01:08:26 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2021/07/27 01:08:26 CLSRSC-363: User ignored prerequisites during installation

2021/07/27 01:08:26 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2021/07/27 01:08:28 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2021/07/27 01:08:29 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2021/07/27 01:08:29 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2021/07/27 01:08:29 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2021/07/27 01:08:42 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2021/07/27 01:08:45 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2021/07/27 01:08:50 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2021/07/27 01:08:52 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2021/07/27 01:08:53 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2021/07/27 01:08:56 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2021/07/27 01:08:56 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2021/07/27 01:09:17 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2021/07/27 01:09:21 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2021/07/27 01:09:25 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2021/07/27 01:09:29 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

ASM has been created and started successfully.

[DBT-30001] Disk groups created successfully. Check /grid/grid_base/cfgtoollogs/asmca/asmca-210727AM010958.log for details.

2021/07/27 01:10:49 CLSRSC-482: Running command: '/grid/grid_home/bin/ocrconfig -upgrade grid oinstall'

CRS-4256: Updating the profile

Successful addition of voting disk fe2fc18e9b3a4f5abfa71f4905f8773a.

Successfully replaced voting disk group with +CRSDG.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   fe2fc18e9b3a4f5abfa71f4905f8773a (/dev/sdb) [CRSDG]

Located 1 voting disk(s).

2021/07/27 01:12:05 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2021/07/27 01:13:09 CLSRSC-343: Successfully started Oracle Clusterware stack

2021/07/27 01:13:09 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2021/07/27 01:14:15 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2021/07/27 01:14:38 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@psbcdb19cr1 ~]#

 

 

 

[root@psbcdb19cr2 ~]# /grid/oraInventory/orainstRoot.sh

Changing permissions of /grid/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /grid/oraInventory to oinstall.

The execution of the script is complete.

[root@psbcdb19cr2 ~]# /grid/grid_home/root.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /grid/grid_home

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  

   Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /grid/grid_home/crs/install/crsconfig_params

The log of current session can be found at:

  /grid/grid_base/crsdata/psbcdb19cr2/crsconfig/rootcrs_psbcdb19cr2_2021-07-27_01-15-29AM.log

2021/07/27 01:15:33 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2021/07/27 01:15:33 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2021/07/27 01:15:33 CLSRSC-363: User ignored prerequisites during installation

2021/07/27 01:15:33 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2021/07/27 01:15:34 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2021/07/27 01:15:35 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2021/07/27 01:15:35 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2021/07/27 01:15:35 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2021/07/27 01:15:37 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2021/07/27 01:15:37 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2021/07/27 01:15:41 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2021/07/27 01:15:42 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2021/07/27 01:15:43 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2021/07/27 01:15:43 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2021/07/27 01:15:58 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2021/07/27 01:16:04 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2021/07/27 01:16:05 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2021/07/27 01:16:06 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2021/07/27 01:16:07 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

2021/07/27 01:16:17 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2021/07/27 01:17:00 CLSRSC-343: Successfully started Oracle Clusterware stack

2021/07/27 01:17:00 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2021/07/27 01:17:18 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2021/07/27 01:17:26 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@psbcdb19cr2 ~]#

由于之前忽略了一些选项，弹出告警界面，我们选择YES

 

 

 

 

以上为安装步骤。

以下为检查集群状态。

 

Asmca配置磁盘组，创建数据磁盘组DGDATA01  ，和DGARCH

 

 

 

2.  Oracle配置我们仅安装数据库软件

 

 

 

安装集群

 

 

设置互信

 

安装企业版

 

默认下一步

 

默认，下一步。

 

可以暂时不选择，通过手动进行执行root.sh脚本

 

 

 

 

 

 

 

执行root.sh脚本

  

 

 

 

 

 

 

dbca创建数据库。

 

   

定制数据库

 

 

 

 

 

注意这一步遇到了问题，选择ASM磁盘后无法识别磁盘。通过查询mos，以下解决办法

oracle@psbcdb19cr1[psbcdb1]/home/oracle$source .bash_profile $ORACLE_SID: psbcdb1 $ORACLE_HOME: /oracle/db19c oracle@psbcdb19cr1[psbcdb1]/home/oracle$/grid/grid_home/bin/kfod nohdr=TRUE OP=GROUPS status=true asmcompatibility=true dbcompatibility=true verbose=true 10240 10108 EXTERN DGDATA01 10.1.0.0.0 19.0.0.0.0 10240 10108 EXTERN DGARCH 10.1.0.0.0 19.0.0.0.0 6144 1590 NORMAL CRSDG 10.1.0.0.0 19.0.0.0.0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



上线前的压力测试数据库性能测试主要可分为以下三个大类：

² 数据库并发数：当前系统所能承受的最大用户数，也就是系统能够支持的最大客户端数量。

² 服务器资源（CPU 、I/O、内存）使用率：在各种负载压力下，服务器CPU的处理事件，I/O响应情况和内存使用率。

² 数据库的可靠性：在连续运行的状态下，系统正常运行的时间。

大多数负载测试工具可以分为以下几个大类：

Ø I/O测试。

Ø RDBMS层的I/O测试。

Ø 数据库方面的应用程序级别测试工具。

Ø 应用方向的应用程序级别测试工具。

第四种负载工具涉及到真实的应用场景建模，一般需要应用配合完成。前三种则不需要应用参与，DBA也可以自行完成。

 

1. I/O测试

I/O测试将I/O请求发送到存储设备并测试响应时间。I/O测试主要分为只读，读/写、随机I/O、顺序I/O等几大类，可使用Oracle自带的I/O测试工具Orion对Oracle RDBMS I/O工作负载进行建模。

 

对于OLTP系统，一般需要大量并发小I/O，混合少量大I/O，测试时我们可不断的增加随机小I/O的并发数来观察IOPS情况。

对于OLAP类型系统恰恰相反，需要并发大I/O，固定少量小I/O。

 

（1）使用参数说明

强制参数项：运行的工作负载类型（simple,normal,advanced,dss,oltp），主要去表如表所示。

负载类型

说明

simple

tests random8K small IOs at various loads,then ra
ndom 1Mlarge IOs at various loads.

normal

tests combinations of random 8K small IOs and random1M large IOs

advanced

run theworkload specified by the user usingoptional parameters

dss

run with random1M large IOs at increasing loads to determinethe maximum throughput

oltp

run with random8K small IOs at increasing loads to determinethe maximum IOPS

 

自定义参数：

 

testname                Name of the test run

 

num_disks               Number of disks (physicalspindles). Default is

 

                        the number of LUNs in<testname>.lun

 

size_small              Size of small IOs (in KB) -default 8

 

size_large              Size of large IOs (in KB) - default1024

 

type                    Type of large IOs (rand,seq) - default rand

 

                          rand - Random largeIOs

 

                          seq -  Sequential streams of large IOs

 

num_streamIO            Number of concurrent IOs per stream (only iftype is

 

                        seq) - default 4

 

simulate                Orion tests on a virtual volumeformed by combining the

 

                        provided volumes in oneof these ways (default concat):

 

                          concat - A serialconcatenation of the volumes

 

                          raid0 - A RAID-0mapping across the volumes

 

write                   Percentage of writes (SEEWARNING ABOVE) - default 0

 

cache_size              Size *IN MEGABYTES* of thearray's cache.

 

                        Unless this option isset to 0, Orion does a number

 

                        of (unmeasured) randomIO before each large sequential

 

                        data point.  This is done in order to fill up the array

 

                        cache with randomdata.  This way, the blocks from one

 

                        data point do notresult in cache hits for the next

 

                        data point.  Read tests are preceded with junk reads

 

                        and write tests arepreceded with junk writes.  If

 

                        specified, this 'cachewarming' is done until

 

                        cache_size worth of IOhas been read or written.

 

                        Default behavior: fillup cache for 2 minutes before

 

                        each data point.

 

 

duration                Duration of each data point (inseconds) - default 60

 

num_small               Number of outstanding small IOs(only if matrix is

                        point, col, or max) - no default

 

num_large               For random, number ofoutstanding large IOs.

                       For sequential, numberof streams (only if matrix is

                        point, row, or max) -no default

 

matrix                  An Orion test consists of data pointsat various small

                        and large IO loadlevels.  These points can be

                       represented as atwo-dimensional matrix: Each column

                        in the matrix representsa fixed small IO load.  Each

 

                        row represents a fixedlarge IO load.  The first row

 

                        is with no large IOload and the first column is with

 

                        no small IO load.  An Orion test can be a single point,

 

                        a row, a column or thewhole matrix, depending on the

 

                        matrix option settingbelow (default basic):

 

                          basic - test thefirst row and the first column

 

                          detailed - test the entire matrix

 

                          point - test at loadlevel num_small, num_large

 

                          col - varying largeIO load with num_small small IOs

 

                          row - varying smallIO load with num_large large IOs

 

                          max - test varyingloads up to num_small, num_large

 

verbose                 Prints tracing information tostandard output if set.

 

                        Default -- not set

 

运行时的例子

 

For a preliminaryset of data

 

        -run simple

 

For a basic setof data

 

        -run normal

 

To evaluatestorage for an OLTP database

 

        -run oltp

 

To evaluatestorage for a data warehouse

 

        -run dss

 

To generatecombinations of 32KB and 1MB reads to random locations:

 

        -run advanced

 

        -size_small 32 -size_large 1024 -typerand      -matrix detailed

 

To generatemultiple sequential 1MB write streams, simulating 1MB RAID0 stripes

 

        -run advanced

 

        -simulate RAID0 -stripe 1024 -write 100-type seq

 

       -matrix col -num_small 0

 

输出的文件介绍

 

<testname>_<date>_summary.txt-  Summary of the input parameters alongwith

 

                                 min. smalllatency, max large MBPS

 

                                 and/or max.small IOPS.

 

<testname>_<date>_mbps.csv- Performance results of large IOs in MBPS

 

<testname>_<date>_iops.csv- Performance results of small IOs in IOPS

 

<testname>_<date>_lat.csv- Latency of small IOs

 

<testname>_<date>_tradeoff.csv- Shows large MBPS / small IOPS

 

                                 combinations that can beachieved at

 

                                 certain smalllatencies

 

<testname>_trace.txt- Extended, unprocessed output

（2）Orion测试用例

2. RDBMS层I/O测试

（1）SLOB

（2）Oracle自带I/O测试功能

3. 模拟应用程序层测试

（1）Swingbench

19cracspanstylefontoracleracOracle数据库

有关19c rac 安装实践的更多相关文章

  1. ruby-on-rails - 使用 Ruby on Rails 进行自动化测试 - 最佳实践 - 2

    很好奇，就使用ruby​​onrails自动化单元测试而言，你们正在做什么？您是否创建了一个脚本来在cron中运行rake作业并将结果邮寄给您？git中的预提交Hook？只是手动调用？我完全理解测试，但想知道在错误发生之前捕获错误的最佳实践是什么。让我们理所当然地认为测试本身是完美无缺的，并且可以正常工作。下一步是什么以确保他们在正确的时间将可能有害的结果传达给您？ 最佳答案 不确定您到底想听什么，但是有几个级别的自动代码库控制:在处理某项功能时，您可以使用类似autotest的内容获得关于哪些有效，哪些无效的即时反馈。要确保您的提

  2. ruby - 在 64 位 Snow Leopard 上使用 rvm、postgres 9.0、ruby 1.9.2-p136 安装 pg gem 时出现问题 - 2

    我想为Heroku构建一个Rails3应用程序。他们使用Postgres作为他们的数据库，所以我通过MacPorts安装了postgres9.0。现在我需要一个postgresgem并且共识是出于性能原因你想要pggem。但是我对我得到的错误感到非常困惑当我尝试在rvm下通过geminstall安装pg时。我已经非常明确地指定了所有postgres目录的位置可以找到但仍然无法完成安装:$envARCHFLAGS='-archx86_64'geminstallpg--\--with-pg-config=/opt/local/var/db/postgresql90/defaultdb/po

  3. ruby - 完全离线安装RVM - 2

    我打算为ruby​​脚本创建一个安装程序，但我希望能够确保机器安装了RVM。有没有一种方法可以完全离线安装RVM并且不引人注目(通过不引人注目，就像创建一个可以做所有事情的脚本而不是要求用户向他们的bash_profile或bashrc添加一些东西)我不是要脚本本身，只是一个关于如何走这条路的快速指针(如果可能的话)。我们还研究了这个很有帮助的问题:RVM-isthereawayforsimpleofflineinstall?但有点误导，因为答案只向我们展示了如何离线在RVM中安装ruby。我们需要能够离线安装RVM本身，并查看脚本https://raw.github.com/wayn

  4. ruby-on-rails - rails 目前在重启后没有安装 - 2

    我有一个奇怪的问题:我在rvm上安装了ruby​​onrails。一切正常，我可以创建项目。但是在我输入“railsnew”时重新启动后，我有“程序'rails'当前未安装。”。SystemUbuntu12.04ruby-v"1.9.3p194"gemlistactionmailer(3.2.5)actionpack(3.2.5)activemodel(3.2.5)activerecord(3.2.5)activeresource(3.2.5)activesupport(3.2.5)arel(3.0.2)builder(3.0.0)bundler(1.1.4)coffee-rails(

  5. ruby - 如何为 emacs 安装 ruby​​-mode - 2

    我刚刚为fedora安装了emacs。我想用emacs编写ruby。为ruby​​提供代码提示、代码完成类型功能所需的工具、扩展是什么？ 最佳答案 ruby-mode已经包含在Emacs23之后的版本中。不过，它也可以通过ELPA获得。您可能感兴趣的其他一些事情是集成RVM、feature-mode(Cucumber)、rspec-mode、ruby-electric、inf-ruby、rinari(用于Rails)等。这是我当前用于Ruby开发的Emacs配置:https://github.com/citizen428/emacs

  6. ruby-on-rails - 无法在centos上安装therubyracer(V8和GCC出错) - 2

    我正在尝试在我的centos服务器上安装therubyracer，但遇到了麻烦。$geminstalltherubyracerBuildingnativeextensions.Thiscouldtakeawhile...ERROR:Errorinstallingtherubyracer:ERROR:Failedtobuildgemnativeextension./usr/local/rvm/rubies/ruby-1.9.3-p125/bin/rubyextconf.rbcheckingformain()in-lpthread...yescheckingforv8.h...no***e

  7. ruby - 通过 RVM (OSX Mountain Lion) 安装 Ruby 2.0.0-p247 时遇到问题 - 2

    我的最终目标是安装当前版本的RubyonRails。我在OSXMountainLion上运行。到目前为止，这是我的过程:已安装的RVM$\curl-Lhttps://get.rvm.io|bash-sstable检查已知(我假设已批准)安装$rvmlistknown我看到当前的稳定版本可用[ruby-]2.0.0[-p247]输入命令安装$rvminstall2.0.0-p247注意:我也试过这些安装命令$rvminstallruby-2.0.0-p247$rvminstallruby=2.0.0-p247我很快就无处可去了。结果:$rvminstall2.0.0-p247Search

  8. ruby - 如何在 Lion 上安装 Xcode 4.6，需要用 RVM 升级 ruby - 2

    我实际上是在尝试使用RVM在我的OSX10.7.5上更新ruby，并在输入以下命令后:rvminstallruby我得到了以下回复:Searchingforbinaryrubies,thismighttakesometime.Checkingrequirementsforosx.Installingrequirementsforosx.Updatingsystem.......Errorrunning'requirements_osx_brew_update_systemruby-2.0.0-p247',pleaseread/Users/username/.rvm/log/138121

  9. ruby - Fast-stemmer 安装问题 - 2

    由于fast-stemmer的问题，我很难安装我想要的任何ruby​​gem。我把我得到的错误放在下面。Buildingnativeextensions.Thiscouldtakeawhile...ERROR:Errorinstallingfast-stemmer:ERROR:Failedtobuildgemnativeextension./System/Library/Frameworks/Ruby.framework/Versions/2.0/usr/bin/rubyextconf.rbcreatingMakefilemake"DESTDIR="cleanmake"DESTDIR=

  10. ruby - 安装 Ruby 时遇到问题(无法下载资源 "readline--patch") - 2

    当我尝试安装Ruby时遇到此错误。我试过查看this和this但无济于事➜~brewinstallrubyWarning:YouareusingOSX10.12.Wedonotprovidesupportforthispre-releaseversion.Youmayencounterbuildfailuresorotherbreakages.Pleasecreatepull-requestsinsteadoffilingissues.==>Installingdependenciesforruby:readline,libyaml,makedepend==>Installingrub

随机推荐