aix上使用裸设备安装oracle10g数据库

一、检查系统信息

[root@aix222 /]# oslevel -r

5300-08

[root@aix222 /]# prtconf | grep -i mem

Memory Size: 1904 MB

Good Memory Size: 1904 MB

…

 

[root@aix222 /]# lsattr -El mem0

goodsize 1904 Amount of usable physicalmemory in Mbytes False

size    1904 Total amount of physical memory in Mbytes  False

[root@aix222 /]# prtconf | more

…

Processor Implementation Mode: POWER 5

Processor Version: PV_5_2

Number Of Processors: 2

Processor Clock Speed: 1898 MHz

CPU Type: 64-bit

Kernel Type: 64-bit

LPAR Info: 1 10-0884G

Memory Size: 1904 MB

Good Memory Size: 1904 MB

Platform Firmware level: SF240_382

Firmware Version: IBM,SF240_382

…

[root@aix222 /]# bootinfo -K

64

[root@aix222 /]# lsps –a

…

[root@aix222 /]# lsps –s

…

二、查看软件包和安装补丁

[root@aix222 /]# lslpp -l |grep bos.adt

[root@aix222 /]# lslpp -l |grep -i xlc.rte

[root@aix222 /]# lslpp -l |grep -i xlc

[root@aix222 /]# lslpp -l |grep -i bos.perf

Aix上的oracle10g需要下面的软件包

Bos.adt.base

Bos.adt.lib

Bos.adt.libm

Bos.pref.libperfstat

Bos.perf.perfstat

Bos.perf.proctools

Xlc.aix50.rte

xlC.rte

下面查看补丁

[root@aix222 /]# instfix -ik IY58143

[root@aix222 /]# instfix -ik IY59386

[root@aix222 /]# instfix -ik IY60930

[root@aix222 /]# instfix -ik IY66513

[root@aix222 /]# instfix -ik IY70159

[root@aix222 /]# instfix -ik IY68989

三、配置系统参数

[root@aix222 /]# smit system

Change / Show Characteristics of OperatingSystem

 =>Maximum number of PROCESSES allowed peruser       [2048]

[root@aix222 /]# 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 systemrestart            available

State of fast path                                  enable

四、建立用户组和用户

Groups:oinstall、dba

Users:oracle

使用smit来添加

五、配置oracle用户的.profile

[oracle@aix222 ~]$ vi .profile

…

ORACLE_BASE=/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

ORACLE_SID=siqian

PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

export EDITOR=vi

export DBCA_CONFIG=/home/oracle/raw_mp.txt

六、使用现有的vg创建lv

[root@aix222 /]# mklv -y 'system' -t 'raw' datavg3 32

这里的lp大小为32mb，也就是说system这个lv大小为1gb。

[root@aix222 /]# mklv -y 'sysaux' -t 'raw' datavg3 32

[root@aix222 /]# mklv -y 'users' -t 'raw' datavg3 16

[root@aix222 /]# mklv -y 'example' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'undotbs' -t 'raw' datavg3 16

[root@aix222 /]# mklv -y 'temp' -t 'raw' datavg3 10

[root@aix222 /]# mklv -y 'control01' -t 'raw' datavg3 2

[root@aix222 /]# mklv -y 'control02' -t 'raw' datavg3 2

[root@aix222 /]# mklv -y 'control03' -t 'raw' datavg3 2

[root@aix222 /]# mklv -y 'spfile' -t 'raw' datavg3 1

[root@aix222 /]# mklv -y 'redo01a' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'redo01b' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'redo02a' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'redo02b' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'redo03a' -t 'raw' datavg3 5

[root@aix222 /]# mklv -y 'redo03b' -t 'raw' datavg3 5

七、配置映射文件

[oracle@aix222 ~]$ vi raw_mp.txt

system=/u01/app/oracle/oradata/siqian/system01.dbf

sysaux=/u01/app/oracle/oradata/siqian/sysaux01.dbf

users=/u01/app/oracle/oradata/siqian/users01.dbf

example=/u01/app/oracle/oradata/siqian/example01.dbf

undotbs1=/u01/app/oracle/oradata/siqian/undotbs01.dbf

temp=/u01/app/oracle/oradata/siqian/temp01.dbf

control1=/u01/app/oracle/oradata/siqian/control01.ctl

control2=/u01/app/oracle/oradata/siqian/control02.ctl

control3=/u01/app/oracle/oradata/siqian/control03.ctl

redo1_1=/u01/app/oracle/oradata/siqian/redo01a.log

redo1_2=/u01/app/oracle/oradata/siqian/redo01b.log

redo2_1=/u01/app/oracle/oradata/siqian/redo02a.log

redo2_2=/u01/app/oracle/oradata/siqian/redo02b.log

redo3_1=/u01/app/oracle/oradata/siqian/redo03a.log

redo3_2=/u01/app/oracle/oradata/siqian/redo03b.log

spfile=/u01/app/oracle/oradata/siqian/spfilesiqian.ora

八、配置裸设置权限

在root下执行：

chown oracle:oinstall /dev/rsystem

chown oracle:oinstall /dev/rsysaux

chown oracle:oinstall /dev/rusers

chown oracle:oinstall /dev/rexample

chown oracle:oinstall /dev/rundotbs

chown oracle:oinstall /dev/rtemp

chown oracle:oinstall /dev/rcontrol01

chown oracle:oinstall /dev/rcontrol02

chown oracle:oinstall /dev/rcontrol03

chown oracle:oinstall /dev/rspfile

chown oracle:oinstall /dev/rredo01a

chown oracle:oinstall /dev/rredo01b

chown oracle:oinstall /dev/rredo02a

chown oracle:oinstall /dev/rredo02b

chown oracle:oinstall /dev/rredo03a

chown oracle:oinstall /dev/rredo03b

九、给裸设置创建链接（用r开头的设备）

ln -s /dev/rsystem /u01/app/oracle/oradata/siqian/system01.dbf

ln -s /dev/rsysaux/u01/app/oracle/oradata/siqian/sysaux01.dbf

ln -s /dev/rusers/u01/app/oracle/oradata/siqian/users01.dbf

ln -s /dev/rexample/u01/app/oracle/oradata/siqian/example01.dbf

ln -s /dev/rundotbs /u01/app/oracle/oradata/siqian/undotbs01.dbf

ln -s /dev/rtemp/u01/app/oracle/oradata/siqian/temp01.dbf

ln -s /dev/rcontrol01/u01/app/oracle/oradata/siqian/control01.ctl

ln -s /dev/rcontrol02/u01/app/oracle/oradata/siqian/control02.ctl

ln -s /dev/rcontrol03/u01/app/oracle/oradata/siqian/control03.ctl

ln -s /dev/rspfile/u01/app/oracle/oradata/siqian/spfilesiqian.ora

ln -s /dev/rredo01a/u01/app/oracle/oradata/siqian/redo01a.log

ln -s /dev/rredo01b/u01/app/oracle/oradata/siqian/redo01b.log

ln -s /dev/rredo02a/u01/app/oracle/oradata/siqian/redo02a.log

ln -s /dev/rredo02b/u01/app/oracle/oradata/siqian/redo02b.log

ln -s /dev/rredo03a/u01/app/oracle/oradata/siqian/redo03a.log

ln -s /dev/rredo03b/u01/app/oracle/oradata/siqian/redo03b.log

十、DBCA建库

其中加入两个参数：CONTROL_FILES和SPFILE，填入对应的数值，然后导入raw_mp.txt，建库。