数据库集群部署.docx

数据库集群部署.docx

《数据库集群部署.docx》由会员分享，可在线阅读，更多相关《数据库集群部署.docx（56页珍藏版）》请在冰点文库上搜索。

数据库集群部署

1.1ORACLEGI安装

1.1.1创建OCR，VOTEDISK和ORADATA磁盘

注意：

一下磁盘划分是根据某局某处安装编写的文档，其中磁盘组和逻辑卷的命名都统一，只有磁盘设备的选择需要根据各点的具体情况来划分。

在sfrac1节点执行

创建磁盘组

[root@sfrac1~]#vxdg-sinitocrvotedgaluadisk0_4

[root@sfrac1~]#vxdg-sinitoradatadgaluadisk0_1

[root@sfrac1~]#vxdg-sinitftpdgaluadisk0_5

[root@sfrac1~]#vxdg-sinitdbbakdgaluadisk0_10

[root@sfrac1~]#vxdg-sinitftpbakdgaluadisk0_11

[root@sfrac1~]#vxdg-sinitoradatadgudaluadisk0_13

[root@sfrac1~]#vxdg-sinitftpdgudaluadisk0_14

[root@sfrac1~]#vxdg-sinitocrvotedgudaluadisk0_1

分别创建逻辑卷

[root@sfrac1~]#vxassist-gocrvotedgmakeocrvotevolmaxsize

[root@sfrac1~]#vxassist-goradatadgmakeoradatavolmaxsize

[root@sfrac1~]#vxassist-gftpdgmakeftpvolmaxsize

[root@sfrac1~]#vxassist-gdbbakdgmakedbbakvolmaxsize

[root@sfrac1~]#vxassist-gftpbakdgmakeftpbakvolmaxsize

[root@sfrac1~]#vxassist-goradatadgudmakeoradatavoludmaxsize

[root@sfrac1~]#vxassist-gftpdgudmakeftpvoludmaxsize

[root@sfrac1~]#vxassist-gocrvotedgudmakeocrvotevoludmaxsize

启动卷

[root@rac1~]#vxvol-gocrvotedgstartall

[root@rac1~]#vxvol-goradatadgstartall

[root@sfrac1~]#vxvol-gftpdgstartall

[root@sfrac1~]#vxvol-gdbbakdgstartall

[root@sfrac1~]#vxvol-gftpbakdgstartall

[root@sfrac1~]#vxvol-goradatadgudstartall

[root@sfrac1~]#vxvol-gftpdgudstartall

[root@sfrac1~]#vxvol-gocrvotedgudstartall

1.1.2创建文件系统并挂载

创建文件系统并挂载在同一挂载点

在一个节点上执行

mkfs-tvxfs/dev/vx/rdsk/ocrvotedg/ocrvotevol

mkfs-tvxfs/dev/vx/rdsk/oradatadg/oradatavol

mkfs-tvxfs/dev/vx/rdsk/ftpdg/ftpvol

mkfs-tvxfs/dev/vx/rdsk/ftpbakdg/ftpbakvol

mkfs-tvxfs/dev/vx/rdsk/dbbakdg/dbbakvol

mkfs-tvxfs/dev/vx/rdsk/oradatadgud/oradatavolud

mkfs-tvxfs/dev/vx/rdsk/ftpdgud/ftpvolud

mkfs-tvxfs/dev/vx/rdsk/ocrvotedgud/ocrvotevolud

在所有节点上执行

mkdir/ocr

mkdir/oradata

mkdir/ftp

mkdir/ftpbak

mkdir/dbbak

mount-tvxfs-ocluster/dev/vx/dsk/ocrvotedg/ocrvotevol/ocr

mount-tvxfs-ocluster/dev/vx/dsk/oradatadg/oradatavol/oradata

mount-tvxfs-ocluster/dev/vx/dsk/ftpdg/ftpvol/ftp

mount-tvxfs-ocluster/dev/vx/dsk/ftpbakdg/ftpbakvol/ftpbak/

mount-tvxfs-ocluster/dev/vx/dsk/dbbakdg/dbbakvol/dbbak/

确认配置成功

df-k

1.1.3将ocr和vote添加到VCS资源组

修改VCS配置为读写权限

haconf-makerw

配置加入CVM资源组

hares-addocrvote_voldg_ocrvotedgCVMVolDgcvm

hares-modifyocrvote_voldg_ocrvotedgCritical0

hares-modifyocrvote_voldg_ocrvotedgCVMDiskGroupocrvotedg

hares-modifyocrvote_voldg_ocrvotedgCVMVolume-addocrvotevol

hares-modifyocrvote_voldg_ocrvotedgCVMActivationsw

VCS下配置文件系统

hares-addocrvote_mnt_ocrvotedgCFSMountcvm

hares-modifyocrvote_mnt_ocrvotedgCritical0

hares-modifyocrvote_mnt_ocrvotedgMountPoint"/ocr"

hares-modifyocrvote_mnt_ocrvotedgBlockDevice\

"/dev/vx/dsk/ocrvotedg/ocrvotevol"

链接资源关系

hares-linkocrvote_voldg_ocrvotedgcvm_clus

hares-linkocrvote_mnt_ocrvotedgocrvote_voldg_ocrvotedg

hares-linkocrvote_mnt_ocrvotedgvxfsckd

开启资源

hares-modifyocrvote_voldg_ocrvotedgEnabled1

hares-modifyocrvote_mnt_ocrvotedgEnabled1

修改VCS配置为只读

haconf-dump-makero

将资源启动

hares-onlineocrvote_voldg_ocrvotedg-syssfrac1

hares-onlineocrvote_voldg_ocrvotedg-syssfrac2

hares-onlineocrvote_mnt_ocrvotedg-syssfrac1

hares-onlineocrvote_mnt_ocrvotedg-syssfrac2

确认资源已经在每个节点启动

hares-stateocrvote_voldg_ocrvotedg

hares-stateocrvote_mnt_ocrvotedg

每个节点修改权限

[root@rac1opt]#chown-Rgrid:

oinstall/ocr

[root@rac1opt]#chown-Roracle:

oinstall/oradata/

正确配置截图

所有组合资源online

1.1.4使用oracleOUI安装GI

上传安装包

p13390677_112040_Linux-x86-64_3of7.zip

至rac1下面的/opt目录

解压

unzipp13390677_112040_Linux-x86-64_3of7.zip

生成grid目录

通过本地图形界面安装或者使用Xmanger4远程安装。

使用grid用户运行命令

/opt/grid/runInstaller

跳过更新

安装和配置GI

高级安装

英语

配置scan

配置ssh等价

点击sshConnectivity输入grid用户密码，点击setup

配置成功，ok，下一步

确定接口类型

ocr和votingdisk存储类型，选择sfs

制定ocr存储位置，选择外部冗余，位置为之前挂载的/ocr，取名为ocr

确定votingdisk位置，和ocr一样，放在/ocr/vote

不使用IPMI

默认的组权限

确定安装位置

默认的位置安装历史信息文件

先决条件检查，此次安装将只有PDKSH包问题

总览

安装中，大概5分钟左右，会提示脚本执行

每个节点分别执行脚本

先在主节点rac1上脚本执行

[root@sfrac1opt]#/u01/app/oraInventory/orainstRoot.sh

Changingpermissionsof/u01/app/oraInventory.

Addingread,writepermissionsforgroup.

Removingread,write,executepermissionsforworld.

Changinggroupnameof/u01/app/oraInventorytooinstall.

Theexecutionofthescriptiscomplete.

执行第二个脚本信息较多，且时间比较长，大概需要5分钟

[root@sfrac1lib64]#/u01/app/11.2.4/grid/root.sh

PerformingrootuseroperationforOracle11g

Thefollowingenvironmentvariablesaresetas:

ORACLE_OWNER=grid

ORACLE_HOME=/u01/app/11.2.4/grid

Enterthefullpathnameofthelocalbindirectory:

[/usr/local/bin]:

Thecontentsof"dbhome"havenotchanged.Noneedtooverwrite.

Thecontentsof"oraenv"havenotchanged.Noneedtooverwrite.

Thecontentsof"coraenv"havenotchanged.Noneedtooverwrite.

Entrieswillbeaddedtothe/etc/oratabfileasneededby

DatabaseConfigurationAssistantwhenadatabaseiscreated

Finishedrunninggenericpartofrootscript.

Nowproduct-specificrootactionswillbeperformed.

Usingconfigurationparameterfile:

/u01/app/11.2.4/grid/crs/install/crsconfig_params

UserignoredPrerequisitesduringinstallation

InstallingTraceFileAnalyzer

OLRinitialization-successful

rootwallet

rootwalletcert

rootcertexport

peerwallet

profilereaderwallet

pawallet

peerwalletkeys

pawalletkeys

peercertrequest

pacertrequest

peercert

pacert

peerrootcertTP

profilereaderrootcertTP

parootcertTP

peerpacertTP

papeercertTP

profilereaderpacertTP

profilereaderpeercertTP

peerusercert

pausercert

AddingClusterwareentriestoupstart

CRS-2672:

Attemptingtostart'ora.mdnsd'on'rac1'

CRS-2676:

Startof'ora.mdnsd'on'rac1'succeeded

CRS-2672:

Attemptingtostart'ora.gpnpd'on'rac1'

CRS-2676:

Startof'ora.gpnpd'on'rac1'succeeded

CRS-2672:

Attemptingtostart'ora.cssdmonitor'on'rac1'

CRS-2672:

Attemptingtostart'ora.gipcd'on'rac1'

CRS-2676:

Startof'ora.cssdmonitor'on'rac1'succeeded

CRS-2676:

Startof'ora.gipcd'on'rac1'succeeded

CRS-2672:

Attemptingtostart'ora.cssd'on'rac1'

CRS-2672:

Attemptingtostart'ora.diskmon'on'rac1'

CRS-2676:

Startof'ora.diskmon'on'rac1'succeeded

CRS-2676:

Startof'ora.cssd'on'rac1'succeeded

clscfg:

-installmodespecified

SuccessfullyaccumulatednecessaryOCRkeys.

CreatingOCRkeysforuser'root',privgrp'root'..

Operationsuccessful.

Nowformattingvotingdisk:

/ocr/vote.

CRS-4603:

Successfuladditionofvotingdisk/ocr/vote.

##STATEFileUniversalIdFileNameDiskgroup

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

1.ONLINE185d782f2b154f1dbf993fbd75a4018b（/ocr/vote）[]

Located1votingdisk（s）.

Located1votingdisk（s）.

Preparingpackagesforinstallation...

cvuqdisk-1.0.9-1

ConfigureOracleGridInfrastructureforaCluster...succeeded

在rac2上执行脚本

[root@sfrac2~]#/u01/app/oraInventory/orainstRoot.sh

Changingpermissionsof/u01/app/oraInventory.

Addingread,writepermissionsforgroup.

Removingread,write,executepermissionsforworld.

Changinggroupnameof/u01/app/oraInventorytooinstall.

Theexecutionofthescriptiscomplete.

第二个脚本

[root@sfrac2~]#/u01/app/11.2.4/grid/root.sh

PerformingrootuseroperationforOracle11g

Thefollowingenvironmentvariablesaresetas:

ORACLE_OWNER=grid

ORACLE_HOME=/u01/app/11.2.4/grid

Enterthefullpathnameofthelocalbindirectory:

[/usr/local/bin]:

Copyingdbhometo/usr/local/bin...

Copyingoraenvto/usr/local/bin...

Copyingcoraenvto/usr/local/bin...

Creating/etc/oratabfile...

Entrieswillbeaddedtothe/etc/oratabfileasneededby

DatabaseConfigurationAssistantwhenadatabaseiscreated

Finishedrunninggenericpartofrootscript.

Nowproduct-specificrootactionswillbeperformed.

Usingconfigurationparameterfile:

/u01/app/11.2.4/grid/crs/install/crsconfig_params

Creatingtracedirectory

UserignoredPrerequisitesduringinstallation

InstallingTraceFileAnalyzer

OLRinitialization-successful

AddingClusterwareentriestoupstart

CRS-4402:

TheCSSdaemonwasstartedinexclusivemodebutfoundanactiveCSSdaemononnoderac1,number1,andisterminating

Anactiveclusterwasfoundduringexclusivestartup,restartingtojointhecluster

Preparingpackagesforinstallation...

cvuqdisk-1.0.9-1

ConfigureOracleGridInfrastructureforaCluster...succeeded

节点执行完毕后点击确定，继续安装

配置DNS之后，CVU检查将通过。

至此，oracleGI安装完成。

1.1.5使用SF脚本配置CSSD资源

运行脚本

[root@sfrac1lib64]#/opt/VRTS/install/installsfrac61-configure

选择节点rac1rac2，之后检查节点通信

选择4

选择1，配置CSSD代理

确认信息及GI的home

配置CSSD

配置完成选择3退出

1.1.6更新CSSmiscount和防止GI自动启动

检查当前CSSmiscount

[root@sfrac1lib64]#/u01/app/11.2.4/grid/bin/crsctlgetcssmisscount

CRS-4678:

Successfulgetmisscount600forClusterSynchronizationServices.

如果不是600秒，则需要更新

[root@sfrac1lib64]#/u01/app/11.2.4/grid/bin/crsctlsetcssmisscount600

防止GI开机启动

每个节点执行

[root@sfrac1lib64]#/u01/app/11.2.4/grid/bin/crsctldisablecrs

CRS-4621:

OracleHighAvailabilityServicesautostartisdisabled.

[root@sfrac2~]#/u01/app/11.2.4/grid/bin/crsctldisablecrs

CRS-4621:

OracleHighAvailabilityServicesautostartisdisabled.

1.1.7ORACLE数据库软件安装

上传安装包

p13390677_112040_Linux-x86-64_1of7.zip

p13390677_112040_Linux-x86-64_2of7.zip

至rac1下面的/opt目录

解压

unzipp13390677_112040_Linux-x86-64_1of7.zip

unzipp13390677_112040_Linux-x86-64_2of7.zip

解压到database目录

通过本地图形界面安装或者使用Xmanger4远程安装。

使用oracle用户运行命令

/opt/database/runInstaller

取消接收安全信息

点击YES，跳过警告

取消更新

只安装数据库软件，不创建数据库

选择RAC安装，设置ssh等价关系

英语

安装企业版，同时勾选全部组件

确认oraclebase和oraclehome

默认组权限

先决条件检查，忽略全部，跳出提示，点击YES

总览然后安装，大约3分钟

每个节点分别执行脚本

sfrac1执行脚本

[root@sfrac1~]#/u01/app/oracle/product/11.2.4/