检查控制文件2组 redo大小和组
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose > /home/grid/pre.log
//[root@ceshi dbs]# cat ~/.bashrc
# .bashrc
# User specific aliases and functions
alias rm='rm -i'
alias cp='cp -i'
alias mv='mv -i'
这些加入到oracle和grid用户防止复制或者移动有重名的文件直接覆盖的风险
//部署删除归档脚本
//建议关闭DRM
alter system set "_gc_policy_time"=0 scope=spfile sid='*';
alter system set "_gc_undo_affinity"=false scope=spfile sid='*';
//检查服务器的硬件时钟 hwclock –show
//ASM物理单块lun盘不能大于2TB
//ntpdate ip 建议放在rc.local里面自启动执行 防止时间混乱
//关闭systemctl stop avahi-daemon.socket avahi-daemon.service
systemctl disable avahi-daemon.socket avahi-daemon.service
1 安装系统（时区和时间CST）（swap 16-32G）根目录lvm 使用所有空间进行分区
skip- next-next-next- base-device-asia/shanghai—UTC不能勾- -next-使用所有勾选修改分区大小 修改swap大小—database server-
2 修改主机名
vi /etc/sysconfig/network
RAC1名称为：emrrac1
RAC2名称为：emrrac2
---linux 7
vi /etc/hostname
第一行
emrrac1
修改后需要重启
reboot
2、设置IP（修改主机hosts文件）要测试互相ping是否能ping通
vi /etc/hosts
192.168.1.20 emrrac1
192.168.1.21 emrrac1vip
10.0.0.1 emrrac1priv
10.0.0.11 emrrac1priv1
192.168.1.22 emrrac2
192.168.1.23 emrrac2vip
10.0.0.12 emrrac2priv
10.0.0.13 emrrac2priv2
192.168.1.27 emrrac3
192.168.1.25 emrrac3vip
10.0.0.14 emrrac3priv
10.0.0.15 emrrac3priv3
192.168.1.26 emrracscan
3、关闭防火墙 （两台都配置！）
service iptables status
service iptables stop
chkconfig iptables off
编 辑
vi /etc/selinux/config 文 件 ， 将 SELINUX 设 置 为
disabled。（SELINUX=disabled）
linux 7
systemctl stop firewalld
systemctl status firewalld
systemctl disable firewalld
cat /etc/selinux/config
vi /etc/selinux/config
SELINUX=disabled
4、修改tmpfs大小
vi /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=1500M 0 0
mount -o remount /dev/shm
//假如无法变更 以下方式检验写法是否有问题
umount /dev/shm
mount /dev/shm
5、关闭透明大页（两台都要 ）
Liux 6版本
记得 chmod + rc.loca
vi /etc/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
vi /etc/init.d/boot.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
# chmod 744 /etc/init.d/boot.local
重启OS以进行配置检测：
# reboot
# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
# cat /sys/kernel/mm/transparent_hugepage/defrag
always madvise [never]
# grep AnonHugePages /proc/meminfo
AnonHugePages: 0 kB
Linux 7
方法一：比较安全的 测试是为0，网上说可能不为0，目前测试不管是单机还是rac重启都为0
vi /etc/systemd/system/disable-thp.service
[Unit]
Description=Disable Transparent Huge Pages (THP)
[Service]
Type=simple
ExecStart=/bin/sh -c "echo 'never' >/sys/kernel/mm/transparent_hugepage/enabled && echo 'never' >/sys/kernel/mm/transparent_hugepage/defrag"
[Install]
WantedBy=multi-user.target
systemctl daemon-reload
systemctl start disable-thp
systemctl enable disable-thp
systemctl status disable-thp
reboot完记得检查
grep AnonHugePages /proc/meminfo
方法二改内核：记住一定要提前备份文件，这种方式可以百分百确保关闭透明大页，但是建议用方法一，如碰到实在关不掉用如下方法
cp /etc/default/grub /etc/default/grub.2023bak
sed -i 's/quiet/quiet transparent_hugepage=never numa=off/' /etc/default/grub
//判断系统引导方式：[ -d /sys/firmware/efi ] && echo UEFI || echo BIOS
根据结果执行相应的命令
BIOS
cp -pv /boot/grub2/grub.cfg /boot/grub2/grub.cfg-bkp
grub2-mkconfig -o /boot/grub2/grub.cfg
UEFI
cp -pv /boot/efi/EFI/redhat/grub.cfg /boot/efi/EFI/redhat/grub.cfg-bkp
grub2-mkconfig -o /boot/efi/EFI/redhat/grub.cfg
reboot完记得检查
grep AnonHugePages /proc/meminfo
//这条语句为检查NUMA是否关闭
numactl -H | grep available
numactl -H | grep available
6、配置yum源（两台都配置！）
Mount前先看下df –h 不要重复
mount /dev/cdrom /mnt
mount -o loop -t iso9660 /software/oraclelinux7.6.iso /mnt
vi /etc/yum.repos.d/yum.repo
[server]
name=server
baseurl=file:///mnt/
gpgcheck=0
enable=1
umount /mnt
fuser –m /mnt
vi /etc/mtab --谨慎
7、安装软件包
yum -y install binutils-* compat-libstdc++-33-* elfutils-libelf-* elfutils-libelf-devel-* gcc-* gcc-c++-* compat-libcap* glibc-* glibc-common-* glibc-devel-* glibc-headers-* ksh-* libaio-* libgcc-* libstdc++-* make-* sysstat-* unixODBC-* unixODBC-devel-*
yum install -y psmisc
//根据需求（先查 rpm –qa|grep ksh，有值就不装pdk）
Yum install bc 开启大页的包（前提是sga pga有值 不是自动内存管理）
##rpm -e ksh-20120801-33.el6.x86_64
##rpm -ivh pdksh-5.2.14-36.el5.x86_64.rpm
（rpm -i --force --nodeps pdksh-5.2.14-36.el5.x86_64.rpm //强制安装）
rpm -ivh cvuqdisk-1.0.9-1.rpm //grid安装软件的目录下(linux7 先安装
yum install smartmontools）
安装图形化界面
yum install xorg-x11-server-utils-7.7-14.el6.x86_64
yum install xorg-x11-xauth
yum install xhost
安装ntp服务
yum install ntpdate
安装多路径软件
yum -y install device-mapper*
yum install unzip
yum -y install net-tools
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils \
binutils \
compat-libstdc++ \
elfutils-libelf \
elfutils-libelf-devel \
expat \
gcc \
gcc-c++ \
glibc \
glibc-common \
glibc-devel \
glibc-headers \
libaio \
libaio-devel \
libgcc \
libstdc++ \
libstdc++-devel \
make \
pdksh \
sysstat \
unixODBC \
unixODBC-devel
8、 修改内核参数（三台,记得有相同值需要注释掉）
vi /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmmax = 274877906942
kernel.shmmni = 4096
kernel.shmall = 33554432 -----根据内存大小改
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_tw_recycle = 1
kernel.core_uses_pid = 1
kernel.panic_on_oops = 1
vm.min_free_kbytes = 524288
net.ipv4.conf.all.rp_filter = 0
net.ipv4.conf.default.rp_filter = 0
net.ipv4.ipfrag_high_thresh = 16777216
net.ipv4.ipfrag_low_thresh = 15728640
vm.nr_hugepages=脚本在mybase里面，一般都是sga/2+5（单位是M）前提是非自动内存管理 cat /proc/meminfo |grep H 查看是否生效,需要重启数据库查看数据库日志
使其生效：
sysctl -p
//这两个值要查询下sysctl -a | grep rp_filter，值要为0
net.ipv4.conf.eth1.rp_filter = 0
net.ipv4.conf.eth2.rp_filter = 0
9、vi /etc/security/limits.conf （三台）
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
oracle soft nproc 4094
oracle hard nproc 16384
oracle soft nofile 2048
oracle hard nofile 65536
oracle soft stack 10240
//开启大页后（单位KB）
grid soft memlock 199229440
grid hard memlock 199229440
oracle soft memlock 199229440
oracle hard memlock 199229440
10、修改文件本地账号无法登陆（三台）
vi /etc/pam.d/login
session required /lib64/security/pam_limits.so
11、修改文件（三台）(这个可以不加，暂时看不出什么用最好加吧)
vi /etc/profile
if [ /$USER = "oracle" ] || [ /$USER = "grid" ]; then
if [ /$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
12、添加用户和组 （三台都配置！）
groupadd -g 1400 oinstall
groupadd -g 1100 asmadmin
groupadd -g 1200 dba
groupadd -g 1300 asmdba
groupadd -g 1301 asmoper
useradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -d /home/grid grid
useradd -u 1101 -g oinstall -G dba,asmdba -d /home/oracle oracle
echo Grid#123 | passwd --stdin grid
echo Oracle#123 | passwd --stdin oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/oraInventory
chmod -R 775 /oracle/app/oraInventory
mkdir -p /oracle/11.2.0/grid
mkdir -p /oracle/app/grid
chown -R grid:oinstall /oracle/app/grid
chown -R grid:oinstall /oracle/11.2.0/grid
chmod -R 775 /oracle/11.2.0/grid
mkdir -p /oracle/app/oracle
mkdir /oracle/app/oracle/cfgtoollogs
chown -R oracle:oinstall /oracle/app/oracle
chmod -R 775 /oracle/app/oracle
mkdir -p /oracle/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /oracle/app/oracle/product/11.2.0/db_1
chmod -R 775 /oracle/app/oracle/product/11.2.0/db_1
13、配置grid环境变量（3台）
Rac1
Su - gird
vi .bash_profile
umask 022
export ORACLE_SID=+ASM1
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
Rac2
Su - gird
vi .bash_profile
umask 022
export ORACLE_SID=+ASM2
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
Rac3
Su – gird
vi .bash_profile
umask 022
export ORACLE_SID=+ASM3
export ORACLE_BASE=/oracle/app/grid
export ORACLE_HOME=/oracle/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
14、配置oracle环境变量（3台）
Rac1
Su – oracle
vi .bash_profile
umask 022
export ORACLE_SID=htbase1
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
Rac2
Su – oracle
vi .bash_profile
umask 022
export ORACLE_SID=htbase2
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
Rac3
Su – oracle
vi .bash_profile
umask 022
export ORACLE_SID=htbase3
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY:MM:DD HH24:MI:SS"
export TMP=/tmp
export TMPDIR=$TMP
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH
14 vi /etc/sysconfig/network
增加 NOZEROCONF=yes
The route entry "169.254.0.0/16" is the IPV4 "link local" block.It is allocated for communication between hosts on a single link. Hosts obtain these addresses by auto-configuration, such as when a DHCP server may not be found.
This routing entry is added automatically because RHEL/OEL enable Zero configuration networking(zeroconf) by default.
To disable the zeroconf route during system boot or network service restart,
edit the /etc/sysconfig/network file and add the following NOZEROCONF value to the end of the file:
15.ntsysv去除sendmail服务
16.配置ntp（3台）(linux 7后建议采用chrony)
vi /etc/ntp.conf
driftfile /etc/ntp.drift
tracefile /etc/ntp.trace
logfile /var/log/ntp.log
server ntp.sjtu.edu.cn
#server 10.3.193.3
restrict default
restrict -6 default
vi /etc/sysconfig/ntpd
SYNC_HWCLOCK=yes
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid -g"
chkconfig ntpd on
service ntpd restart
ntpstat
ntpq
as
rv sid (flash ok)
ntpq -p
*ntp5.flashdance 类似 377
ntpdate 命令不执行 whereis ntpdate 0 1 * * * /usr/sbin/ntpdate 192.168.1.111
17、配置互信（3台）可以通过图形化去配置（建议）
上传oracle linxu安装包
到其中一台
Root用户
Mkdir /software
使用root用户解压缩第三个包
cd /software
unzip p13390677_112040_Linux-x86-64_3of7.zip
该目录下即可生成 grid目录
cd grid目录下的 sshsetup目录
cd /software/grid/sshsetup/
./sshUserSetup.sh -user grid -hosts "emrdb1 emrdb2 emrdb3" -advanced –noPromptPassphrase
./sshUserSetup.sh -user oracle -hosts "emrdb1 emrdb2 emrdb3" -advanced –noPromptPassphrase
Yes
测试等效性
Su – grid
Ssh emrrac1 date（例子）
Ssh emrrac1priv date
Vip 是不通的
17//手动配置
配置等效性（grid与oracle)
fdfdfdfdfdfdfdffdfdf
【2个节点】
su - oracle
cd
rm -rf .ssh
mkdir ~/.ssh
chmod 700 ~/.ssh
【节点1】
ssh-keygen -b 1024 -t dsa
ssh-keygen -b 1024 -t rsa
cd ~/.ssh
cat *rsa.pub >> authorized_keys
cat *dsa.pub >> authorized_keys2
scp * zjywdb01:$HOME/.ssh
18、配置操作系统多路径
yum -y install device-mapper* 已经安装就不需要
尝试命令：multipath -v2
需要加载DM模块：
modprobe dm-multipath
modprobe dm-round-robin
启动服务并设置开机自启动（oracle linux 系统）
service multipathd start
chkconfig multipathd on
启动服务并设置开机自启动（centos 7 系统）
systemctl start multipathd.service
systemctl enable multipathd.service
创建/etc/multipath.conf，可以从“/usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf” 复制：
cp /usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf /etc/
modprobe dm-multipath
modprobe dm-round-robin
尝试命令：multipath -v2
centos 7 修改cd /etc/multipath/ 下的wwid改成匹配的
用命令查看设备wwid： ll /dev/disk/by-id(bindiangs应该是自动生成的)
/36000c291aa4f4d2b1469a9b5d914390e/(这种格式)
systemctl stop multipathd.service
systemctl start multipathd.service
multipath -ll
1) 取得DM_UUID:
cd /dev/mapper
for i in `ls mpath*`; do printf "%s %s\n" "$i" "$(udevadm info --query=all --name=/dev/mapper/$i |grep -i dm_uuid)"; done
LOG:
mpatha E: DM_UUID=mpath-14f504e46494c4552686a374a58592d763045432d5a305a6a
mpathb E: DM_UUID=mpath-14f504e46494c455267334f6f69422d6f51626c2d33516467
mpathc E: DM_UUID=mpath-14f504e46494c45527172433537322d476d47522d62757574
mpathd E: DM_UUID=mpath-14f504e46494c4552426f38676d392d626652342d6d6f7872
mpathe E: DM_UUID=mpath-14f504e46494c4552766d6e434c792d6a7065302d65346e70
mpathf E: DM_UUID=mpath-14f504e46494c45525a6c345564512d517274652d304e7a72
//有的存储可能需要用这个
for i in k l m n
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\", RESULT==\"`/sbin/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\""
done
2) 生成rules文件
vi /etc/udev/rules.d/99-oracle-asmdevices.rules
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c4552686a374a58592d763045432d5a305a6a",SYMLINK+="asm_test1",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c455267334f6f69422d6f51626c2d33516467",SYMLINK+="asm_test2",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45527172433537322d476d47522d62757574",SYMLINK+="asm_test3",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c4552426f38676d392d626652342d6d6f7872",SYMLINK+="asm_test4",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c4552766d6e434c792d6a7065302d65346e70",SYMLINK+="asm_test5",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="mpath-14f504e46494c45525a6c345564512d517274652d304e7a72",SYMLINK+="asm_test6",OWNER="grid",GROUP="asmadmin",MODE="0660"
3) scp rules文件至其他节点
scp /etc/udev/rules.d/99-oracle-asmdevices.rules node2:/etc/udev/rules.d/
4) 重新加载rules文件
udevadm control --reload-rules
udevadm trigger
5) 查看绑定后设备信息
[root@test1 rules.d]# ls -l /dev/asm*
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test1 -> dm-2
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test2 -> dm-3
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test3 -> dm-4
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test4 -> dm-5
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test5 -> dm-6
lrwxrwxrwx 1 root root 4 Aug 20 14:42 /dev/asm_test6 -> dm-7
[root@test1 rules.d]# ls -l /dev/dm-*
brw-rw---- 1 grid asmadmin 253, 2 Aug 20 14:42 /dev/dm-2
brw-rw---- 1 grid asmadmin 253, 3 Aug 20 14:42 /dev/dm-3
brw-rw---- 1 grid asmadmin 253, 4 Aug 20 14:42 /dev/dm-4
brw-rw---- 1 grid asmadmin 253, 5 Aug 20 14:42 /dev/dm-5
brw-rw---- 1 grid asmadmin 253, 6 Aug 20 14:42 /dev/dm-6
brw-rw---- 1 grid asmadmin 253, 7 Aug 20 14:42 /dev/dm-7
dd if=/dev/zero of=/dev/mapper/mpathb bs=8192 count=100000（还没搭集群前测试磁盘读写，慎重跑这个）
reboot 重启所有机子确认磁盘是否丢失
19、安装grid软件
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ cd /software/grid/
[grid@rac1 grid]$ export DISPLAY=172.20.63.253:0.0
[grid@rac1 grid]$ ./runInstaller
(乱码：export LANG=en_US)
Starting Oracle Universal Installer...
Asm实例 sys/system 密码oracle 记得修改磁盘路径不然找不到,磁盘名必须asm开头
只有asm磁盘的不管 其他错误要解决
sysctl -a | grep rp_filter
net.ipv4.conf.eth1.rp_filter = 0
net.ipv4.conf.eth2.rp_filter = 0
//centos7 会报错
如果报错：3台分别执行root用户：临时解决（不能提前跑）
/etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null &
然后3台分别创建ohas自动启动服务每台root用户
touch /usr/lib/systemd/system/ohas.service
vi /usr/lib/systemd/system/ohas.service
[Unit]
Description=Oracle High Availability Services
After=syslog.target
[Service]
ExecStart=/etc/init.d/init.ohasd run >/dev/null 2>&1 Type=simple
Restart=always
[Install]
WantedBy=multi-user.target
chmod 777 /usr/lib/systemd/system/ohas.service
cat /usr/lib/systemd/system/ohas.service
systemctl daemon-reload
systemctl enable ohas.service
systemctl start ohas.service
跑脚本记得一台一台跑，不能有错误
执行完会有警告INS202 ，不用管直接完成
20.安装oracle软件（root解压）
Root 先解压 1和2两个包
Su – oracle
./runInstaller
执行完脚本点击完成
停止CRF服务On each node, as root user:
# <GI_HOME>/bin/crsctl stop res ora.crf -init
# <GI_HOME>/bin/crsctl modify res ora.crf -attr ENABLED=0 -init
//centos 7报错
Oracle用户：反/ 快速查找
Su - oracle
cd $ORACLE_HOME/sysman/lib
cp ins_emagent.mk ins_emagent.mk.bak
vi ins_emagent.mk
将ins_emagent.mk文件中的 (MK_EMAGENT_NMECTL)更改为$(MK_EMAGENT_NMECTL) -lnnz11
在第一台执行就可以了
停止CRF服务On each node, as root user:
/oracle/11.2.0/grid/bin/crsctl stop res ora.crf -init
/oracle/11.2.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=0 -init
21、打补丁（没有建库的前提，有数据库必须看readme 可能需要停数据，以2节点为例，磁盘剩余空间要大于10G）
//打补丁前都要先装p6880880（分windows和linux）这个补丁包
//所有补丁都要先去看readme
//小补丁一般都是optach apply
//11.2.0.3 要一个级别一个级别往上打 windows
./optach lsinv //查询是否有补丁
//单机linux ：只能打 29141056
//centos 7 版本要先安装以下包：
yum install -y psmisc
export PATH=$PATH:$ORACLE_HOME/OPatch
set lin 200
col path for a50
select * from dba_registry_history;
1.升级opatch
分发p6880880，将OPATCH分发到两个节点的4个用户下,使用opatch version验证
//备份软件目录
tar -czvf /software/grid.tar.gz oracle/11.2.0/grid
tar -czvf /software/oracle.tar.gz oracle/app/oracle/product/11.2.0/db_1
./opatch lsinv //查询是否有补丁
./opatch lspathes
节点1
root用户
cp /software/p6880*.zip /oracle/11.2.0/grid
cd /oracle/11.2.0/grid
chown grid:oinstall p6880*.zip
su - grid
cd $ORACLE_HOME
unzip p6880*.zip ------选择A--
cd $ORACLE_HOME/OPatch
./opatch version ----版本应该是11.2.0.3.21
root用户
cp /software/p6880*.zip /oracle/app/oracle/product/11.2.0/db_1
cd /oracle/app/oracle/product/11.2.0/db_1
chown oracle:oinstall p6880*.zip
su - oracle
cd $ORACLE_HOME
unzip p6880*.zip ------选择A--
cd $ORACLE_HOME/OPatch
./opatch version ----版本应该是11.2.0.3.21
节点2
root用户
cp /software/p6880*.zip /oracle/11.2.0/grid
cd /oracle/11.2.0/grid
chown grid:oinstall p6880*.zip
su - grid
cd $ORACLE_HOME
unzip p6880*.zip ------选择A--
cd $ORACLE_HOME/OPatch
./opatch version ----版本应该是11.2.0.3.21
root用户
cp /software/p6880*.zip /oracle/app/oracle/product/11.2.0/db_1
cd /oracle/app/oracle/product/11.2.0/db_1
chown oracle:oinstall p6880*.zip
su - oracle
cd $ORACLE_HOME
unzip p6880*.zip ------选择A--
cd $ORACLE_HOME/OPatch
./opatch version ----版本应该是11.2.0.3.21
2.GRID用户在$ORACLE_HOME/OPatch/ocm/bin目录下使用命令emocmrsp创建文件ocm.rsp
节点1
su - grid
cd $ORACLE_HOME/OPatch/ocm/bin
./emocmrsp -----回车---选择Y
chmod 775 ocm.rsp
节点2
su - grid
cd $ORACLE_HOME/OPatch/ocm/bin
./emocmrsp -----回车---选择Y
chmod 775 ocm.rsp
4.解压缩补丁包
root 用户
cd /software
unzip p29255947_112040_Linux-x86-64.zip
chown -R grid:oinstall /software/29255947
5.给grid用户打补丁(两个节点分别) 可以一起执行
root 用户
cd /oracle/11.2.0/grid
/oracle/11.2.0/grid/OPatch/opatch auto /software/29255947 -oh /oracle/11.2.0/grid -ocmrf /oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
（上面的是一行的命令不是分两行）
//回滚（加了一个、以防跑错）
--------------/oracle/11.2.0/grid、/OPatch/opatch auto /software/29255947 -oh /oracle/11.2.0/grid -rollback -ocmrf /oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
6.给DB打补丁(两个节点分别)
root 用户
chown -R oracle:oinstall /software/29255947
/oracle/app/oracle/product/11.2.0/db_1/OPatch/opatch auto /software/29255947 -oh /oracle/app/oracle/product/11.2.0/db_1 -ocmrf /oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
（上面的是一行的命令不是分两行）
22、修改asm数据参数（备份启动参数,tmpfs大于4G能等于）
sqlplus / as sysasm
create pfile='/home/grid/asm_backup.spfile' from spfile;
SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
FROM SYS.x$ksppi x, SYS.x$ksppcv y
WHERE x.inst_id = USERENV ('Instance')
AND y.inst_id = USERENV ('Instance')
AND x.indx = y.indx
AND (x.ksppinm ='_asm_ausize')
alter system set _asm_ausize=4m scope=spfile sid='*';
alter system set memory_max_target=4096m scope=spfile sid='*';
alter system set memory_target=1536m scope=spfile sid='*';
alter system set "_asm_hbeatiowait"=120 scope=spfile sid='*';
//每台去执行一下（一台一台执行）
/oracle/11.2.0/grid/bin/crsctl stop crs
/oracle/11.2.0/grid/bin/crsctl start crs
确认参数生效
22、创建asm数据库磁盘组
asmca
22、创建数据库
Su – oracle
Dbca
oracle
这个值设置成盘的最大值（如500G 就设置为490G） 把开归档也打钩
审计关闭
日志文件的大小和组数自己改，通道号记得也一起改（一般emr一个500M 一个通到3组，积数个）
完成
+DATADG/htbase/spfilehtbase.ora 备份参数文件 cp一个放相同根目录
查看用户的proifle是哪个，一般是default：
sql>SELECT username,PROFILE FROM dba_users;
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='FAILED_LOGIN_ATTEMPTS';
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
隐含参数选择是否关闭（隐含参数参考mybase）
记得开启归档
