Shulou(Shulou.com)06/01 Report--

Oracle Study-AIX6.1 to build Oracle 10gR2 RAC (1)

Environment:

Operating system: AIX 6100-09 (SP3)

Cluster software: CRS 10.2.0.1

Database: Oracle 10.2.0.1

There are two ways to build RAC under AIX platform according to the use of shared storage:

1. Establish shared storage based on concurrent volume group (VG concurrent).

2. Establish shared storage based on RAW under ASM.

System architecture:

This case is for VG Concurrent-based shared storage:

First, view the system environment information

[root@aix203 /] # prtconf | more

System Model: IBM,7028-6C4Machine Serial Number: 10681AAProcessor Type: PowerPC_POWER4Processor Implementation Mode: POWER4Processor Version: PV_4Number Of Processors: 2Processor Clock Speed: 1002 MHzCPU Type: 64-bitKernel Type: 64-bitLPAR Info: 1 NULLMemory Size: 2048 MBGood Memory Size: 2048 MBPlatform Firmware level: 3R080425Firmware Version: IBM,RG080425_d79e22_rConsole Login: enableAuto Restart: trueFull Core: falseNX Crypto Acceleration: Not Capable Network Information Host Name: aix203 IP Address: 192.168.203 Sub Netmask: 255.255.255.0

II. Operating system version

[root@aix203 /] # oslevel-r

6100-09

III. File system

[oracle@aix203] $df-g

Filesystem GB blocks Free% Used Iused% Iused Mounted on/dev/hd4 6.00 5.82% 10247 1% / / dev/hd2 2.38 0.20% 92% 45258 47% / usr/dev/hd9var 1.00 0.69 32% 8778 6% / var/dev/hd3 2.00 1.99 1 % 57 1% / tmp/dev/hd1 1.00 1% 22 1% / home/dev/hd11admin 1.00 1.00 1% 51% / admin/proc-/ proc/dev/hd10opt 1.00 0.79 21% 8881 / opt/dev/livedump 0.25% 41% / var/adm/ras/livedump/dev/fslv00 10.00 7.40 26% 3460 1% / u01/aha-16.1% / aha

-Oracle and CRS software are installed under / U01 file system. For Oracle 10g installation, / tmp file system cannot be less than 400m.

Fourth, page exchange space

[oracle@aix203] $lsps-a

Page Space Physical Volume Volume Group Size Used Active Auto Type Chksum

Paging00 hdisk0 rootvg 2048MB 0 yes yes lv 0

Hd6 hdisk0 rootvg 2048MB 0 yes yes lv 0

Software packages and patches required by the system

[root@aix203 /] # lslpp-l | grep bos.adt bos.adt.base 6.1.9.0 COMMITTED Base Application Development bos.adt.debug 6.1.9.0 COMMITTED Base Application Development bos.adt.include 6.1.9.0 COMMITTED Base Application Development bos.adt.lib 6.1.8.0 COMMITTED Base Application Development bos.adt.libm 6.1.9 .0 COMMITTED Base Application Development bos.adt.base 6.1.9.0 COMMITTED Base Application Development [root@aix203 /] # lslpp-l | grep bos.perf bos.perf.diag_tool 6.1.8.15 COMMITTED Performance Diagnostic Tool bos.perf.fdpr 6.1.8.15 COMMITTED Feedback Directed Program bos.perf.libperfstat 6.1.9.0 COMMITTED Performance Statistics Library bos.perf.perfstat 6.1.9 . 0 COMMITTED Performance Statistics bos.perf.pmaix 6.1.9.0 COMMITTED Performance Management bos.perf.proctools 6.1.9.0 COMMITTED Proc Filesystem Tools bos.perf.tools 6.1.9.0 COMMITTED Base Performance Tools bos.perf.tune 6.1.9.0 COMMITTED Performance Tuning Support bos.perf.diag_tool 6.1.8.15 COMMITTED Performance Diagnostic Tool bos.perf. Libperfstat 6.1.9.0 COMMITTED Performance Statistics Library bos.perf.perfstat 6.1.9.0 COMMITTED Performance Statistics bos.perf.pmaix 6.1.9.0 COMMITTED Performance Management bos.perf.tools 6.1.9.0 COMMITTED Base Performance Tools bos.perf.tune 6.1.9.0 COMMITTED Performance Tuning Support

Patch:

[root@aix204 /] # instfix-I | grep 10223

All filesets for IZ10223 were found.

VI. Network environment

Network configuration:

[root@aix203 /] # ifconfig-a

En0: flags=5e084863,c0 inet 192.168.8.203 netmask 0xffffff00 broadcast 192.168.8.255en2: flags=5e084863,c0 inet 10.10.10.203 netmask 0xffffff00 broadcast 10.10.10.255

[root@aix203 /] # cat / etc/hosts

# Internet Address Hostname # Comments# 192.9.200.1 net0sample # ethernet name/address# 128.100.0.1 token0sample # token ring name/address# 10.2.0.2 x25sample # x.25 name/address# 2000:1:1:1:209:6bff:feee:2b7f ipv6sample # ipv6 name/address127.0.0.1 Loopback localhost # loopback (lo0) name/address192.168.8.203 aix203192.168.8.204 aix204192.168.8.251 aix203-vip192.168.8.252 aix204-vip10.10.10.203 aix203-priv10.10.10.204 aix204-priv

-not finished, to be continued!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.