Install ORACLE10g On AIX5L 5.2(转自LU)
Install ORACLE10g On IBM AIX5L 5.2
作者：workaholic
1、环境说明:
1.1硬件环境：
System Model: IBM,7028-6C4
Machine Serial Number: ******
Processor Type: PowerPC_POWER4
Number Of Processors: 2
Processor Clock Speed: 1200 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 1 NULL
Memory Size: 4096 MB
Good Memory Size: 4096 MB
Firmware Version: IBM,RG040322_d75e03_s
Console Login: enable
Auto Restart: true
Full Core: false
Network Information
Host Name: ***
IP Address: ****
Sub Netmask: ****
Gateway: ****
Name Server:
Domain Name:
1.2 操作系统：
[hostname]/#oslevel -r
5200-04
1.3 硬件架构
[hostname]/#bootinfo -y
64
1.4 系统Kernel
[hostname]/#bootinfo -K
64
2、ORACLE10g的安装前的准备:
2.1 必备工具
在本地计算机需要有Extra！X or Xmanager and SecureCRT工具等
获取方式：可以通过google搜索下载安装
2.2 以root用户登录
1、Log in to the system as root
2.3必需的硬件环境
为了确认系统满足安装条件，通过以下方式进行确认：
检查内存：
[hostname]/#lsattr -El mem0
goodsize 4096 Amount of usable physical memory in Mbytes False
size 4096 Total amount of physical memory in Mbytes False
查看Paging Space大小
＃ lsps –a
如果Paging Space大小不符合要求，可以通过smitty chps 直接扩大or smitty mkps创建另一个Paging Space
[hostname]/#lsps -a
Page Space Physical Volume Volume Group Size %Used Active Auto Type
hd6 hdisk0 rootvg 4096MB 1 yes yes lv
查看/tmp文件系统可用空间是否大于400MB
＃ df –k
如果/tmp文件系统空间不符合要求，可以删除无用文件或者通过smitty chjfs命令扩大该文件系统,这里我扩/tmp至 1GB
[hostname]/#df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 65536 49840 24% 1810 6% / /dev/hd2 2031616 106544 95% 32074 7% /usr /dev/hd9var 262144 189592 28% 342 1% /var /dev/hd3 1048576 1014536 4% 79 1% /tmp /dev/hd1 65536 63404 4% 18 1% /home /proc - - - - - /proc /dev/hd10opt 65536 38856 41% 558 4% /opt /dev/lv00 3080192 1955624 37% 19 1% /ora_data 决定系统体系架构： ＃ getconf HARDWARE_BITMODE
64
如果没有64显示，将不能够安装ORACLE10g在该机器上
2.4 必需的系统软件环境
AIX的版本必须是 AIX5L 5.2 ML01 OR 更高
确认方式：
＃ oslevel –r
如果返回的结果显示ML低于AIX 5.2 ML01 ,就需要升级ML
下载URL 如下所示:https://techsupport.services.ibm.com/server/aix.fdc?toggle=DNLDML
安装过程略
下面的文件集是必须的
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
确认方式：
＃ lslpp –l fileset_name
下面的 Authorized Problem Analysis Reports (APARs)必须被安装：
– IY43980: libperfstat.h not ANSI-compliant
– IY44810: DSI IN BMRECYCLE
– IY45462: Definition of isnan() in math.h incorrect
– IY45707: J2 READAAHEAD/CIO INTERACTION
– IY46214: dropping partial connections leaves them on so_q0
– IY46605: exec of 32 bit application can fail on 64 bit kernel
– IY48525: SDK 1.4.1 32-BIT SR1: CA141-20030930
– IY51801: race condition in aio_nwait_timeout
确认方式：
＃ instfix –ik “IY**** IY&&&& IY IY### ”
2.5 打开系统AIO
Smitty chaio 这里设置之后需要重新启动系统生效
2.6创建ORACLE10g用户和组
组名：
dba
用户名：
oracle
创建组的具体命令：
smitty mkgourp
创建用户的具体命令：
smitty mkuser
In the Primary GROUP field, specify dba
In the Group SET field, specify dba.
创建用户后，给oracle用户设置口令
＃ passwd oracle
2.7 创建ORACLE文件系统
/oracle
/oracle是该文件系统的mount point , 文件系统大小要求：5GB
命令：
# smitty crjfs
改变属主
# chown -R oracle:dba /oracle
改变目录权限：
# chmod -R 775 /oracle
2.8 配置Shell Limits 以及系统配置参数
在AIX系统，我们不需要配置内核参数，然而ORACLE推荐按照如下设置shell limits 和系统配置参数：
配置Shell Limits
按照下面的表格中列示的参数值对Shell Limits进行确认与配置
Shell Limit (As Shown in smit) Recommended Value
Soft FILE size -1 (Unlimited)
Soft CPU time -1 (Unlimited)
Note: This is the default value.
Soft DATA segment -1 (Unlimited)
Soft STACK size -1 (Unlimited)
使用以下命令对oracle用户的shell limits进行修改：
＃ smitty chuser
配置系统配置参数
Verify that the maximum number of processes allowed per user is set
to 2048 or greater
命令：
# smitty chgsys
确认Maximum number of PROCESSES allowed per user>=2048
2.9 设置oracle用户的环境变量
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:
/usr/ccs/bin:$PATH:$ORACLE_HOME/bin if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # periodically. ORACLE_SID=ora10g ORACLE_BASE=/oracle ORACLE_HOME=$ORACLE_BASE/product/10.1.0 ORACLE_TERM=vt100 ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ORACLE_PATH=$ORACLE_HOME/dbs ORA_DB=$ORACLE_HOME/dbs LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/network/lib:$ORACLE_HOME/lib32 #LINK_CNTRL=L_PTHREADS_D7 NLS_LANG=American_america.zhs16gbk CLASSPATH=$ORACLE_HOME/product/jlib:$ORACLE_HOME/jlib LIBPATH=$ORACLE_HOME/lib32 DISPLAY=10.72.129.172:0.0 umask 022 export ORACLE_SID ORACLE_BASE ORACLE_HOME ORACLE_TERM ORA_NLS33 export LD_LIBRARY_PATH LINK_CNTRL NLS_LANG PATH CLASSPATH LIBPATH DISPLAY
2.10 编辑 .dtprofile
[oracle@hostname]/home/oracle$vi .dtprofile
将最后一行的注释去掉
DTSOURCEPROFILE=true
2.11 FTP安装文件到系统内置硬盘
建立文件系统/ora_data放置oracle10g的安装文件
ship.db.aix.disk1.cpio.gz
ship.db.aix.disk2.cpio.gz
解压缩
[hostname]/ora_data#gzip -d ship.db.aix.disk1.cpio.gz
[hostname]/ora_data#gzip -d ship.db.aix.disk2.cpio.gz
[hostname]/ora_data#cpio -idcmv ……
[hostname]/ora_data#cpio -idcmv ……
2.12 通过光盘方式进行安装
放入光盘
＃ mkdir /cdrom
加载光驱
# mount –rv cdrfs /devv/cd0 /cdrom
3、ORACLE10g的安装
1、Login as oracle user
3、Run the runInstaller as oracle
4、run the rootpre.sh as root
5、ORACLE Universal Installer 启动
6、点击Next
7、按照系统提示执行/oracle/oraInventory/orainstallRoot.sh
[hostname]/oracle/oraInventory#./orainstRoot.sh
Creating the Oracle inventory pointer file (/etc/oraInst.loc)
Changing groupname of /oracle/oraInventory to dba.
按Continue继续安装
8、点击Next
9、选择Custom对数据库的安装进行定制
10、点击Next
11、选择需要安装的产品，不想要的统统干掉
12、点击Next
13、点击Next
15、点击 Install开始进行安装
16、这里提示我们要运行 /oracle/product/10.1.0/root.sh as root user
[hostname]/oracle/product/10.1.0#./root.sh Running Oracle10 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/10.1.0 Enter the full pathname of the local bin directory: [/usr/local/bin]: Creating /usr/local/bin directory... Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Creating /etc/oratab file... Adding entry to /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. /etc/oracle does not exist. Creating it now. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. Oracle Cluster Registry for cluster has been initialized Adding to inittab Checking the status of Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. hostname CSS is active on all nodes. Oracle CSS service is installed and running under init(1M)
点击OK 继续安装
17、进行oracle net配置
18、点击Next
19、点击Next
20、点击Next
21、Next
22、Next
23、I don’t want to configure additional naming methods
24、Finish
至此，Oracle10g的安装全部结束，可以通过dbca进行数据库的创建……
