Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(1)

最新推荐文章于 2024-09-19 16:10:01 发布

客居天涯

最新推荐文章于 2024-09-19 16:10:01 发布

阅读量678

点赞数

分类专栏：数据库技术文章标签： oracle

本文链接：https://blog.csdn.net/lqx0405/article/details/50957284

版权

数据库技术专栏收录该内容

479 篇文章 3 订阅

订阅专栏

Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(1)

环境：

操作系统： AIX 6100-09（SP3)

集群软件： CRS 10.2.0.1

数据库： Oracle 10.2.0.1

构建AIX平台下RAC 依据共享存储的使用方式可以分两种：

1、建立基于并发卷组（VG concurrent）的共享存储

2、建立基于ASM下的RAW的共享存储

系统架构：

本案例是用于基于VG Concurrent 的共享存储：

一、查看系统环境信息

[root@aix203 /] #prtconf |more

System Model: IBM,7028-6C4
Machine Serial Number: 10681AA
Processor Type: PowerPC_POWER4
Processor Implementation Mode: POWER 4
Processor Version: PV_4
Number Of Processors: 2
Processor Clock Speed: 1002 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 1 NULL
Memory Size: 2048 MB
Good Memory Size: 2048 MB
Platform Firmware level: 3R080425
Firmware Version: IBM,RG080425_d79e22_r
Console Login: enable
Auto Restart: true
Full Core: false
NX Crypto Acceleration: Not Capable
 
Network Information
        Host Name: aix203
        IP Address: 192.168.8.203
        Sub Netmask: 255.255.255.0

二、操作系统版本
[root@aix203 /]#oslevel -r
6100-09
三、文件系统

[oracle@aix203 ~]$df -g

Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           6.00      5.82    4%    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.00    1%       22     1% /home
/dev/hd11admin      1.00      1.00    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt       1.00      0.79   21%     8881     5% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv00       10.00      7.40   26%     3460     1% /u01
/aha                  -         -    -        16     1% /aha

---- Oracle 和 CRS软件安装在/u01文件系统下，对于Oracle 10g安装，/tmp文件系统不能低于400M

四、页面交换空间

[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

五、系统所需要的软件包和补丁
[

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

补丁：
[root@aix204 /]#instfix -i |grep 10223
All filesets for IZ10223 were found.

六、网络环境
网络配置：
[root@aix203 /]#ifconfig -a

en0: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
        inet 192.168.8.203 netmask 0xffffff00 broadcast 192.168.8.255
en2: flags=5e084863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
        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/address
127.0.0.1               loopback localhost      # loopback (lo0) name/address
192.168.8.203   aix203
192.168.8.204   aix204

192.168.8.251  aix203-vip
192.168.8.252  aix204-vip

10.10.10.203   aix203-priv
10.10.10.204   aix204-priv

七、创建并配置Oracle用户（所有node）

[root@aix203 /]#id oracle
uid=300(oracle) gid=300(oinstall) groups=301(dba),302(hagsuser)

配置Oracle用户对系统资源的访问：

修改/etc/security/limits文件中default参数部分(需重启生效)

  default:
    fsize = -1  ##(Unlimited) 
    core = -1    ##(Unlimited) 
    cpu = -1    ##(Unlimited) 
    data = -1    ##(Unlimited) 
    rss = -1    ##(Unlimited) 
    stack = -1  ##(Unlimited) 
    nofiles = -1 ##(Unlimited)

[oracle@aix203 ~]$cat .profile

if [ -s "$MAIL" ]           # This is at Shell startup.  In normal
then echo "$MAILMSG"        # operation, the Shell checks
fi                          # periodically.
export ORACLE_SID=prod1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_CRS_HOME=/u01/crs_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_CRS_HOME/lib:$ORACLE_CRS_HOME/lib32
export PATH=$ORACLE_CRS_HOME/bin:$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/usr/es/sbin/cluster:/usr/es/sbin/cluster/sbin:/usr/es/sbin/cluster/utilities:/usr/es/sbin/cluster/diag:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
umask 022 
export EDITOR=vi

-------- 未完，待续！