[RAC] HP Unix Install Oracle11g(RAC)

1.Hardware check.
  (1)machinfo | grep -i memory   # memory>2G
  (2)swapinfo -a
  (3)bdf                         #Disk Space Require

2.Software Check.
   uname -a                    
     HP-UX hostname B.11.31 U ia64 hostid unlimited-user license
     swlist | grep -i qpk
     B.11.31.1609              # hp os 11.31 patch需要0809以上的版本.

3.Patch Check.
 swlist -l product | grep -i PHCO_43503              #已经安装
 swlist -l product | grep -i PHCO_41479
 swlist -l product | grep -i PHKL_38038
 swlist -l product | grep -i PHKL_38938
 swlist -l product | grep -i PHKL_40941
 swlist -l product | grep -i PHSS_36354
 swlist -l product | grep -i PHSS_37042              #已经安装
 swlist -l product | grep -i PHSS_37959
 swlist -l product | grep -i PHSS_39094
 swlist -l product | grep -i PHSS_39100
 swlist -l product | grep -i PHSS_39102
 swlist -l product | grep -i PHSS_38141
 swlist -l product | grep -i PHSS_39824
 swlist -l product | grep -i PHKL_39773               #for VERITAS File System
 
4.group和user
groupadd -g 1000 oinstall
groupadd -g 1001 asmadmin
groupadd -g 1002 asmdba
groupadd -g 1003 asmoper
groupadd -g 1004 dba
groupadd -g 1005 oper
useradd -u 1100 -g oinstall -G dba,asmdba -d /oracle/testdb/oracle oracle
useradd -u 1101 -g oinstall -G dba,asmadmin,asmdba -d /oracle/testdb/oragrid oragrid
passwd oracle    #oracle/oracle
passwd oragrid   #oragrid/oragrid

5.directory create
mkdir -p /oracle/testdb/oracle
mkdir -p /oracle/testdb/oragrid
chown -R oragrid:oinstall oragrid
chmod -R 775 oragrid
chown -R oracle:oinstall oracle
chmod -R 775 oracle


6.检查符合的连接是否存在，如果不存在则需要创建
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


7.OS kernel Check.
                     Value             Oracle recommend
------------------------------------------------------------------
 ksi_alloc_max       56000             32768
 executable_stack    0                 0
 max_thread_proc     10000             1024
 maxdsiz             2147483648 (2G)   1073741824 (1G)  
 maxdsiz_64bit       4294967296 (4G)   2147483648 (2G)
 maxssiz             268435456 (256M)  134217728  (128M)
 maxssiz_64bit       1073741824 (1G)   1073741824 (1G)
 maxuprc             9000 (nproc*)/10  3686                      #设置nproc=10000
 msgmni              7000              4096
 msgtql              7000              4096
 ncsize              59072             35840
 maxfiles_lim        65536             32767
 maxfiles            16384             1024
 nflocks             7000              4096
 ninode              58048             34816
 nkthread            52516             7184
 nproc               10000             4096
 semmni              7000              4096
 semmns              14000             8192
 semmnu              9996 (nproc-4)    4092
 semvmx              32767             32767
 shmmax              17179869184 (16G) 1073741824 (1G)
 shmmni              4096              4096
 shmseg              512               512
 tcp_largest_anon_port/udp_largest_anon_port  kctune查看没有这个参数,如果需要设置，oracle recommend设置为65500
 
 如果要查看的话，需要 kctune nproc 查看设置的值,kctune 加上os 参数查看.
 修改例子如下:
  kctune max_thread_proc=10000
     ==> Update the automatic 'backup' configuration first? y
       * The automatic 'backup' configuration has been updated.
       * Future operations will update the backup without prompting.
       * The requested changes have been applied to the currently
         running configuration.
  Tunable                    Value  Expression  Changes
  max_thread_proc  (before)   1200  1200        Immed
                   (now)     10000  10000
  kctune max_thread_proc
  Tunable          Value  Expression  Changes
  max_thread_proc  10000  10000       Immed
  修改后需要重启生效

 
8.filesystem相关建立(2个node一起操作)
node1:
pvcreate /dev/rdsk/c2t0d0
vgcreate -s 32 vgora /dev/dsk/c2t0d0
lvcreate -L 40960M -n lvoragrid /dev/vgora
lvcreate -L 40960M -n lvoracle /dev/vgora
newfs -F vxfs /dev/vgora/rlvoracle
newfs -F vxfs /dev/vgora/rlvoragrid
mount /dev/vgora/lvoracle /oracle/testdb/oracle
mount /dev/vgora/lvoragrid /oracle/testdb/oragrid
在/etc/fstab中加上如下内容，让filesystem自动挂载
/dev/vgora/lvoracle   /oracle/testdb/oracle     vxfs delaylog 0 2
/dev/vgora/lvoragrid  /oracle/testdb/oragrid    vxfs delaylog 0 2

node2:
pvcreate -f /dev/rdsk/c2t0d1
vgcreate -s 32 vgora /dev/dsk/c2t0d1
lvcreate -L 40960M -n lvoragrid /dev/vgora
lvcreate -L 40960M -n lvoracle /dev/vgora
newfs -F vxfs /dev/vgora/rlvoracle
newfs -F vxfs /dev/vgora/rlvoragrid
mount /dev/vgora/lvoracle /oracle/testdb/oracle
mount /dev/vgora/lvoragrid /oracle/testdb/oragrid
在/etc/fstab中加上如下内容，让filesystem自动挂载
/dev/vgora/lvoracle   /oracle/testdb/oracle     vxfs delaylog 0 2
/dev/vgora/lvoragrid  /oracle/testdb/oragrid    vxfs delaylog 0 2

9.user环境变量
oracle
export ORACLE_HOME=/oracle/testdb/oracle/DB
export ORACLE_BASE=/oracle/testdb/oracle
export ORACLE_SID=testdb1              #node2  写 export ORACLE_SID=testdb2  
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:/usr/ccs/lib
export PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin:/usr/ccs/bin:/opt/networker/bin:/usr/sbin:$ORACLE_HOME/OPatch:.:

oragrid:
export ORACLE_BASE=/oracle/testdb/oragrid
export ORACLE_HOME=/oracle/testdb/oragrid/grid
export ORACLE_SID=+ASM1                 #node2  写 export ORACLE_SID=+ASM2  
export PATH=$ORACLE_HOME/bin:$PATH


10./etc/hosts配置
node1和node2上都要配置
xxx.xxx.xx.xxx   node1
xxx.xxx.xx.xxx   node2
xxx.xxx.xx.xxx   node1-vip
xxx.xxx.xx.xxx   node2-vip
100.100.100.xxx  node1-priv
100.100.100.xxx  node2-priv
xxx.xxx.xx.xxx   node-scan

添加网络
ifconfig lan900:1 xxx.xxx.xx.xxx  netmask 255.255.255.0

11.grid安装
grid安装弹出ui界面后下一步下一步安装即可。

遇到的问题总结
(1)之前安装了serviceguard，在cluster node information不能添加node的信息。需要删除如下patch
swremove PHSS_43855
swremove PHSS_44469
swremove T1905CA
swremove T1907BA

(2)cluster node information界面ssh不了，提示INS-06001错误。解决方法如下：
INS-06001
existence check failed for /usr/local/bin/bash on node:xxxxx
[xxxxxxx#] which bash
/usr/local/bin/bash
[xxxxxxx#] mv bash bash_20170623
[xxxxxxx#] ln -s /usr/bin/ksh /usr/local/bin/bash
[xxxxxxx#] ls -l
lrwxr-xr-x   1 root       sys             12 Jun 23 14:12 bash -> /usr/bin/ksh

(3)添加网卡界面提示Installer has detected that network interface.
中间做过的操作,一将/tmp目录下oragrid属组的文件全部清除.二重启了server。
然后就好了.不知道做了操作之后有效的。

(4)创建OCR ASM的时候，需要对disk赋予相应的权限。赋予oragrid:oinstall和660权限。
chown oragrid:oinstall /dev/rdsk/c2t1d3
chmod 660 /dev/rdsk/c2t1d3
or
chown oragrid:oinstall /dev/rdisk/disk31
chmod 660 /dev/rdisk/disk31

(5)创建OCR ASM的时候的时候,发现只能识别一部分的disk。
解决方法dd
dd if=/dev/zero of=/dev/rdsk/c2t0d3 bs=1024k count=1000  
后正常识别.

(6)oragrid用下
oragrid home目录和ORACLE_BASE和ORACLE_HOME不能在相同的目录下

(7)执行root.sh的时候一直报如下错误.
ORA-29783: GPnP attribute SET failed with error [CLSGPNP_RD_ERR]
先deconfig操作.
/oracle/testdb/oragrid/11203/grid/crs/install/rootcrs.pl -verbose -deconfig -force
dd清空disk里面的内容
dd if=/dev/zero of=/dev/rdisk/disk29 bs=1024k count=1000
dd if=/dev/zero of=/dev/rdisk/disk30 bs=1024k count=1000
dd if=/dev/zero of=/dev/rdisk/disk31 bs=1024k count=1000
再执行root.sh
/oracle/testdb/oragrid/11203/grid/root.sh

(8)第二个节点执行的时候也报错. CRS-4402
发现两边的private network设置的网络有问题.
重新配置后.执行如下两个脚本正常.
/oracle/testdb/oragrid/11203/grid/crs/install/rootcrs.pl -verbose -deconfig -force
/oracle/testdb/oragrid/11203/grid/root.sh

12.asmca create data/fra diskgroup
oragrid用户下执行asmca调出图形窗口操作就可以了

13.database software安装.
oracle用户下执行./runInstaller下一步下一步操作。

14.接下来就是dbca了.
oracle用户下输入dbca调出ui界面下一步下一步操作.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-2149531/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-2149531/