AIX 5.3 安装 Oracle 10g R2(64)
系统环境:
操作系统: AIX5300-09
Oracle: Oracle 10gR2(64)
一、安装前准备
1、查看操作系统的版本
[root@aix211 /]#oslevel -r
5300-09
[root@aix211 /]#
注意:
对于安装Oracle 11g的用户,必须保证将AIX53升级到AIX5300-09的版本,对于AIX5300-08最高支持到Oracle 10gR2。
2、查看系统硬件信息
[root@aix211 /]#prtconf |grep -i mem
1
2
3
|
Memory Size:
4096
MB
Good Memory Size:
4096
MB
+ mem0 Memory
|
[root@aix211 /]#lsattr -El mem0
1
2
|
goodsize
4096
Amount of usable physical memory
in
Mbytes False
size
4096
Total amount of physical memory
in
Mbytes False
|
[root@aix211 /]#prtconf |more
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
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
1
2
3
4
5
6
7
8
9
10
11
12
|
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
[root@aix211 /]#df -m
1
2
3
4
5
6
7
8
9
10
11
12
13
|
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 放在 ‘ / ’下,最少需要5g以上空间
3、其余/usr,/var 也要保证足够的空间
5、查看页面交换空间
[root@aix211 /]#lsps -a
1
2
3
4
5
6
7
|
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
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
1
|
xlC.rte
9.0
.
0.1
COMMITTED XL C/C++ Runtime
|
[root@aix211 /]#lslpp -l |grep -i xlc
1
2
3
|
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
1
2
3
4
5
6
7
8
9
10
11
|
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
|
查看系统补丁:
1
2
3
4
5
6
7
8
9
10
11
12
|
[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
1
2
|
Change / Show Characteristics of Operating System
=>Maximum number of PROCESSES allowed per user [
2048
]
|
----开启系统异步I/O
1
2
3
4
5
6
7
|
[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用户和组及环境变量
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
------建立用户和组:
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/
10.2.
0
/db_1
ORACLE_SID=prod
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
|
二、安装Oracle 软件
-----安装oracle 软件