installeroracle11gr2racforHPunix.docx

installeroracle11gr2racforHPunix.docx

《installeroracle11gr2racforHPunix.docx》由会员分享，可在线阅读，更多相关《installeroracle11gr2racforHPunix.docx（67页珍藏版）》请在冰豆网上搜索。

installeroracle11gr2racforHPunix

oracle11.2.0.3racforhpnuix

电信集成安装配置手册

1.安装前介绍：

平台：

两台HPRX9800型号小机，系统：

HP-UXB.11.31系统，24个1.6GHzCPU，256GB内存

磁盘阵列:

HPP6500

安装数据库软件：

2.环境规划：

　服务器

IP

主机名

属性

型号

ORA-RAC1

192.168.1.11

ora-rac1

Public

HPUX11.31

192.168.1.13

ora-rac1-vip

Vip

10.0.0.11

ora-rac1-priv

Private

ORA-RAC2

192.168.1.12

ora-rac2

Public

HPUX11.31

192.168.1.14

ora-rac2-vip

Vip

10.0.0.22

ora-rac2-priv

　Private

192.168.1.15

scan-cluster

　Scan

3.存储规划

数据库磁盘阵列划分

ASM磁盘组名称

对应的vDisk名

Size

冗余方式

SIZE

说明

OCR

VD01_OCR

5GB

外部

5GB

OracleRACOCR盘

DATA

VD02_DBF

VD03_DBF

VD04_DBF

VD05_DBF

VD06_DBF

500GB

500GB

500GB

500GB

500GB

外部

2.5TB

建立应用数据表空间数据文件

Redo日志文件

控制文件

FRA

VD07_DBF

VD08_DBF

VD09_DBF

VD010_DBF

VD011_DBF

500GB

500GB

500GB

500GB

500GB

外部

2.5TB

建立备份数据文件

Redo日志文件

控制文件

归档日志文件

4.安装前的准备工作

4.1补丁和软件列表如下：

PHCO_4038111.31DiskOwnerPatch

PHKL_38038vmcumulativepatch

PHKL_3893811.31SCSIcumulativeI/Opatch

PHKL_39351Schedulerpatch:

postwaithang

PHSS_3635411.31assemblerpatch

PHSS_3704211.31hppac（packeddecimal）

PHSS_37959Libclpatchforalternatestackissuefix（QXCR1000818011）

PHSS_3909411.31linker+fdpcumulativepatch

PHSS_3910011.31MathLibraryCumulativePatch

PHSS_3910211.31IntegrityUnwindLibrary

PHSS_3814111.31aC++Runtime

还有一个ssh包和bash包最好都能打上。

4.2内核参数设置

kctune-h-Bmaxssiz="134217728"

kctune-h-Bmaxssiz_64bit="1073741824"

kctune-h-Bmaxuprc="3688"

kctune-h-Bmsgmni="4096"

kctune-h-Bmsgtql="4096"

kctune-h-Bncsize="35840"

kctune-h-Bninode="34816"

kctune-h-Bsemmni="4096"

kctune-h-Bsemmns="16384"

kctune-h-Bsemmnu="4092"

kctune-h-Bshmmax="34359738368"

kctune-h-Bshmmni="512"

kctune-h-Bvps_ceiling="64"

kctune-h-Bnproc="4096"

kctune-h-Bmaxfiles_lim="63488"

kctune-h-Bshmmni="4096"

kctune-h-Bshmseg="512"

kctune-h-Btcp_smallest_anon_port="9000"

kctune-h-Btcp_largest_anon_port="65500"

kctune-h-Budp_smallest_anon_port="9000"

kctune-h-Budp_largest_anon_port="65500"

执行完上述命令后一定要重启，不要和更新补丁后在重启。

4.3连接lib文件

cd/usr/lib

lslibX*.sl

ln-slibX11.3libX11.sl

ln-slibXIE.2libXIE.sl

ln-slibXext.3libXext.sl

ln-slibXhp11.3libXhp11.sl

ln-slibXi.3libXi.sl

ln-slibXm.4libXm.sl

ln-slibXp.2libXp.sl

ln-slibXt.3libXt.sl

ln-slibXtst.2libXtst.sl

4.4禁用ntp（前提是没有NTP服务的情况下）

#mv/etc/ntp.conf/etc/ntp.conf.bak

4.4.1调整两个服务器时间一致

#date03262013153300

4.5设置/etc/hosts文件

文件内容与2节内容匹配

127.0.0.1localhostloopback

#fororacle

#public

192.168.1.11ora-rac1

192.168.1.12ora-rac2

#vip

192.168.1.13ora-rac1-vip

192.168.1.14ora-rac2-vip

#private

10.0.0.11ora-rac1-priv

10.0.0.22ora-rac2-priv

#scan

192.168.1.15scan-cluster

4.6初始化用户以及组

#groupaddoinstall

#groupadddba

#useradd-goinstall-Gdba-d/home/oracle-moracle

#useradd-goinstall-Gdba-d/home/grid-mgrid

#passwdoracle

Changingpasswordfororacle

Newpassword:

（oracle）

Re-enternewpassword:

（oracle）

Passwdsuccessfullychanged

#passwdgrid

Changingpasswordfororacle

Newpassword:

（grid）

Re-enternewpassword:

（grid）

Passwdsuccessfullychanged

mkdir-p/u01/app/grid

chmod-R777/u01/app/grid

chown-Rgrid:

oinstall/u01/app/grid

mkdir-p/u01/app/oracle

chmod-R777/u01/app/oracle

chown-Roracle:

oinstall/u01/app/oracle

4.7共享磁盘检查

在节点1:

ora-rac1#[/u01/oracle_11gr2]cd/dev/rdisk

ora-rac1#[/dev/rdisk]ls-lrt

total0

crw-r-----1binsys130x000001Feb613:

26disk1

crw-r-----1binsys130x000003Feb613:

26disk1_p1

crw-r-----1binsys130x000005Feb613:

26disk1_p3

crw-r-----1binsys130x00001dMar2216:

12disk29

crw-r-----1binsys130x00001cMar2216:

12disk28

crw-r-----1binsys130x00001aMar2216:

12disk26

crw-r-----1binsys130x00001bMar2216:

12disk27

crw-r-----1binsys130x000019Mar2216:

12disk25

crw-r-----1binsys130x000018Mar2216:

12disk24

crw-r-----1binsys130x000022Mar2216:

12disk34

crw-r-----1binsys130x000021Mar2216:

12disk33

crw-r-----1binsys130x000020Mar2216:

12disk32

crw-r-----1binsys130x00001fMar2216:

12disk31

crw-r-----1binsys130x00001eMar2216:

12disk30

crw-r-----1binsys130x000023Mar2516:

52disk58

crw-r-----1binsys130x000004Mar2517:

23disk1_p2

确定给oracle使用的磁盘分别是:

disk24----disk34

ora-rac1#[/dev/rdisk]diskinfodisk29

SCSIdescribeofdisk29:

vendor:

HP

productid:

HSV360

type:

directaccess

size:

5242880Kbytes

bytespersector:

512

ora-rac1#[/dev/rdisk]

确定这个磁盘是5G的,这个磁盘做OCR磁盘组

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD01_OCRc130x00001d

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD02_DBFc130x00001c

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD03_DBFc130x00001a

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD04_DBFc130x00001b

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD05_DBFc130x000019

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD06_DBFc130x000018

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD07_DBFc130x000022

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD08_DBFc130x000021

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD09_DBFc130x000020

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD010_DBFc130x00001f

ora-rac1#[/dev/rdisk]mknod/dev/rdisk/VD011_DBFc130x00001e

在节点2:

ora-rac2#[/dev/rdisk]ls-lrt

total0

crw-r-----1binsys130x000001Feb714:

15disk1

crw-r-----1binsys130x000003Feb714:

15disk1_p1

crw-r-----1binsys130x000005Feb714:

15disk1_p3

crw-r-----1binsys130x000022Mar2216:

15disk56

crw-r-----1binsys130x000021Mar2216:

15disk55

crw-r-----1binsys130x000020Mar2216:

15disk54

crw-r-----1binsys130x00001fMar2216:

15disk53

crw-r-----1binsys130x00001eMar2216:

15disk52

crw-r-----1binsys130x00001bMar2216:

15disk49

crw-r-----1binsys130x00001dMar2216:

15disk51

crw-r-----1binsys130x00001cMar2216:

15disk50

crw-r-----1binsys130x00001aMar2216:

15disk48

crw-r-----1binsys130x000019Mar2216:

15disk47

crw-r-----1binsys130x000018Mar2216:

15disk46

crw-r-----1binsys130x000023Mar2516:

08disk58

crw-r-----1binsys130x000004Mar2516:

08disk1_p2

确定给oracle使用的磁盘是：

disk46----disk56

ora-rac2#[/]diskinfo/dev/rdisk/disk51

SCSIdescribeof/dev/rdisk/disk51:

vendor:

HP

productid:

HSV360

type:

directaccess

size:

5242880Kbytes

bytespersector:

512

ora-rac2#[/]

确定这个磁盘是5G的,这个磁盘做OCR磁盘组

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD01_OCRc130x00001d

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD02_DBFc130x00001c

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD03_DBFc130x00001a

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD04_DBFc130x00001b

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD05_DBFc130x000019

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD06_DBFc130x000018

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD07_DBFc130x000022

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD08_DBFc130x000021

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD09_DBFc130x000020

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD010_DBFc130x00001f

ora-rac2#[/dev/rdisk]mknod/dev/rdisk/VD011_DBFc130x00001e

4.8检查异步IO

两个节点都需要设置，不然检查过不去。

#[/]ll/dev/async

crw-rw-rw-1binbin1010x000000Aug2810:

42/dev/async

需要设置

#[/]rm/dev/async

#[/]/sbin/mknod/dev/asyncc1010x4

#[/]chmod666/dev/async

#[/]ll/dev/async

crw-rw-rw-1rootsys1010x000004Aug2814:

14/dev/async

4.9设置环境变量：

su-grid

$vi.profile

添加如下行:

exportORACLE_BASE=/u01/app/grid/base

exportORACLE_HOME=/u01/app/grid/11.2.0

exportORACLE_SID=+ASM1

exportORACLE_UNQNAME=orcl

exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK

exportORACLE_HOSTNAME=ora-rac1

exportPATH=$ORACLE_HOME/bin:

.:

$PATH

umask022

su-oracle

$vi.profile

添加如下行：

exportORACLE_BASE=/u01/app/oracle

exportORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

exportORACLE_SID=orcl1

exportORACLE_UNQNAME=orcl

exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK

exportORACLE_HOSTNAME=ora-rac1

exportPATH=$ORACLE_HOME/bin:

.:

$PATH

umask022

4.10配置ssh互信关系：

1）.在主节点ora-rac1上以grid用户身份生成用户的公匙和私匙

#pingora-rac2

#pingora-rac2-priv

#su–grid

$mkdir~/.ssh

$ssh-keygen-trsa

$ssh-keygen-tdsa

2）.在副节点ora-rac2上执行相同的操作，确保通信无阻

#pingora-rac1

#pingora-rac1-pri

#su–grid

$mkdir~/.ssh

$ssh-keygen-trsa

$ssh-keygen-tdsa

3）.在主节点ora-rac1上grid用户执行以下操作

$cat~/.ssh/id_rsa.pub>>./.ssh/authorized_keys

$cat~/.ssh/id_dsa.pub>>./.ssh/authorized_keys

$sshora-rac2cat~/.ssh/id_rsa.pub>>~/.ssh/authorized_keys

$sshora-rac2cat~/.ssh/id_dsa.pub>>~/.ssh/authorized_keys

$scp~/.ssh/authorized_keysora-rac2:

~/.ssh/authorized_keys

5.安装前的检查：

$cd/soft/oracle/grid

$ls

docinstallreadme.htmlresponserpmrunInstallerruncluvfy.shsshsetupstagewelcome.html

$./runcluvfy.shstage-precrsinst-nora-rac1,ora-rac2-verbose

Performingpre-checksforclusterservicessetup

Checkingnodereachability...

Check:

Nodereachabilityfromnode"ora-rac1"

DestinationNodeReachable?

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

ora-rac1yes

ora-rac2yes

Result:

Nodereachabilitycheckpassedfromnode"ora-rac1"

Checkinguserequivalence...

Check:

Userequivalenceforuser"grid"

NodeNameStatus

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

ora-rac2passed

ora-rac1passed

Result:

Userequivalencecheckpassedforuser"grid"

Checkingnodeconnectivity...

Checkinghostsconfigfile...

NodeNameStatus

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

ora-rac2passed

ora-rac1passed

Verificationofthehostsconfigfilesuccessful

Interfaceinformationfornode"o