aix安装oracle10g rac,AIX中安装oracle 10G RAC的系统需求-oracle官方给的 - rocole...

AIX中安装oracle 10G RAC的系统需求-oracle官方给的

2010-09-17 21:35:49|  分类： Oracle 阅读198 评论0字号：大中小

AIX中安装oracle 10G RAC的系统需求-oracle官方给的

硬件配置

两个节点,每个节点的硬件要求如下:

硬件         要求

物理内存        大于500MB

交换区        If RAM = 1024MB to 2048Mb

then 1.5 times RAM

elseif RAM > 2048MB and < 8192MB

then match RAM

else RAM > 8192MB

then .75 times RAM

当前系统SWAP为4096MB

/tmp大小        大于1000MB

Oracle安装目录文件系统空间        15GB，建议客户最好设置为20GB

软件配置

软件        基本情况

操作系统patches         客户安装AIX 5L V5.3 TL06 – or higher, must be installed. (Specifically bos.rte.lvm 5.3.0.60 – or higher (参考metalink：Note:404474.1和Note:282036.1)

Cluster Software        HACMP5.3：建议使用SP6, (APAR IZ07791).

o  5.3 SP5 and APAR IZ01809 and cluster.es.clvm at a MINIMUM or

5.3 SP6 or newer with cluster.es.clvm installed.

并注意创建hagsuser组，保证两个节点该组的组号相同。

且两个节点设置root/oracle属于该组。

RSCT

(component of AIX):        The minimum level for RSCT (rsct.basic.rte) must be:

RSCT V2.4.7.3 plus the patch for IZ01838

-or-

RSCT V2.4.8.1 – or higher.

操作系统        64bit Kernel

AIX jdk & JRE        SDK 1.4 64-bit 1.4.2.1 IY63533

SDK 1.4 32-bit 1.4.2.2 IY65305

SDK 1.3.1.16 32-bit IY58350

系统包        bos.cifs_fs.rte(建议客户安装该包，否则Oracle安装时会报错。)

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.perfstat

bos.perf.libperfstat

bos.perf.proctools

rsct.basic.rte (For RAC configurations only)

rsct.compat.clients.rte (For RAC configurations only)

xlC.aix50.rte:7.0.0.4

xlC.rte:7.0.0.1

vacpp.cmp.core:7.0.0.2

./runcluvfy.sh 程序安装前验证需要安装的系统包和patch

(如果没有该包或patch需找出其升级版本)        vacpp.cmp.core:7.0.0.2

vac.C:7.0.0.2

xlC.aix50.rte:7.0.0.4

xlC.rte:7.0.0.1

gpfs.base:2.3.0.3

cluster.license:5.2.0.0

ElectricFence-2.2.2-1:2.2.2

xlfrte:9.1

gdb-6.0-1:6.0

make-3.80-1:3.80

freeware.gnu.tar.rte:1.13.0.0

Java14_64.sdk:1.4.2.1

Java131.rte.bin:1.3.1.16

Java14.sdk:1.4.2.2

mqm.server.rte:5.3

mqm.client.rte:5.3

sna.rte:6.1.0.4

bos.net.tcp.server

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

rsct.basic.rte

perl.rte:5.0005

perl.rte:5.6

perl.rte:5.8

python-2.2-4:2.2

freeware.zip.rte:2.3

freeware.gcc.rte:3.3.2.0

######## patch

IY65361

IY63969

IY69911

IY70276

IY60759

IY61034

IY61770

IY62191

IY65305

IY58350

IY63533

IY44599

IY60930

IY58143

IY66513

IY70159

IY59386

Metalink上建议的patch

(供参考，需结合应用系统)        --Metalink Note:169706.1  Database on AIX?,HP-UX?,Linux?,Mac OS? X,Solaris?,Tru64 Unix? Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.1)

Type:  BULLETIN   Last Revision Date:  09-OCT-2008

IY58143

IY68989

IY94343  Note 422031.1 LV Block Corruption

IY89080 Patch 5496862 is required (See Note 390656.1) if running on AIX 5.3 ML5

--Metlink Note:282036.1 Minimum Software Versions and Patches Required to Support Oracle Products on IBM pSeries

Type:  BULLETIN   Last Revision Date:  02-JUN-2008

IY68874: An application that is run wtyle='font-size:10.5pt'>

IY89080:All Oracle 9i Database and Oracle 10g Database customers who are running on AIX 5L V5.3 Technology Level 5 (TL 5300-05) must install the IBM AIX PTF for APAR IY89080 In addition, Oracle customers should contact Oracle support to obtain the fix for Oracle Bug 5496862.

IZ03260: LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR APPLIES TO AIX 5300-06 (for AIX 5.3 TL06 customers)

IZ03475: LIO_LISTIO FAILS TO UPDATE AIO CONTROL BLOCKS ON ERROR APPLIES TO AIX 5300-07 (for AIX 5.3 TL07 customers).如果是5307则需要

操作系统配置情况

1、        确认异步I/O

=========================================================================

smitty aio

2、网络参数配置：

=========================================================================

ipqmaxlen                                      512

rfc1323                                              1

sb_max                                             41943040

tcp_recvspace                 1048576

tcp_sendspace                 1048576

udp_recvspace                  10485760

udp_sendspace                           1048576

Note: The recommended value of this parameter is 10 times the value of the udp_sendspace

parameter. The value must be less than the value of the sb_max parameter.

udp_sendspace                 1048576

Note: This value is suitable for a default database installation. For production databases, the minimum value for this parameter is 4 KB plus the value of the database DB_BLOCK_SIZE initialization parameter multiplied by the value of the DB_MULTIBLOCK_READ_COUNT

initialization parameter:

(DB_BLOCK_SIZE * DB_MULTIBLOCK_READ_COUNT) + 4 KB

上述网络参数调整后，需要重启主机，使其生效。

3、oracle Shell Limits

=========================================================================

vi /etc/security/limits

修改的内容为：

fsize = -1

cpu = -1

data = -1

stack = -1

core = 2097151

rss = -1

nofiles = -1

fsize_hard = -1

cpu_hard = -1

data_hard = -1

stack_hard = -1

rss_hard = -1

nofiles_hard = -1

安装产品检测

oracle cluster软件启动和关闭

启动：

以root用户，cd 到$CRS_HOME/bin/crsctl start crs

关闭：

以root用户，cd 到$CRS_HOME/bin/crsctl stop crs

oracle数据库启动和关闭

启动：

以Oracle用户执行

$CRS_HOME/bin/srvctl start database –d db_name

关闭

以Oracle用户执行

$CRS_HOME/bin/srvctl stop database –d db_name

数据库状态监控

以Oracle用户执行

$CRS_HOME/bin/crs_stat