在AIX 6上安装oracle10g裸设备

在AIX 6.1 上安装 oracle 10g 裸设备1、建立 oinstall、dba、oper 组2、oracle 用户3、系统参数调优 （AIX 6L 中对 aio 已经采用动态形式，不需要配置，运行 rootpre.sh 警告 aio 的问题可以忽略）4、检查系统软件包（依赖软件包必须打齐 smit installp）ctoolsrsct.basic.rte (For RAC configurations only)pat.clients.rte (For RAC configurations only)The August 2007 IBM C+ Runtime Environment Components for AIX (9.0.1) xlC.aix61.rte: xlC.rte: #smit languge /插入第一张系统盘，选择安装语言5、建立 vg 类型 scanable （orignal和big ）- auto start - no concurennt- PP size 256在oracle raw 裸设备的时候，scanable 这个特别要注意。6、建立文件系统#smit crfs / enhence journaled filesystem(jfs2) / mount point /大小系统LV：mklv -ylvgisdata03 -T O -wn -sn -rn -t raw gisvg 20mklv -yusers_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ytools_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ytemp_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -yundotbs1_2g -t jfs2 -wn -sn -rn jzhcdatavg 8mklv -yundotbs2_2g -t jfs2 -wn -sn -rn jzhcdatavg 8mklv -ylog11_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -ylog12_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -ylog21_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -ylog22_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -ylog31_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -ylog32_1g -t jfs2 -wn -sn -rn jzhcdatavg 4mklv -yindx_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -yspfile_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ycntrl1_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ycntrl2_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ycntrl3_512m -t jfs2 -wn -sn -rn jzhcdatavg 2mklv -ysysaux_2g -t jfs2 -wn -sn -rn jzhcdatavg 8mklv -ysystems_2g -t jfs2 -wn -sn -rn jzhcdatavg 8mklv -ysrvcfg_512m -t jfs2 -wn -sn -rn jzhcdatavg 2数据 LV：mklv -y data1lv01_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv02_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv03_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv04_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv05_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv06_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv07_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv08_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv09_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv10_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv11_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv12_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv13_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv14_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv15_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv16_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv17_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv18_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv19_1g -t jfs2 -wn -sn -rn hc_datavg1 4mklv -y data1lv20_1g -t jfs2 -wn -sn -rn hc_datavg1 4单机AIX 安装oracle#vi .profileumask 022PS1=whoamihostname:$PWD$export PS1ORACLE_BASE=/oracle/app/oracleexport ORACLE_BASEORACLE_SID=cachedbexport ORACLE_SIDORACLE_HOME=/oracle/app/oracle/product/10.2.0/db_1export ORACLE_HOMENLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANGLD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATHPATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHPATH=$ORACLE_HOME/bin:$PATHexport PATHexport DBCA_RAW_CONFIG=/home/oracle/raw_map.txt / 裸设备对应文件/home/oracle/raw_map.txt 文件为system=/dev/rsystems_2gusers=/dev/rusers_512mtemp=/dev/rtemp_512mundotbs1=/dev/rundotbs1_2gundotbs2=/dev/rundotbs2_2gcontrol1=/dev/rcntrl1_512mcontrol2=/dev/rcntrl2_512mcontrol3=/dev/rcntrl3_512mredo1_1=/dev/rlog11_1gredo1_2=/dev/rlog12_1gredo2_1=/dev/rlog21_1gredo2_2=/dev/rlog22_1gredo3_1=/dev/rlog31_1gredo3_2=/dev/rlog32_1gspfile=/dev/rspfile_512mindx=/dev/rindx_512mtools=/dev/rtools_512msysaux=/dev/rsysaux_2g开始安装数据库运行 ./runInstaller#dbca 建库1、自定义安装数据库 custom database2、raw 裸设备 。 选择mapping file /home/oracle/raw_map.txt3、按上面建立的LV 对应建库SQL select * from v$tablespace; /系统表空间 TS# NAME INC BIG FLA ENC- - - - - - 0 SYSTEM YES NO YES 1 UNDOTBS1 YES NO YES 2 SYSAUX YES NO YES 3 TEMP NO NO YES 4 USERS YES NO YESselect name from v$datafileselect member from v$logfileselect name from v$controlfile一、分区分区的步骤不说了，把硬盘分为如下几个区：rootsuk1 # fdisk -l /dev/sdbDisk /dev/sdb: 4294 MB, 4294967296 bytes255 heads, 63 sectors/track, 522 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesDevice Boot Start End Blocks Id System/dev/sdb1 1 44 353398+ 83 Linux/dev/sdb2 45 69 200812+ 83 Linux/dev/sdb3 70 88 152617+ 83 Linux/dev/sdb4 89 522 3486105 5 Extended/dev/sdb5 89 101 104391 83 Linux/dev/sdb6 102 114 104391 83 Linux/dev/sdb7 115 117 24066 83 Linux/dev/sdb8 118 120 24066 83 Linux/dev/sdb9 121 127 56196 83 Linux/dev/sdb10 128 134 56196 83 Linux2、绑定裸设备绑定裸设备有两种方式1）用命令绑定rootsuk1 raw# raw /dev/raw/raw1 /dev/sdb1/dev/raw/raw1: bound to major 8, minor 17rootsuk1 raw# raw /dev/raw/raw2 /dev/sdb2/dev/raw/raw2: bound to major 8, minor 18rootsuk1 raw# raw /dev/raw/raw3 /dev/sdb3/dev/raw/raw3: bound to major 8, minor 19rootsuk1 raw# raw /dev/raw/raw5 /dev/sdb5/dev/raw/raw5: bound to major 8, minor 21rootsuk1 raw# raw /dev/raw/raw6 /dev/sdb6/dev/raw/raw6: bound to major 8, minor 22rootsuk1 raw# raw /dev/raw/raw7 /dev/sdb7/dev/raw/raw7: bound to major 8, minor 23rootsuk1 raw# raw /dev/raw/raw8 /dev/sdb8/dev/raw/raw8: bound to major 8, minor 24rootsuk1 raw# raw /dev/raw/raw9 /dev/sdb9/dev/raw/raw9: bound to major 8, minor 25rootsuk1 raw# raw /dev/raw/raw10 /dev/sdb10/dev/raw/raw10: bound to major 8, minor 26rootsuk1 raw# raw -qa/dev/raw/raw1: bound to major 8, minor 17/dev/raw/raw2: bound to major 8, minor 18/dev/raw/raw3: bound to major 8, minor 19/dev/raw/raw5: bound to major 8, minor 21/dev/raw/raw6: bound to major 8, minor 22/dev/raw/raw7: bound to major 8, minor 23/dev/raw/raw8: bound to major 8, minor 24/dev/raw/raw9: bound to major 8, minor 25/dev/raw/raw10: bound to major 8, minor 26注意：/dev/sdb4是扩展分区，不要把裸设备绑定到那个分区上。这种方式绑定的裸设备在OS重启后会失效，为了你重启后仍然生效，你可以修改/etc/rc.local文件，将如下内容加入到/etc/rc.local文件中：raw /dev/raw/raw1 /dev/sdb1raw /dev/raw/raw2 /dev/sdb2raw /dev/raw/raw3 /dev/sdb3raw /dev/raw/raw5 /dev/sdb5raw /dev/raw/raw6 /dev/sdb6raw /dev/raw/raw7 /dev/sdb7raw /dev/raw/raw8 /dev/sdb8raw /dev/raw/raw9 /dev/sdb9raw /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然后启动服务：rootsuk1 raw# service rawdevices startrootsuk1 raw# service rawdevices startAssigning devices:/dev/raw/raw1 - /dev/sdb1/dev/raw/raw1: bound to major 8, minor 17/dev/raw/raw2 - /dev/sdb2/dev/raw/raw2: bound to major 8, minor 18/dev/raw/raw3 - /dev/sdb3/dev/raw/raw3: bound to major 8, minor 19/dev/raw/raw5 - /dev/sdb5/dev/raw/raw5: bound to major 8, minor 21/dev/raw/raw6 - /dev/sdb6/dev/raw/raw6: bound to major 8, minor 22/dev/raw/raw7 - /dev/sdb7/dev/raw/raw7: bound to major 8, minor 23/dev/raw/raw8 - /dev/sdb8/dev/raw/raw8: bound to major 8, minor 24/dev/raw/raw9 - /dev/sdb9/dev/raw/raw9: bound to major 8, minor 25/dev/raw/raw10 - /dev/sdb10这种方式绑定的裸设备在OS重启后仍然生效。3、修改裸设备的属主修改裸设备的属主也有两种方式：1）命令修改命令修改很简单：rootsuk1 raw# chown oracle:oinstall /dev/raw/raw1rootsuk1 raw# chown oracle:oinstall /dev/raw/raw2rootsuk1 raw# chown oracle:oinstall /dev/raw/raw3rootsuk1 raw# chown oracle:oinstall /dev/raw/raw4rootsuk1 raw# chown oracle:oinstall /dev/raw/raw5rootsuk1 raw# chown oracle:oinstall /dev/raw/raw6rootsuk1 raw# chown oracle:oinstall /dev/raw/raw7rootsuk1 raw# chown oracle:oinstall /dev/raw/raw8rootsuk1 raw# chown oracle:oinstall /dev/raw/raw9rootsuk1 raw# chown oracle:oinstall /dev/raw/raw10由于/dev下的文件都是动态建立的，所以在OS重启后，属主仍会变成root:disk，要解决这个问题，可以把上面的命令写入到/etc/rc.local文件中：chown oracle:oinstall /dev/raw/raw1chown oracle:oinstall /dev/raw/raw2chown oracle:oinstall /dev/raw/raw3 chown oracle:oinstall /dev/raw/raw4chown oracle:oinstall /dev/raw/raw5chown oracle:oinstall /dev/raw/raw6chown oracle:oinstall /dev/raw/raw7chown oracle:oinstall /dev/raw/raw8chown oracle:oinstall /dev/raw/raw9chown oracle: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、创建符号链接这一步可以省略，但是为了更直观些，建议建立软链接oraclesuk1 $ cd $ORACLE_BASEoraclesuk1 oracle$ lsoraInventory productoraclesuk1 or