Oracle Study之--AIX 6.1安装Oracle 11gR2
创新互联是一家专注于网站制作、成都网站设计与策划设计,广陵网站建设哪家好?创新互联做网站,专注于网站建设10多年,网设计领域的专业建站公司;建站业务涵盖:广陵等地区。广陵做网站价格咨询:13518219792
系统环境：AIX6100-09 （补丁：sp3）
Oracle： Oracle 11gR2
1、查看系统硬件信息
$ prtconf |more
System Model: IBM,7028-6C4 Machine Serial Number: 1096B0D 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: 3R041029 Firmware Version: IBM,RG041029_d79e00_r Console Login: enable Auto Restart: true Full Core: false
2、安装Oracle 11gR2需要page space不小于4g：
[root@aix203 database]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 1 yes yes lv 0 [root@aix203 database]lsps -s Total Paging Space Percent Used 2560MB 0% [root@aix203 database]swap Usage: swap -l swap -s swap -d device swap -a device [root@aix203 database]swap -a /dev/hd6 swapon: Paging device /dev/hd6 is already active. [root@aix203 database]swap -d /dev/hd6 [root@aix203 database]swap -a /dev/hd6 [root@aix203 database]lsps -s Total Paging Space Percent Used 4096MB 0%
3、查看系统所必须安装的数据包
[root@aix203 /]lslpp -l |grep -i xlc xlC.aix61.rte 12.1.0.1 COMMITTED IBM XL C++ Runtime for AIX 6.1 xlC.cpp 9.0.0.0 COMMITTED C for AIX Preprocessor xlC.rte 12.1.0.1 COMMITTED IBM XL C++ Runtime for AIX xlC.sup.aix50.rte 9.0.0.1 COMMITTED XL C/C++ Runtime for AIX 5.2 [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
4、查看文件系统空间信息
# df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 10240.00 4992.90 52% 13238 2% / /dev/hd2 2048.00 492.00 76% 31524 22% /usr /dev/hd9var 2048.00 2033.39 1% 479 1% /var /dev/hd3 2048.00 1797.96 13% 466 1% /tmp /dev/hd1 2048.00 2047.29 1% 12 1% /home /dev/hd11admin 2048.00 2047.35 1% 5 1% /admin /proc - - - - - /proc /dev/hd10opt 2048.00 1934.11 6% 1923 1% /opt /dev/fslv00 10240.00 10238.09 1% 7 1% /u01 aix219:/ware 15360.00 3711.85 76% 14106 2% /soft1 /dev/lv00 128.00 123.94 4% 18 1% /var/adm/csd
5、调整用户启用最大进程数
6、root用户做安装前的环境检测
# ./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_16-03-02.15:44:46
Saving the original files in /etc/ora_save_16-03-02.15:44:46....
Copying new kernel extension to /etc....
Loading the kernel extension from /etc
Oracle Kernel Extension Loader for AIX
Copyright (c) 1998,1999 Oracle Corporation
Successfully loaded /etc/pw-syscall.64bit_kernel with kmid: 0x20883000
Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x20883000
The kernel extension was successfuly loaded.
Configuring Asynchronous I/O....
Asynchronous I/O is not installed on this system.
You will need to install it, and either configure it yourself using
'smit aio' or rerun the Oracle root installation procedure.
Configuring POSIX Asynchronous I/O....
Posix Asynchronous I/O is not installed on this system.
You will need to install it, and either configure it yourself using
'smit aio' or rerun the Oracle root installation procedure.
Checking if group services should be configured....
Nothing to configure.
---- 检测提示“异步I/O"没有被启用，经查询，在AIX 6.1下会当有I/O请求时，自动启用异步I/O 。
查看系统I/O情况：
# ioo -a |grep aio
aio_active = 0 ；aio未启动
aio_maxreqs = 65536
aio_maxservers = 40
aio_minservers = 10
aio_server_inactivity = 300
posix_aio_active = 0 ；aio未启动
posix_aio_maxreqs = 65536
posix_aio_maxservers = 30
posix_aio_minservers = 3
posix_aio_server_inactivity = 300
7、安装系统sp3补丁
8、创建Oracle用户
创建Oracle用户和组（install、dba）
# id oracle
uid=300(oracle) gid=300(oinstall) groups=301(dba)
# chown -R oracle:dba /u01
# su - oracle
$ mkdir -p /u01/app/oracle
----并修改Oracle用户对资源访问的限制 ！
[oracle@aix209 ~]$cat .profile
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
9、安装Oracle 11g软件
查询补丁，系统缺少这三个补丁：
[root@aix209 database]instfix -i |grep 41885
[root@aix209 database]instfix -i |grep 51456
[root@aix209 database]instfix -i |grep 52319
（忽略后，继续安装，安装成功！）
10、建立数据库
----- 建库成功，至此Oracle 11gR2安装完成，所缺的补丁可以从IBM官方网站下载 ！
