10.2.0.1g+RAC+裸设备+aix6106+HACMP5.4

  • A+
所属分类:技术

SILU

注意:创建(hagsuser)组,然后oracle用户属于hagsuser组,xlc版本必须大于7.0。安装rootpre补丁p6718715_10203_AIX64-5L.zip,才能看见节点。在hacmp中的主机名和节点名要一样。

环境描述

YINGJIANHUANJING:LIANGJIEDIANIBM P550

CAOZUOXITONG:AIX6106

WANGLUOPEIZHI:/etc/hosts

192.168.1.205 aix205

192.168.1.207 aix207

10.10.10.205 aix205priv

10.10.10.207 aix207priv

192.168.1.215 aix205vip

192.168.1.217 aix207vip

1.ANZHUANGQIANZHUNBEIGONGZUO

ZAIMEIGEJIEDIANSHANGZHIXINGRUXIABUZHOU:

1、 CHUANGJIANdbaZU;mkgroup -'A' id='502' dba

2、 CHUANGJIANoinstallZU;mkgroup -'A' id='501' oinstall

3、 CHUANGJIANhagsuserZU,(GAIZUYEHUIZAIANZHUANGCRSGUOCHENGZHONG,ZHIXINGrootpre.shHUIZIDONGCHUANGJIANGAIZU,DANXUYAOQUERENMEIGEJIEDIANSHANGDEZUIDXIANGTONG,BINGTONGGUOSHOUGONGJIANGoracleYONGHUJIARUGAIZU);mkgroup -'A' id='503' hagsuser

4、 CHUANGJIANoracleYONGHU,JIANGoracleYONGHUJIADAOSHANGSHUZUZHONG;

mkuser id='502' pgrp='dba' groups='oinstall,dba,hagsuser' home='/home/oracle' fsize=-1 cpu=-1 data=-1 rss=-1 stack=-1 stack_hard=-1 oracle

 

chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid

$ id

uid=502(oracle)gid=501(oinstall) groups=1(staff),502(dba),503(hagsuser)

ZHUYI:QINGBAOZHENGZAISUOYOUJIEDIANSHANGSHANGSHUZUHEYONGHUDEIDXIANGTONG。

 

2、ZAIMEIGEJIEDIANSHANGXIUGAIoracleYONGHU.profile,XUBAOHANRUXIANEIRONG

export ORACLE_BASE=/oracle/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export ORACLE_SID=ocp

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

. ./.profile

 

  • 在每个节点上修改系统核心参数

vmo -p -o minperm%=3

vmo -p -o maxperm%=90

vmo -p -o maxclient%=90

vmo -p -o lru_file_repage=0

vmo -p -o strict_maxclient=1

vmo -p -o strict_maxperm=0

4、ZAIMEIGEJIEDIANSHANGXIUGAIYONGHUYUNXUDEZUIDAJINCHENGSHU,YIrootYONGHUZHIXINGsmitty chgsys

chdev -l sys0 -a maxuproc=16384

chdev -l sys0 -a ncargs=256

5、在每个节点上检查需要安装的系统包

lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat\

bos.perf.perfstat bos.perf.proctools rsct.basic.rte \

6、ZHUANGHACMP,ZAIMEIGEJIEDIANSHANGHAIYAOJIANCHA:

lslpp -l bos.clvm.enh bos.data rsct.basic.hacmp rsct.compat.basic.hacmp \

rsct.compat.clients.hacmp bos.cifs_fs.rte

7、ZAIMEIGEJIEDIANSHANGXIUGAIoracleYONGHUDEZIYUANXIANZHI,ZAIMEIGEJIEDIANSHANGXIUGAIWENJIAN/etc/security/limits,defaultDOUSHEZHIWEI-1,NEIRONGRUXIA:

default:

fsize = -1

core = -1

cpu = -1

data = -1

rss = -1

stack = -1

nofiles = -1

 

8、ZAIMEIGEJIEDIANSHANGDIAOZHENGWANGLUOCANSHU,BINGZHONGQIXITONGSHENGXIAO

no -p -o udp_sendspace=65536

no -p -o udp_recvspace=65536

no -p -o tcp_sendspace=65536

no -p -o tcp_recvspace=65536

no -p -o rfc1323=1

no -p -o sb_max=1310720

no -r -o ipqmaxlen=512

  • 在每个节点上创建Oracle软件安装目录或文件系统

mkdir -p /oracle/app/oracle

chown -R oracle.dba /oracle/app/oracle

chmod -R 775 /oracle/app/oracle

ANZHUANGHARUANJIAN、DAhaBUDING、PEIZHIhaRUANJIAN、QIDONGhaRUANJIAN,JIHUOBINGFAJUANZU DATAVG

TIANJIAYIGEJIQUN:

 

 

 

 

TIANJIAJIEDIAN:FENBIETIANJIALIANGGE

 

 

 

FAXIANYIXIA:

 

TIANJIAYIGEGONGWANGWANGLUO:

 

 

 

 

TIANJIAYIGESIWANGWANGLUO:

 

 

 

 

TIANJIAWANGKA:

 

 

 

 

 

 

 

 

TIANJIAZIYUANZU:

 

 

10.2.0.1g+RAC+裸设备+aix6106+HACMP5.4

 

 

 

PEIZHIWANCHENG,KAISHITONGBU:

 

QIDONGJIQUNFUWU:

 

 

hacmp 在某个节点当掉后,如果想重启,必须先停掉另外一个节点的ha,然后同时重启两个节点的hacmp,才能正常启动两个。配置完成最后重启节点。

  • 在concurrent VG上创建裸设备(lv),包含给CRS使用的和给数据库使用的

LV;

mklv -T O -w n -s n -r n -y rac_ocr racvg 500M

mklv -T O -w n -s n -r n -y rac_vote racvg 500M

mklv -T O -w n -s n -r n -y rac_system racvg 1024M

mklv -T O -w n -s n -r n -y rac_sysaux racvg 1024M

mklv -T O -w n -s n -r n -y rac_undotbs1 racvg 1024M

mklv -T O -w n -s n -r n -y rac_undotbs2 racvg 1024M

mklv -T O -w n -s n -r n -y rac_temp racvg 500M

mklv -T O -w n -s n -r n -y rac_example racvg 400M

mklv -T O -w n -s n -r n -y rac_users racvg 1024M

mklv -T O -w n -s n -r n -y rac_redo11 racvg 150M

mklv -T O -w n -s n -r n -y rac_redo12 racvg 150M

mklv -T O -w n -s n -r n -y rac_redo13 racvg 150M

mklv -T O -w n -s n -r n -y rac_redo21 racvg 150M

mklv -T O -w n -s n -r n -y rac_redo22 racvg 150M

mklv -T O -w n -s n -r n -y rac_redo23 racvg 150M

mklv -T O -w n -s n -r n -y rac_control01 racvg 110M

mklv -T O -w n -s n -r n -y rac_control02 racvg 110M

mklv -T O -w n -s n -r n -y rac_control03 racvg 110M

mklv -T O -w n -s n -r n -y rac_spfile racvg 100M

mklv -T O -w n -s n -r n -y rac_pwdfile racvg 100M

CHUANGJIANHAOHOU,XIUGAILUOSHEBEIQUANXIAN(ZAIMEIGEJIEDIANSHANGZUO)

chown oracle:dba /dev/rrac_*

chmod 660 /dev/rrac_*(CUOWUDEQUANXIANFUZHI)【oracleGUANFANGGUIDINGSHI660,XUGENJUJUTIQINGKUANGERDING】

BIXUXIUGAICHENGRUXIAGESHI

chmod 666 /dev/rrac_*

ZHU:CICHUBIXUXIUGAILUOSHEBEIDEZHIXINGQUANXIANWEI666,RUGUOSHI660NEIMEZAIZUIHOUPAOroot.shJIAOBENJIEDUAN

format voteing diskSHIKAZHUYIZHIBUDONG,YUANYINSHIrootYONGHUMEIYOUXIELUOSHEBEIDEQUANXIAN。BUNENGformat

LUOSHEBEI/dev/rrac_vote,SUOYIYIZHIKAZAIPAOJIAOBENJIEDUANBUDONGDAN。

RUGUOQUANXIANSHI660,NEIMEZUIHOUHUIDANCHULIANGGEJIAOBEN:oraRoot.shHEroot.sh

DIYIGEJIAOBENSHIXIUGAI/dev/rrac_voteDESHUZHUHEDUXIEQUANXIAN

DIERGEJIAOBENSHIZHIXINGformat voteing diskHEPEIZHIvipDE

ZAIlinuxXIALUOSHEBEIQUANXIANSHI660KEYIZHENGCHANGZHIXINGYISHANGLIANGGEJIAOBEN,DANSHIZAIaixXIAJIUBUNENGZHIXINGDI   ERGEJIAOBEN,YUANYINSHIDIYIGEJIAOBENJIUBUNENGCHENGGONGXIUGAI/dev/rrac_voteDESHUZHUHEQUANXIAN。SUOYIBIXUXIU    GAICHENGRUXIAGESHI:

crw-rw-rw-    1  oracle     dba          77,  1 Mar 15 20:17 /dev/rrac_ocr

crw-rw-rw-    1  oracle     dba          77,  2 Mar 15 20:17 /dev/rrac_vote

 

WEILEJIANKUJIANDAN,KECHUANGJIANRaw LVYUOracleSHUJUWENJIANDEYINGSHEPEIZHIWENJIANraw.conf,NEIRONGRUXIA:

system=/dev/rrac_system

sysaux=/dev/rrac_sysaux

undotbs1=/dev/rrac_undotbs1

undotbs2=/dev/rrac_undotbs2

temp=/dev/rrac_temp

example=/dev/rrac_example

users=/dev/rrac_users

redo1_1=/dev/rrac_redo11

redo1_2=/dev/rrac_redo12

redo1_3=/dev/rrac_redo13

redo2_1=/dev/rrac_redo21

redo2_2=/dev/rrac_redo22

redo2_3=/dev/rrac_redo23

control1=/dev/rrac_control01

control2=/dev/rrac_control02

control3=/dev/rrac_control03

spfile=/dev/rrac_spfile

pwdfile=/dev/rrac_pwdfile

BAraw.confWENJIANQUANXIANXIUGAIYIXIA

chown oracle:dba raw.conf

chmod 755 raw.conf

12、PEIZHIHUXIN:LIANGJIEDIANFENBIEYAOZUO

切换到oracle用户,编译 .rhosts 文件中填加一个+

YONGoracleYONGHUFENBIEZAILIANGJIEDIANTUXINGZHONGDUANDENGLUXIUGAIMIMA

vi .dtprofile BAZUIHOUYIXINGQIANMIANDE#QUDIAO

  • 安装ClusterWare软件

1.SHANGCHUAN10gr2_aix5l64_cluster.cpio.gz、p6718715_10203_AIX64-5L.zipJIEZHI,BINGJIEYA

unzip p6718715_10203_AIX64-5L.zip

gunzip 10gr2_aix5l64_cluster.cpio.gz

cpio -idcmv < 10gr2_aix5l64_cluster.cpio

2.SHOUXIANZAIMEIGEJIEDIANSHANGYIrootYONGHUZHIXINGrootpre.sh(patch 6718715ZHONGDErootpre.sh,ERFEIJIEZHIZHONGDErootpre.sh), RANHOUZAIYIGEJIEDIANZHIXINGrunInstallerKAISHIZHENGSHIcrsANZHUANG

./rootpre.sh    (rootYONGHU)

./runInstaller (oracleYONGHU)

3.CHENGGONGANZHUANGHOU,ZAIMEIGEJIEDIANFENBIEZHIXINGorainstRoot.shHEroot.shJIAOBEN,RUGUOZHIXINGroot.shBAOCUOZHEISHIvipcaDEbugDAOZHI,CUOWUXINXIRUXIA:

Running vipca(silent) for configuring nodeapps  The given interface(s), "en0" is not public. Public interfaces should be used to configure virtual IPs.

4.SHOUDONGPEIZHICRSFUWU

$ORA_CRS_HOME/bin/vipca

XUANZEYIGEWANGKAen0,SHURUJIEDIANVIPMINGCHENG,DIANok。

5.FANHUIZHIQIANTUXINGCHUANGKOU,DIANQUEDINGTUICHU,WANCHENGcrsANZHUANG。

ZHU:YI、BIXUXIANZHIXINGRUXIAZHILING

[root@rac1 bin]#./oifcfg setif -global eth0/172.168.12.0:public

[root@rac1 bin]#./oifcfg setif -global eth1/192.168.1.0:cluster_interconnect

[root@rac1 bin]#./oifcfg getif

 

RANHOUCAINENGDIAOYONGvipcaTUXINGJIEMIAN,PEIZHIvip,FOUZEBAOCUO: private_inconnect null

ER、RUGUOXIANZHIXINGLEvipcaDIAOYONGLETUXINGJIEMIAN,BINGQIEPEIZHIWANLEvip。NEIMEXUYAOZHIXINGYIBIANYISHANGZHILING

[root@rac1 bin]#./oifcfg setif -global eth0/172.168.12.0:public

[root@rac1 bin]#./oifcfg setif -global eth1/192.168.1.0:cluster_interconnect

[root@rac1 bin]#./oifcfg getif

然后重新运行下vipca图形界面,重新再配置一遍vip

 

 

 

  • 安装DataBase软件

1.SHANGCHUAN10gr2_aix5l64_database.cpio.gzJIEZHI,BINGJIEYA

gunzip 10gr2_aix5l64_database.cpio.gz

cpio -idcmv < 10gr2_aix5l64_database.cpio

2.JINRUJIEYAMULUZHIXINGrunInstallerKAISHIANZHUANG

./runInstaller

3.成功安装后,在每个节点分别执行root.sh脚本,完成database安装

  • 创建监听服务,选择所有节点

netca

  • 创建数据库

dbca

更多资讯请关注漫兮网http://stpetemountainboys.com

免责声明

发文时比特币价格:$10078

当前比特币价格: $18,410.13

当前比特币涨幅: 2.41%

免责声明:

本文不代表漫兮网立场,且不构成投资建议,请谨慎对待。用户由此造成的损失由用户自行承担,与漫兮网没有任何关系;

漫兮网不对网站所发布内容的准确性,真实性等任何方面做任何形式的承诺和保障;

网站内所有涉及到的区块链(衍生)项目,漫兮网对项目的真实性,准确性等任何方面均不做任何形式的承诺和保障;

网站内所有涉及到的区块链(衍生)项目,漫兮网不对其构成任何投资建议,用户由此造成的损失由用户自行承担,与漫兮网没有任何关系;

漫兮区块链研究院声明:漫兮区块链研究院内容由漫兮网发布,部分来源于互联网和行业分析师投稿收录,内容为漫兮区块链研究院加盟专职分析师独立观点,不代表漫兮网立场。

本文是全系列中第15 / 32篇:区块链技术

  • 我的微信
  • 这是我的微信扫一扫
  • weinxin
  • App下载
  • 漫兮网App下载
  • weinxin
漫兮

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: