安装Oracle 10.2.0.5 RAC for AIX6（一）

最新推荐文章于 2022-01-18 21:10:26 发布

ckawt40802

最新推荐文章于 2022-01-18 21:10:26 发布

阅读量104

点赞数

简单介绍在AIX6上安装10.2.0.5 RAC的过程。

这一篇描述环境准备工作。

首先检查两个节点的硬件情况：

# /usr/sbin/lsattr -E -l sys0 -a realmem
realmem 65011712 Amount of usable physical memory in Kbytes False
# /usr/sbin/lsps -a
Page Space      Physical Volume   Volume Group Size %Used Active Auto Type Chksum
hd6             hdisk0            rootvg       65536MB     1   yes   yes    lv     0
# df -k /tmp
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd3         20971520 20925388    1%      119     1% /tmp
# df -k
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4         20971520 20687728    2%    11471     1% /
/dev/hd2         10485760   6753980   36%    53586     4% /usr
/dev/hd9var      52428800 52087248    1%     8409     1% /var
/dev/hd3         20971520 20925388    1%      119     1% /tmp
/dev/hd1         52428800 52420452    1%        5     1% /home
/dev/hd11admin      524288    523848    1%        5     1% /admin
/proc                   -         -    -         -     - /proc
/dev/hd10opt     20971520 19815436    6%    17796     1% /opt
/dev/livedump      524288    523880    1%        4     1% /var/adm/ras/livedump
/dev/odm                0         0   -1%        6   100% /dev/odm
/dev/vx/dsk/ywdbdg/ywdbdg_vol_01   523239424 518611224    1%        5     1% /ywdb01
/dev/vx/dsk/ywdbdg/ywdbdg_vol_02   523239424 518611224    1%        4     1% /ywdb02
/dev/vx/dsk/ywdbdg/ywdbdg_vol_03   523239424 518611224    1%        4     1% /ywdb03
/dev/vx/dsk/ywdbdg/ywdbdg_vol_04   523239424 518611224    1%        4     1% /ywdb04
/dev/vx/dsk/ywdbdg/ywdbdg_vol_05   629145600 623686784    1%        4     1% /ywdb05
# /usr/bin/getconf HARDWARE_BITMODE
64

然后检查两个节点上系统软件版本和包的安装情况：

# oslevel -r
6100-06
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools rsct.basic.rte
Fileset                      Level State      Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
bos.adt.base               6.1.6.0 COMMITTED Base Application Development
                                                 Toolkit
bos.adt.lib                6.1.2.0 COMMITTED Base Application Development
                                                 Libraries
bos.adt.libm               6.1.6.0 COMMITTED Base Application Development
                                                 Math Library
bos.perf.libperfstat       6.1.6.0 COMMITTED Performance Statistics Library
                                                 Interface
bos.perf.perfstat          6.1.6.0 COMMITTED Performance Statistics
                                                 Interface
bos.perf.proctools         6.1.6.0 COMMITTED Proc Filesystem Tools
rsct.basic.rte             3.1.0.0 COMMITTED RSCT Basic Function

Path: /etc/objrepos
bos.adt.base               6.1.6.0 COMMITTED Base Application Development
                                                 Toolkit
bos.perf.libperfstat       6.1.6.0 COMMITTED Performance Statistics Library
                                                 Interface
bos.perf.perfstat          6.1.6.0 COMMITTED Performance Statistics
                                                 Interface
rsct.basic.rte             3.1.0.0 COMMITTED RSCT Basic Function

下面在节点1上创建oinstall和dba组，然后利用smit security建立oracle用户：

# /bin/mkgroup oinstall
# /bin/mkgroup dba
# smit security

在建立oracle用户时指定oinstall和dba组选项。在Primary GROUP处输入oinstall，在Group SET处输入dba。

# id oracle
uid=203(oracle) gid=202(oinstall) groups=203(dba)
# passwd oracle
Changing password for "oracle"
oracle's New password:
Enter the new password again:
# id nobody
uid=4294967294(nobody) gid=4294967294(nobody)

确认oracle用户组选项正确，修改oracle密码，并确认nobody用户存在。

修改oracle用户的.profile文件，添加下面的内容：

ORACLE_SID=ywdb1
export ORACLE_SID
ORACLE_BASE=/opt/oracle
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2/database
export ORACLE_HOME
ORA_CRS_HOME=$ORACLE_BASE/product/10.2/crs
export ORA_CRS_HOME
PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH
export PATH
DISPLAY=10.142.195.119:0.0
export DISPLAY

设置oracle用户和root用户的属性：

# smit chuser

将Soft FILE size、Soft CPU time、Soft DATA segment和Soft STACK size都设置为没有限制，也就是-1。

# smit chgsys

设置系统参数，将Maximum number of PROCESSES allowed per user参数的值设置超过2048。

# /usr/sbin/no -a | more

# /usr/sbin/lsattr -E -l sys0 -a pre520tune
pre520tune disable Pre-520 tuning compatibility mode True
# /usr/sbin/no -o udp_sendspace=65536
Setting udp_sendspace to 65536
Change to tunable udp_sendspace, will only be effective for future connections
# /usr/sbin/no -o udp_recvspace=655360
Setting udp_recvspace to 655360
Change to tunable udp_recvspace, will only be effective for future connections
# /usr/sbin/no -o tcp_sendspace=65536
Setting tcp_sendspace to 65536
Change to tunable tcp_sendspace, will only be effective for future connections
# /usr/sbin/no -o tcp_recvspace=65536
Setting tcp_recvspace to 65536
Change to tunable tcp_recvspace, will only be effective for future connections
# /usr/sbin/no -o rfc1323=1
Setting rfc1323 to 1
Change to tunable rfc1323, will only be effective for future connections
# /usr/sbin/no -o sb_max=1310720
Setting sb_max to 1310720
# /usr/sbin/no -r -o ipqmaxlen=512
Setting ipqmaxlen to 512 in nextboot file
Warning: changes will take effect only at next reboot

通过no –a，检查系统网络参数配置，其中udp和tcp参数设置应和上面修改的配置保持一致，rfc1323、sb_max以及ipqmaxlen也同样仿照上面的例子进行设置。

在/etc/rc.net中添加下面的内容：

if [ -f /usr/sbin/no ] ; then
/usr/sbin/no -o udp_sendspace=65536
/usr/sbin/no -o udp_recvspace=655360
/usr/sbin/no -o tcp_sendspace=65536
/usr/sbin/no -o tcp_recvspace=65536
/usr/sbin/no -o rfc1323=1
/usr/sbin/no -o sb_max=1310720
/usr/sbin/no -r -o ipqmaxlen=512
fi

检查主机名称、IP地址信息：

# hostname
ywdb1
# ifconfig -a
en0: flags=5e080863,c0
inet 10.142.195.5 netmask 0xffffff00 broadcast 10.142.195.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en12: flags=5e080863,c0
inet 192.168.195.1 netmask 0xffffff00 broadcast 192.168.195.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1

下面设置两个节点的/etc/hosts文件：

10.142.195.5 ywdb1

10.142.195.6 ywdb2

10.142.195.1 ywdb1-vip

10.142.195.2 ywdb2-vip

192.168.195.1 ywdb1-priv

192.168.195.2 ywdb2-priv

在两个节点的oracle目录下，建立.rhosts文件，添加下列内容：

ywdb1
ywdb2
ywdb1-vip
ywdb2-vip
ywdb1-priv
ywdb2-priv

最后创建cluster和db安装对应的目录，安装准备工作完成。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-702137/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-702137/