安裝Oracle 10.2.0.5 RAC for AIX6(一)

yangtingkun發表於2011-07-13

簡單介紹在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上建立oinstalldba組,然後利用smit security建立oracle使用者:

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

在建立oracle使用者時指定oinstalldba組選項。在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 sizeSoft CPU timeSoft DATA segmentSoft 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,檢查系統網路引數配置,其中udptcp引數設定應和上面修改的配置保持一致,rfc1323sb_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

最後建立clusterdb安裝對應的目錄,安裝準備工作完成。

 

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/4227/viewspace-702137/,如需轉載,請註明出處,否則將追究法律責任。

相關文章