HP-UNIX RAC 11.2.0.4 安装文档
hp的小机跟linux环境差距还是比较大，命令很多都不一样，这次安装花了较多的时间
还是做个记录，下次安装的话也会快一点
检查环境，内存，网络，存储等
oracle@pmscpdb1:/oracle$ machinfo|grep -i memory
Memory: 130810 MB (127.74 GB)
oracle@pmscpdb1:/oracle$
pmscpdb1:[/]#swapinfo -a
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 50331648 0 50331648 0% 0 - 1 /dev/vg00/lvol2
dev 143327232 0 143327232 0% 0 - 1 /dev/vg00/swap2
reserve - 1368040 -1368040
memory 127409548 14535684 112873864 11%
删除原有环境（与linux有所不同）
rm -rf /oracle/app
rm -rf /etc/ora*
rm -rf /tmp/*
rm -rf /usr/local/bin/dbhome
rm -rf /usr/local/bin/oraenv
rm -rf /usr/local/bin/coraenv
rm /sbin/init.d/init.*
ls -lrt /sbin/rc*d/*init.crs
rm /sbin/init.d/init.crs
rm /sbin/init.d/init.crs
rm -rf /var/opt/oracle
rm /etc/initab.crs
#LIB设置
cd /usr/lib
ln -s libX11.3 libX11.sl
ln -s libXIE.2 libXIE.sl
ln -s libXext.3 libXext.sl
ln -s libXhp11.3 libXhp11.sl
ln -s libXi.3 libXi.sl
ln -s libXm.4 libXm.sl
ln -s libXp.2 libXp.sl
ln -s libXt.3 libXt.sl
ln -s libXtst.2 libXtst.sl
OS补丁
#hpunix需要打OS补丁
#检查补丁
swlist |grep PHCO
#需要安装的补丁
PHCO_40381 11.31 Disk Owner Patch
PHKL_38038 vm cumulative patch
PHKL_38938 11.31 SCSI cumulative I/O patch
PHKL_39351 Scheduler patch : post wait hang
PHSS_36354 11.31 assembler patch
PHSS_37042 11.31 hppac (packed decimal)
PHSS_37959 Libcl patch for alternate stack issue fix
(QXCR1000818011)
PHSS_39094 11.31 linker + fdp cumulative patch
PHSS_39100 11.31 Math Library Cumulative Patch
PHSS_39102 11.31 Integrity Unwind Library
PHSS_38141 11.31 aC++ Runtime
ntp
pmscpdb1:[/]#ntpq -p
remote refid st t when poll reach delay offset disp
==============================================================================
*10.176.3.248 .GPS. 1 u 37 64 377 45.65 81.719 2.55
磁盘
pmscpdb1:[/]#ioscan -funN -C disk
Class I H/W Path Driver S/W State H/W Type Description
===================================================================
disk 3 64000/0xfa00/0x0 esdisk CLAIMED DEVICE HP 300 GST3300655LC
/dev/disk/disk3 /dev/disk/disk3_p2 /dev/rdisk/disk3 /dev/rdisk/disk3_p2
/dev/disk/disk3_p1 /dev/disk/disk3_p3 /dev/rdisk/disk3_p1 /dev/rdisk/disk3_p3
...
pmscpdb1:[/]#ioscan -m dsf
Persistent DSF Legacy DSF(s)
========================================
/dev/rdisk/disk3 /dev/rdsk/c0t6d0
/dev/rdisk/disk3_p1 /dev/rdsk/c0t6d0s1
/dev/rdisk/disk3_p2 /dev/rdsk/c0t6d0s2
/dev/rdisk/disk3_p3 /dev/rdsk/c0t6d0s3
确实盘符
pmscpdb1:[/dev/rdisk]#scsimgr -p get_attr all_lun -a hw_path -a device_file -a wwid
64000/0xfa00/0x0:/dev/rdisk/disk3:0x5001d38002e99740
64000/0xfa00/0x1:/dev/rdisk/disk4:
#磁盘更改权限
cd /dev/vgcxk_sc_vote
chown grid:oinstall rlvcxk_sc_vote*
dd if=/dev/zero count=10 bs=1024k of=/dev/vgcxk_sc_vote/rlvcxk_sc_vote1
dd if=/dev/zero count=10 bs=1024k of=/dev/vgcxk_sc_vote/rlvcxk_sc_vote2
dd if=/dev/zero count=10 bs=1024k of=/dev/vgcxk_sc_vote/rlvcxk_sc_vote3
cd /dev/vgcxk_sc
chown grid:oinstall rlvepm*
#清理其他磁盘
pmscpdb1:[/dev/vgcxk_sc]#ls -lrt r*|awk '{print $10}'
dd if=/dev/zero count=10 bs=1024k of=/dev/vgcxk_sc/rlvepm_system_01
…
dd if=/dev/zero count=10 bs=1024k of=/dev/vgcxk_sc/rlvepm_data_new_60
#用户
useradd -u 600 -g oinstall -G dba -d /home/oracle -s /sbin/sh oracle
usermod -d /home/oracle oracle
useradd -u 700 -g oinstall -G dba -d /home/grid -s /sbin/sh gird
usermod -d /home/grid grid
#目录
mkdir -p /oracle/app/grid
mkdir -p /oracle/app/11.2/grid
mkdir -p /oracle/app/oracle
mkdir -p /oracle/app/oraInventory
chown -R grid:oinstall /oracle/app/11.2
chown -R grid:oinstall /oracle/app/grid
chown -R grid:oinstall /oracle/app/oraInventory
chmod -R 775 /oracle
chmod -R 777 /oracle/soft
环境变量
#oracle profile
umask 022
export ORACLE_BASE=/oracle/app/oracle
export ORACLE_HOME=/oracle/app/oracle/product/11.2/db_1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_SID=lzl1
export PATH=$PATH:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/webcache/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/OPatch:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/usr/lib:
#export #SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/usr/lib/Motif1.2
#export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jre/1.1.8/lib:/usr/jdk_base:/usr/jdk_base:/usr/jdk_base/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export TERM=vt100
alias ll='ls -l'
set -o vi
if [ "$LOGNAME" = "root" ]
then
export PS1='$LOGNAME'@"$(hostname)":'$PWD'"# "
else
export PS1='$LOGNAME'@"$(hostname)":'$PWD'"$ "
fi
stty erase "^H"
#grid .profle
umask 022
export ORACLE_BASE=/oracle/app/grid
export ORA_CRS_HOME=/oracle/app/11.2/grid
export ORACLE_HOME=/oracle/app/11.2/grid
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_SID=+ASM1
export PATH=$PATH:$ORA_CRS_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/dcm/bin:$ORACLE_HOME/webcache/bin:$ORACLE_HOME/opmn/bin:$ORACLE_HOME/OPatch:.
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:/usr/lib:
#export #SHLIB_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/lib:/usr/lib/Motif1.2
#export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jre/1.1.8/lib:/usr/jdk_base:/usr/jdk_base:/usr/jdk_base/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export TERM=vt100
alias ll='ls -l'
set -o vi
if [ "$LOGNAME" = "root" ]
then
export PS1='$LOGNAME'@"$(hostname)":'$PWD'"# "
else
export PS1='$LOGNAME'@"$(hostname)":'$PWD'"$ "
fi
stty erase "^H"
export DISPLAY="10.176.34.87:0.0"
#/etc/profile
#chmod +w /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
if [ -t 0 ]; then
stty intr ^C
fi
#/etc/csh.login chmod +w /etc/csh.login
if ( $USER == "oracle" || $USER == "grid" ) then
limit maxproc 16384
limit descriptors 65536
endif
test -t 0
if ($status == 0) then
stty intr ^C
endif
#oracle grid互信配置
#运行ssh-keygen，将id_rsa.pub内容粘贴到远端authorized_keys中
grid@pmscpdb2:/home/grid/.ssh$ ssh pmscpdb1 date; ssh pmscpdb2 date;
Mon Jul 1 16:36:40 EAT 2019
Mon Jul 1 16:36:41 EAT 2019
#预安装检查
./runcluvfy.sh stage -pre crsinst -n pmscpdb1,pmscpdb2 -fixup -verbose
./runInstaller
执行root脚本：
/oracle/app/oraInventory/orainstRoot.sh
/oracle/app/11.2/grid/root.sh
pmscpdb2:[/dev/vgcxk_sc_vote]#crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.OCR.dg
ONLINE ONLINE pmscpdb1
ONLINE ONLINE pmscpdb2
ora.asm
ONLINE ONLINE pmscpdb1 Started
ONLINE ONLINE pmscpdb2 Started
ora.gsd
OFFLINE OFFLINE pmscpdb1
OFFLINE OFFLINE pmscpdb2
ora.net1.network
ONLINE ONLINE pmscpdb1
ONLINE ONLINE pmscpdb2
ora.ons
ONLINE ONLINE pmscpdb1
ONLINE ONLINE pmscpdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE pmscpdb1
ora.cvu
1 ONLINE ONLINE pmscpdb1
ora.oc4j
1 OFFLINE OFFLINE
ora.pmscpdb1.vip
1 ONLINE ONLINE pmscpdb1
ora.pmscpdb2.vip
1 ONLINE ONLINE pmscpdb2
ora.scan1.vip
1 ONLINE ONLINE pmscpdb1
asmca创建磁盘组
安装oracle软件的预安装检查
cluvfy stage -pre dbcfg -n pmscpdb1,pmscpdb2 -verbose -d /oracle/app/oracle/product/11.2/db_1
su - oracle
./runInstaller
跑root.sh
#psu
#应用2019年1月份的psu
#p6880880_112000_HP64.zip
#p28813878_112040_HP64.zip
oracle@pmscpdb1:/home/oracle$ opatch version
OPatch Version: 11.2.0.3.21
OPatch succeeded.
grid@pmscpdb1:/home/grid$ opatch version
OPatch Version: 11.2.0.3.21
OPatch succeeded.
grid:
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/ocm.rsp
root:
/oracle/app/11.2/grid/OPatch/opatch auto /oracle/soft/28813878 -ocmrf /tmp/ocm.rsp -oh /oracle/app/11.2/grid
/oracle/app/11.2/grid/OPatch/opatch auto /oracle/soft/28813878 -ocmrf /tmp/ocm.rsp