AIX 5.3 安装 Oracle 10g R2(64)

AIX 5.3 安装 Oracle 10g R2(64)


系统环境:

   操作系统: AIX5300-09

   Oracle:  Oracle 10gR2(64)


一、安装前准备


1、查看操作系统的版本


[root@aix211 /]#oslevel -r

5300-09

[root@aix211 /]#

注意:

对于安装Oracle 11g的用户,必须保证将AIX53升级到AIX5300-09的版本,对于AIX5300-08最高支持到Oracle 10gR2。


2、查看系统硬件信息

[root@aix211 /]#prtconf |grep -i mem

Memory Size: 4096 MB

Good Memory Size: 4096 MB

+ mem0                                                             Memory

[root@aix211 /]#lsattr -El mem0

goodsize 4096 Amount of usable physical memory in Mbytes False

size     4096 Total amount of physical memory in Mbytes  False

[root@aix211 /]#


[root@aix211 /]#prtconf |more

System Model: IBM,7028-6C4

Machine Serial Number: 1040F8A

Processor Type: PowerPC_POWER4

Processor Implementation Mode: POWER 4

Processor Version: PV_4_2

Number Of Processors: 2

Processor Clock Speed: 1453 MHz

CPU Type: 64-bit

Kernel Type: 64-bit

LPAR Info: 1 NULL

Memory Size: 4096 MB

Good Memory Size: 4096 MB

Platform Firmware level: 3R061030

Firmware Version: IBM,RG061030_d79e19_r

Console Login: enable

Auto Restart: true

Full Core: false


3、查看系统内核版本

[root@aix211 /]# bootinfo -K

64

如果内核版本非64位,可以将内核版本升级到64位

-----32位内核升级到64位

# ln -sf /usr/lib/boot/unix_64    /unix

# ln -sf /usr/lib/boot/unix_64     /usr/lib/boot/unix

# bosboot -ad /dev/ipldevice

# shutdown   -Fr

从64位降级到32位

# ln -sf /usr/lib/boot/unix_mp    /unix

# ln -sf /usr/lib/boot/unix_mp     /usr/lib/boot/unix

# bosboot -ad /dev/ipldevice

# shutdown   -Fr


4、查看文件系统空间

注:保证有足够的系统空间安装Oracle

[root@aix211 /]#df -m

Filesystem    MB blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4       11648.00   7924.90   32%     7005     1% /

/dev/hd2        2560.00    640.46   75%    45334     7% /usr

/dev/hd9var      640.00    269.07   58%     1198     1% /var

/dev/hd3        1152.00   1007.09   13%      179     1% /tmp

/dev/hd1         128.00    123.80    4%       85     1% /home

/proc                 -         -    -         -     -  /proc

/dev/hd10opt     384.00    107.30   73%     4829     5% /opt

/dev/lv00        128.00    123.94    4%       18     1% /var/adm/csd

/dev/u01       20480.00   8254.35   60%    42063     1% /u01

/dev/lv_data1   2048.00   1983.67    4%       17     1% /data1

/dev/fslv00     2112.00   2111.36    1%        4     1% /dsk1

192.168.8.212:/ware  20480.00   9504.80   54%     5824     1% /ware

[root@aix211 /]#


-----注意

1、 /tmp 必须保证最少需要400M空间

2、如果/u01 放在 ‘ / ’下,最少需要5g以上空间

3、其余/usr,/var 也要保证足够的空间


5、查看页面交换空间

[root@aix211 /]#lsps -a

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

paging01        hdisk2            oravg         1024MB     1   yes   yes    lv

lv_pg01         hdisk1            oravg         1024MB     1   yes   yes    lv

hd6             hdisk0            rootvg        2048MB     1   yes   yes    lv

[root@aix211 /]#lsps -s

Total Paging Space   Percent Used

     4096MB               1%

[root@aix211 /]#

注:

   Page space 可以设置为Physical Memory的2 倍或和内存大小一致


6、查看系统需要的软件和补丁

------查看软件包的安装和补丁


[root@aix211 /]#lslpp -l |grep bos.adt

 bos.adt.base               5.3.8.0  COMMITTED  Base Application Development

 bos.adt.debug              5.3.8.0  COMMITTED  Base Application Development

 bos.adt.graphics           5.3.7.0  COMMITTED  Base Application Development

 bos.adt.include            5.3.8.0  COMMITTED  Base Application Development

 bos.adt.insttools          5.3.8.0  COMMITTED  Tool to Create installp

 bos.adt.lib                5.3.8.0  COMMITTED  Base Application Development

 bos.adt.libm               5.3.8.0  COMMITTED  Base Application Development

 bos.adt.libmio             5.3.8.0  COMMITTED  Modular IO Library

 bos.adt.prof               5.3.8.1  COMMITTED  Base Profiling Support

 bos.adt.prt_tools          5.3.0.0  COMMITTED  Printer Support Development

 bos.adt.samples            5.3.7.0  COMMITTED  Base Operating System Samples

 bos.adt.sccs               5.3.8.0  COMMITTED  SCCS Application Development

 bos.adt.syscalls           5.3.7.0  COMMITTED  System Calls Application

 bos.adt.utils              5.3.8.0  COMMITTED  Base Application Development

 bos.adt.data               5.3.0.0  COMMITTED  Base Application Development

[root@aix211 /]#


[root@aix211 /]#lslpp -l |grep -i xlc.rte

 xlC.rte                    9.0.0.1  COMMITTED  XL C/C++ Runtime

[root@aix211 /]#


[root@aix211 /]#lslpp -l |grep -i xlc    

 xlC.aix50.rte              9.0.0.1  COMMITTED  XL C/C++ Runtime for AIX 5.2

 xlC.cpp                    9.0.0.0  COMMITTED  C for AIX Preprocessor

 xlC.rte                    9.0.0.1  COMMITTED  XL C/C++ Runtime

[root@aix211 /]#


[root@aix211 /]#lslpp -l |grep -i bos.perf

 bos.perf.diag_tool        5.3.0.50  COMMITTED  Performance Diagnostic Tool

 bos.perf.libperfstat       5.3.8.0  COMMITTED  Performance Statistics Library

 bos.perf.perfstat          5.3.8.1  COMMITTED  Performance Statistics

 bos.perf.proctools         5.3.8.0  COMMITTED  Proc Filesystem Tools

 bos.perf.tools             5.3.8.0  COMMITTED  Base Performance Tools

 bos.perf.tune              5.3.8.0  COMMITTED  Performance Tuning Support

 bos.perf.diag_tool        5.3.0.50  COMMITTED  Performance Diagnostic Tool

 bos.perf.libperfstat       5.3.8.0  COMMITTED  Performance Statistics Library

 bos.perf.perfstat          5.3.8.1  COMMITTED  Performance Statistics

 bos.perf.tools             5.3.8.0  COMMITTED  Base Performance Tools

 bos.perf.tune              5.3.8.0  COMMITTED  Performance Tuning Support

[root@aix211 /]#


[root@aix211 /]#instfix -ik IY58143

   All filesets for IY58143 were found.

[root@aix211 /]#instfix -ik IY59386

   All filesets for IY59386 were found.

[root@aix211 /]#instfix -ik IY60930

   All filesets for IY60930 were found.

[root@aix211 /]#instfix -ik IY66513

   All filesets for IY66513 were found.

[root@aix211 /]#instfix -ik IY70159

   All filesets for IY70159 were found.

[root@aix211 /]#instfix -ik IY68989

   All filesets for IY68989 were found.


7、修改系统内核参数和启动ASYNC I/O

-----修改系统内核参数


[root@aix211 /]# smit system


Change / Show Characteristics of Operating System


=>Maximum number of PROCESSES allowed per user       [2048]


----开启系统异步I/O


[root@aix211 /]#smit chaio


MINIMUM number of servers                          [1]                                                                  

 MAXIMUM number of servers per cpu                  [10]                                                                  

 maximum number of REQUESTS                         [4096]                                                                

 server PRIORITY                                    [39]                                                                  

 STATE to be configured at system restart            available                                                          

 State of fast path                                  enable    


8、建立Oracle用户和组及环境变量

------建立用户和组:


groups: oinstall 、dba

users: oracle

[root@aix211 /]#smit chuser (修改oracle 用户读取内存页面的限制)

Soft FILE size                                       [-1]                                        

 Soft CPU time                                      [-1]                                          

 Soft DATA segment                              [-1]                                        

 Soft STACK size                                   [-1]                                        

 Soft CORE file size                               [-1]  

 [root@aix211 database]#cat /etc/security/limits

 oracle:

       fsize = -1

       data = -1

       stack = -1

       core = -1


[oracle@aix211 ~]$cat .profile


PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.


export PATH


if [ -s "$MAIL" ]           # This is at Shell startup.  In normal

then echo "$MAILMSG"        # operation, the Shell checks

fi                          # periodically.


ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

ORACLE_SID=prod

PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

[oracle@aix211 ~]$


二、安装Oracle 软件

-----安装oracle 软件

AIX 5.3 安装 Oracle 10g R2(64)


本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1389527

AIX 5.3 安装 Oracle 10g R2(64),布布扣,bubuko.com

AIX 5.3 安装 Oracle 10g R2(64)

上一篇:sql server2008如何创建外键


下一篇:Gdb调试多进程程序