Oracle10G R2(10.2.0.1)在AIX5.2.0.4(64bit)上的安装

Oracle10G R2(10.2.0.1)在AIX5.2.0.4(64bit)上的安装

主机环境
# lsdev -Cc processor
proc0  Available 00-00 Processor
proc1  Available 00-01 Processor
proc2  Available 00-02 Processor
proc3  Available 00-03 Processor
proc4  Available 00-04 Processor
proc5  Available 00-05 Processor
proc6  Available 00-06 Processor
proc7  Available 00-07 Processor
proc8  Available 00-08 Processor
proc9  Available 00-09 Processor
proc10 Available 00-10 Processor
proc11 Available 00-11 Processor

# lsdev -Cc memory
L2cache0 Available  L2 Cache
mem0     Available  Memory
# lsattr -El mem0
goodsize 8192 Amount of usable physical memory in Mbytes False
size     8192 Total amount of physical memory in Mbytes  False
# lsattr -El L2cache0
size 16384 Size of L2 cache in Kbytes False
#

下载完毕3个文件，database，comp , cluster ，准备ftp上传到服务器上，提示超过file size limit，惨啊，穿了好久居然要出错，还要重传

# ulimit -a
time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000

#  ulimit -Ha
time(seconds)        unlimited
file(blocks)         2097151
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited

修改参数限制，file和stack需要在/etc/security/limits中修改了

# ulimit unlimited
# ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        32768
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
# ulimit -Ha
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited

这里有点不明白，为什么说soft limit不能超过hard limit的，为什么我一条命令就把两个的输出都变成unlimited了

# ulimit -s unlimited
# ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        unlimited
memory(kbytes)       32768
coredump(blocks)     2097151
nofiles(descriptors) 2000
# unlimit -d unlimited
ksh: unlimit:  not found.
# unlimit -d unlimited
ksh: unlimit:  not found.
# ulimit -d unlimited
# ulimit -m unlimited
# ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
memory(kbytes)       unlimited
coredump(blocks)     2097151
nofiles(descriptors) 2000

# gunzip 10gr2_aix5l64_database.cpio.gz
# cpio -idcmv <10gr2_aix5l64_database.cpio

扩大tmp和home的空间
lslpp -l 检查这些包安装了没有
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
xlC.aix50.rte:7.0.0.4 or later
xlC.rte:7.0.0.1 or later

下载aix5.2.0.4需要的补丁
All installations Authorized Problem Analysis Reports (APARs) for AIX 5L v5.2
ML 04:
■ IY63133: large percentage of CPU time spent in ldata_balance
routine
■ IY64978: deadlock with concurrent renaming and unlinking
under JFS
■ IY63366: dlsym returns null even for valid symbol in AIX520
ML-4
■ IY64691: chvg -b can cause corruption and crash
■ IY64737: AIO can hang in knotunlock
■ IY65001: mklvcopy on a striped lv is failing to update lvcb

这里描述了oracle10g和aix需要的一些软件的信息
<https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=282036.1>

建立oinstall dba 组，建立oracle用户，主组为oinstall,group set包含dba
smitty chuser 改变oracle用户的soft ulimit  data  stack file cpu 为-l
smitty chgsys改用户的最大进程数为2048

建立目录结构

# mkdir -p /home/oracle/product/10.2   
# chown -R oracle:oinstall /home/oracle/product/10.2
# chmod -R 755 /home/oracle/product/10.2

配置文件内容

umask 022
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_BASE=/home/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2; export ORACLE_HOME
AIXTHREAD_SCOPE=S; export AIXTHREAD_SCOPE
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.

将多个补丁放在一个目录中smitty  update_all安装，选择保存旧文件和不提交

$ ./runInstaller
**************************************************************************
******

Your platform requires the root user to perform certain pre-installation
OS preparation.  The root user should run the shell script 'rootpre.sh' be
fore
you proceed with Oracle installation.  rootpre.sh can be found at the top
level
of the CD or the stage area.

Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.

**************************************************************************
******

Has 'rootpre.sh' been run by root? [y/n] (n)

# ./rootpre.sh
./rootpre.sh output will be logged in /tmp/rootpre.out_05-11-30.10:25:15
Saving the original files in /etc/ora_save_05-11-30.10:25:15....
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: 0x75c3900
 Successfully configured /etc/pw-syscall.64bit_kernel with kmid: 0x75c3900
The kernel extension was successfuly loaded.

Configuring Asynchronous I/O....

Configuring POSIX Asynchronous I/O....

Checking if group services should be configured....
Nothing to configure.

然后剩下的都是图形界面的选择了，好像10gR2的安装比以前的9i等简单得多了，profile文件中居然没写什么也没有安装错误。