在AIX 6上安装oracle10g裸设备.docx
- 文档编号:17703444
- 上传时间:2023-08-03
- 格式:DOCX
- 页数:12
- 大小:20.26KB
在AIX 6上安装oracle10g裸设备.docx
《在AIX 6上安装oracle10g裸设备.docx》由会员分享,可在线阅读,更多相关《在AIX 6上安装oracle10g裸设备.docx(12页珍藏版)》请在冰点文库上搜索。
在AIX6上安装oracle10g裸设备
在AIX6.1上安装oracle10g裸设备
1、建立oinstall、dba、oper组
2、oracle用户
3、系统参数调优(AIX6L中对aio已经采用动态形式,不需要配置,运行rootpre.sh警告aio的问题可以忽略)
4、检查系统软件包(依赖软件包必须打齐smitinstallp)
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
rsct.basic.rte (ForRACconfigurationsonly)
pat.clients.rte (ForRACconfigurationsonly)
TheAugust2007IBMC++RuntimeEnvironmentComponentsforAIX(9.0.1)
xlC.aix61.rte:
9.0.0.1
xlC.rte:
9.0.0.1
#smitlanguge //插入第一张系统盘,选择安装语言
5、建立vg类型scanable(orignal和big)----autostart---noconcurennt---PPsize 256
在oracle raw裸设备的时候,scanable这个特别要注意。
6、建立文件系统
#smitcrfs //enhencejournaledfilesystem(jfs2)/mountpoint/大小
系统LV:
mklv-y'lvgisdata03'-TO-w'n'-s'n'-r'n'-trawgisvg20
mklv-y'users_512m'-t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'tools_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'temp_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'undotbs1_2g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg8
mklv-y'undotbs2_2g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg8
mklv-y'log11_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'log12_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'log21_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'log22_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'log31_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'log32_1g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg4
mklv-y'indx_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'spfile_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'cntrl1_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'cntrl2_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'cntrl3_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
mklv-y'sysaux_2g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg8
mklv-y'systems_2g' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg8
mklv-y'srvcfg_512m' -t'jfs2'-w'n'-s'n'-r'n'jzhcdatavg2
数据LV:
mklv-y'data1lv01_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv02_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv03_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv04_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv05_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv06_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv07_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv08_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv09_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv10_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv11_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv12_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv13_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv14_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv15_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv16_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv17_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv18_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv19_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
mklv-y'data1lv20_1g'-t'jfs2-w'n'-s'n'-r'n'hc_datavg14
单机AIX安装oracle
#vi.profile
umask022
PS1="[`whoami`@`hostname`:
"'$PWD]$'
exportPS1
ORACLE_BASE=/oracle/app/oracle
exportORACLE_BASE
ORACLE_SID=cachedb
exportORACLE_SID
ORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1
exportORACLE_HOME
NLS_LANG='AMERICAN_AMERICA.ZHS16GBK'
exportNLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib
exportLD_LIBRARY_PATH
PATH=/usr/bin:
/etc:
/usr/sbin:
/usr/ucb:
$HOME/bin:
/usr/bin/X11:
/sbin:
.
exportPATH
PATH=$ORACLE_HOME/bin:
$PATH
exportPATH
exportDBCA_RAW_CONFIG=/home/oracle/raw_map.txt //裸设备对应文件
/home/oracle/raw_map.txt文件为
system=/dev/rsystems_2g
users=/dev/rusers_512m
temp=/dev/rtemp_512m
undotbs1=/dev/rundotbs1_2g
undotbs2=/dev/rundotbs2_2g
control1=/dev/rcntrl1_512m
control2=/dev/rcntrl2_512m
control3=/dev/rcntrl3_512m
redo1_1=/dev/rlog11_1g
redo1_2=/dev/rlog12_1g
redo2_1=/dev/rlog21_1g
redo2_2=/dev/rlog22_1g
redo3_1=/dev/rlog31_1g
redo3_2=/dev/rlog32_1g
spfile=/dev/rspfile_512m
indx=/dev/rindx_512m
tools=/dev/rtools_512m
sysaux=/dev/rsysaux_2g
开始安装数据库
运行./runInstaller
#dbca建库
1、自定义安装数据库customdatabase
2、raw裸设备。
选择mappingfile /home/oracle/raw_map.txt
3、按上面建立的LV对应建库
SQL>select*fromv$tablespace; //系统表空间
TS#NAME INCBIGFLAENC
----------------------------------------------------
0SYSTEM YESNO YES
1UNDOTBS1 YESNO YES
2SYSAUX YESNO YES
3TEMP NO NO YES
4USERS YESNO YES
selectnamefromv$datafile
selectmemberfromv$logfile
selectnamefromv$controlfile
一、分区
分区的步骤不说了,把硬盘分为如下几个区:
[root@suk1~]#fdisk-l/dev/sdb
Disk/dev/sdb:
4294MB,4294967296bytes
255heads,63sectors/track,522cylinders
Units=cylindersof16065*512=8225280bytes
DeviceBootStartEndBlocksIdSystem
/dev/sdb1144353398+83Linux
/dev/sdb24569200812+83Linux
/dev/sdb37088152617+83Linux
/dev/sdb48952234861055Extended
/dev/sdb58910110439183Linux
/dev/sdb610211410439183Linux
/dev/sdb71151172406683Linux
/dev/sdb81181202406683Linux
/dev/sdb91211275619683Linux
/dev/sdb101281345619683Linux
2、绑定裸设备
绑定裸设备有两种方式
1)用命令绑定
[root@suk1raw]#raw/dev/raw/raw1/dev/sdb1
/dev/raw/raw1:
boundtomajor8,minor17
[root@suk1raw]#raw/dev/raw/raw2/dev/sdb2
/dev/raw/raw2:
boundtomajor8,minor18
[root@suk1raw]#raw/dev/raw/raw3/dev/sdb3
/dev/raw/raw3:
boundtomajor8,minor19
[root@suk1raw]#raw/dev/raw/raw5/dev/sdb5
/dev/raw/raw5:
boundtomajor8,minor21
[root@suk1raw]#raw/dev/raw/raw6/dev/sdb6
/dev/raw/raw6:
boundtomajor8,minor22
[root@suk1raw]#raw/dev/raw/raw7/dev/sdb7
/dev/raw/raw7:
boundtomajor8,minor23
[root@suk1raw]#raw/dev/raw/raw8/dev/sdb8
/dev/raw/raw8:
boundtomajor8,minor24
[root@suk1raw]#raw/dev/raw/raw9/dev/sdb9
/dev/raw/raw9:
boundtomajor8,minor25
[root@suk1raw]#raw/dev/raw/raw10/dev/sdb10
/dev/raw/raw10:
boundtomajor8,minor26
[root@suk1raw]#raw-qa
/dev/raw/raw1:
boundtomajor8,minor17
/dev/raw/raw2:
boundtomajor8,minor18
/dev/raw/raw3:
boundtomajor8,minor19
/dev/raw/raw5:
boundtomajor8,minor21
/dev/raw/raw6:
boundtomajor8,minor22
/dev/raw/raw7:
boundtomajor8,minor23
/dev/raw/raw8:
boundtomajor8,minor24
/dev/raw/raw9:
boundtomajor8,minor25
/dev/raw/raw10:
boundtomajor8,minor26
注意:
/dev/sdb4是扩展分区,不要把裸设备绑定到那个分区上。
这种方式绑定的裸设备在OS重启后会失效,为了你重启后仍然生效,你可以修改/etc/rc.local文件,将如下内容加入到/etc/rc.local文件中:
raw/dev/raw/raw1/dev/sdb1
raw/dev/raw/raw2/dev/sdb2
raw/dev/raw/raw3/dev/sdb3
raw/dev/raw/raw5/dev/sdb5
raw/dev/raw/raw6/dev/sdb6
raw/dev/raw/raw7/dev/sdb7
raw/dev/raw/raw8/dev/sdb8
raw/dev/raw/raw9/dev/sdb9
raw/dev/raw/raw10/dev/sdb10
这种方式实际上就是在开机的时候执行/etc/rc.local文件里的raw命令进行绑定的。
2)用服务的方式绑定
修改/etc/sysconfig/rawdevices文件如下,以开机时自动加载裸设备
/dev/raw/raw1/dev/sdb1
/dev/raw/raw2/dev/sdb2
/dev/raw/raw3/dev/sdb3
/dev/raw/raw5/dev/sdb5
/dev/raw/raw6/dev/sdb6
/dev/raw/raw7/dev/sdb7
/dev/raw/raw8/dev/sdb8
/dev/raw/raw9/dev/sdb9
/dev/raw/raw10/dev/sdb10
然后启动服务:
[root@suk1raw]#servicerawdevicesstart
[root@suk1raw]#servicerawdevicesstart
Assigningdevices:
/dev/raw/raw1-->/dev/sdb1
/dev/raw/raw1:
boundtomajor8,minor17
/dev/raw/raw2-->/dev/sdb2
/dev/raw/raw2:
boundtomajor8,minor18
/dev/raw/raw3-->/dev/sdb3
/dev/raw/raw3:
boundtomajor8,minor19
/dev/raw/raw5-->/dev/sdb5
/dev/raw/raw5:
boundtomajor8,minor21
/dev/raw/raw6-->/dev/sdb6
/dev/raw/raw6:
boundtomajor8,minor22
/dev/raw/raw7-->/dev/sdb7
/dev/raw/raw7:
boundtomajor8,minor23
/dev/raw/raw8-->/dev/sdb8
/dev/raw/raw8:
boundtomajor8,minor24
/dev/raw/raw9-->/dev/sdb9
/dev/raw/raw9:
boundtomajor8,minor25
/dev/raw/raw10-->/dev/sdb10
这种方式绑定的裸设备在OS重启后仍然生效。
3、修改裸设备的属主
修改裸设备的属主也有两种方式:
1)命令修改
命令修改很简单:
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw1
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw2
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw3
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw4
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw5
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw6
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw7
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw8
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw9
[root@suk1raw]#chownoracle:
oinstall/dev/raw/raw10
由于/dev下的文件都是动态建立的,所以在OS重启后,属主仍会变成root:
disk,要解决这个问题,可以把上面的命令写入到/etc/rc.local文件中:
chownoracle:
oinstall/dev/raw/raw1
chownoracle:
oinstall/dev/raw/raw2
chownoracle:
oinstall/dev/raw/raw3
chownoracle:
oinstall/dev/raw/raw4
chownoracle:
oinstall/dev/raw/raw5
chownoracle:
oinstall/dev/raw/raw6
chownoracle:
oinstall/dev/raw/raw7
chownoracle:
oinstall/dev/raw/raw8
chownoracle:
oinstall/dev/raw/raw9
chownoracle:
oinstall/dev/raw/raw10
这样每次开机后可以重新改变属主。
2)修改/etc/udev/permissions.d/50-udev.permissions文件
将/etc/udev/permissions.d/50-udev.permissions的113行
从
raw/*:
root:
disk:
0660
修改为
raw/*:
oracle:
oinstall:
0660
这个的意思是修改裸设备的默认属主为oracle:
oinstall,默认的mode是0660。
重启OS检验。
4、创建符号链接
这一步可以省略,但是为了更直观些,建议建立软链接
[oracle@suk1~]$cd$ORACLE_BASE
[oracle@suk1oracle]$ls
oraInventoryproduct
[oracle@suk1oracle]$mkdir-poradata/test1
[oracle@suk1oracle]$cdoradata/test1
[oracle@suk1oradata]$ln-s/dev/raw/raw1system01.dbf
[oracle@suk1oradata]$ln-s/dev/raw/raw2undotbs01.dbf
[oracle@suk1oradata]$ln-s/dev
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 在AIX 6上安装oracle10g裸设备 AIX 安装 oracle10g 设备