(1)根據安裝說明檢查Oracle10g所需的AIX包:
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
進行下面的查詢,查看作業系統中是否已近安裝了上述包:
(2)修改系統參數。啟動 smit,修改系統最大進程數參數,將參數改為 2048
資料庫的資料檔案(包括system,user,sysaux,redo,undo,spfile,temp資料表空間的資料檔案)需要存放在裸裝置上,下面使用dbca建立 資料庫所需要的步驟
1.給oracle的.profile檔案中配置一個,dbca在裸裝置上建立資料庫需要的一個參數配置
export DBCA_CONFIG=/home/oracle/raw_mp.txt
2.建立邏輯卷,但是不要使用格式化建立的邏輯卷
mklv -y 'system' -t 'raw' rootvg 10
mklv -y 'sysaux' -t 'raw' rootvg 5
mklv -y 'users' -t 'raw' rootvg 3
mklv -y 'undotbs' -t 'raw' rootvg 3
mklv -y 'temp' -t 'raw' rootvg 3
mklv -y 'control1' -t 'raw' rootvg 3
mklv -y 'control2' -t 'raw' rootvg 3
mklv -y 'control3' -t 'raw' rootvg 3
mklv -y 'spfile' -t 'raw' rootvg 1
mklv -y 'redo' -t 'raw' rootvg 4
mklv -y 'redo2' -t 'raw' rootvg 4
mklv -y 'example' -t 'raw' rootvg 3
3.使用系統命令建立一個(touch /home/oracle/raw_mp.txt)檔案,在檔案中配置如下內容
system=/u01/oracle/oradata/orcl/system01.dbf
sysaux=/u01/oracle/oradata/orcl/sysaux01.dbf
users=/u01/oracle/oradata/orcl/users01.dbf
undotbs1=/u01/oracle/oradata/orcl/undotbs01.dbf
temp=/u01/oracle/oradata/orcl/temp01.dbf
control1=/u01/oracle/oradata/orcl/control01.ctl
control2=/u01/oracle/oradata/orcl/control02.ctl
control3=/u01/oracle/oradata/orcl/control03.ctl
redo1_1=/u01/oracle/oradata/orcl/redo01.log
redo1_2=/u01/oracle/oradata/orcl/redo02.log
example=/u01/oracle/oradata/orcl/example01.dbf
4.將/dev下面的裸裝置的許可權賦給oracle
chown oracle:oinstall /dev/system
chown oracle:oinstall /dev/system
chown oracle:oinstall /dev/sysaux
chown oracle:oinstall /dev/users
chown oracle:oinstall /dev/undotbs
chown oracle:oinstall /dev/temp
chown oracle:oinstall /dev/control1
chown oracle:oinstall /dev/control2
chown oracle:oinstall /dev/control3
chown oracle:oinstall /dev/spfile
chown oracle:oinstall /dev/redo
chown oracle:oinstall /dev/redo2
chown oracle:oinstall /dev/example
chown oracle:oinstall /dev/rsystem
chown oracle:oinstall /dev/rsysaux
chown oracle:oinstall /dev/rusers
chown oracle:oinstall /dev/rundotbs
chown oracle:oinstall /dev/rtemp
chown oracle:oinstall /dev/rcontrol1
chown oracle:oinstall /dev/rcontrol2
chown oracle:oinstall /dev/rcontrol3
chown oracle:oinstall /dev/rspfile
chown oracle:oinstall /dev/rredo
chown oracle:oinstall /dev/rredo2
chown oracle:oinstall /dev/rexample
5.給裸裝置建立一個連結(一定要使用r開頭的裝置)
ln -s /dev/rsystem /u01/oracle/oradata/orcl/system01.dbf
ln -s /dev/rsysaux /u01/oracle/oradata/orcl/sysaux01.dbf
ln -s /dev/rusers /u01/oracle/oradata/orcl/users01.dbf
ln -s /dev/rundotbs /u01/oracle/oradata/orcl/undotbs01.dbf
ln -s /dev/rtemp /u01/oracle/oradata/orcl/temp01.dbf
ln -s /dev/rcontrol1 /u01/oracle/oradata/orcl/control01.ctl
ln -s /dev/rcontrol2 /u01/oracle/oradata/orcl/control02.ctl
ln -s /dev/rcontrol3 /u01/oracle/oradata/orcl/control03.ctl
ln -s /dev/rredo /u01/oracle/oradata/orcl/redo01.log
ln -s /dev/rredo2 /u01/oracle/oradata/orcl/redo02.log
ln -s /dev/rexample /u01/oracle/oradata/orcl/example01.dbf
6.如果中間報0509-136 symbol kaio_rdwr is not export from dependent module/unix錯誤,可以通過如下途 徑解決
(1)smit aio
(2)change
(3)state to be configure at system restart avliable
(4)/usr/sbin/mkdev -l aio0;