Oracle10G R2(10.2.0.1)在AIX5.2.0.4(64bit)上的安裝
2024-08-29 13:36:58
供稿：網友
主機環境
# 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文件中居然沒寫什么也沒有安裝錯誤。
