13518219792
Oracle Study 之--AIX5.3安装Oracle 11gR2
成都创新互联公司是一家以重庆网站建设公司、网页设计、品牌设计、软件运维、营销推广、小程序App开发等移动开发为一体互联网公司。已累计为户外休闲椅等众行业中小客户提供优质的互联网建站和软件开发服务。
系统环境：
操作系统： AIX5300-09
Oracle： Oracle 10gR2（64）
对于AIX5.3的版本，如果安装Oracle 11g需要将系统升级到AIX 5300-09的版本，具体升级方法见我的另一博文：
http://tiany.blog.51cto.com/513694/1368026
一、安装前准备
1、查看操作系统的版本
[root@aix211 /]#oslevel -r
5300-09
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 /]#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（最少在7G以上的空间）
[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
-----注意：
1、 /tmp 必须保证最少需要400M空间
2、如果/u01 放在 ‘ / ’下，最少需要7g以上空间
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%
注：
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 /]#lslpp -l |grep -i xlc.rte
xlC.rte 9.0.0.1 COMMITTED XL C/C++ Runtime
[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 /]#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 /]#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/11.2.0/db_1 ORACLE_SID=prod PATH=$PATH:$ORACLE_HOME/bin export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH [oracle@aix211 ~]$
二、安装Oracle 软件
-----安装oracle 11g软件
安装完成：
