1、建立 oinstall、dba、oper 组
2、oracle 用户
3、系统参数调优 (AIX 6L 中对 aio 已经采用动态形式,不需要配置,运行 rootpre.sh 警告 aio 的问题可以忽略)
4、检查系统软件包(依赖软件包必须打齐 smit installp)
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
rsct.basic.rte (For RAC configurations only)
rsct.compat.clients.rte (For RAC configurations only)
The August 2007 IBM C++ Runtime Environment Components for AIX (9.0.1)
xlC.aix61.rte:9.0.0.1
xlC.rte:9.0.0.1
5、建立 vg 类型
scanable
(orignal和big )---- auto start --- no concurennt--- PP size 256
在oracle raw 裸设备的时候
,scanable
这个特别要注意。
6、创建卷组,并且创建逻辑卷
[root@aix211 /]#lspv
hdisk0 00040f8aaa29d28e rootvg active hdisk1 000e1a6ce663b4af dbvg active
[root@aix211 /]#cat mklv.sh
mklv -y 'rac_ocr' -t 'raw' dbvg 2 mklv -y 'rac_vote' -t 'raw' dbvg 2 mklv -y 'system' -t 'raw' dbvg 20 mklv -y 'sysaux' -t 'raw' dbvg 10 mklv -y 'users' -t 'raw' dbvg 10 mklv -y 'undotbs1' -t 'raw' dbvg 10 mklv -y 'undotbs2' -t 'raw' dbvg 10 mklv -y 'temp' -t 'raw' dbvg 10 mklv -y 'control1_1' -t 'raw' dbvg 1 mklv -y 'control2_2' -t 'raw' dbvg 1 mklv -y 'control3_3' -t 'raw' dbvg 1 mklv -y 'spfile' -t 'raw' dbvg 1 mklv -y 'redo1_1' -t 'raw' dbvg 2 mklv -y 'redo1_2' -t 'raw' dbvg 2 mklv -y 'redo2_1' -t 'raw' dbvg 2 mklv -y 'redo2_2' -t 'raw' dbvg 2 mklv -y 'example' -t 'raw' dbvg 10 mklv -y 'index' -t 'raw' dbvg 10
[root@aix211 /]#lsvg -l dbvg
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT rac_ocr raw 4 4 1 closed/syncd N/A rac_vote raw 4 4 1 closed/syncd N/A system raw 20 20 1 closed/syncd N/A sysaux raw 10 10 1 closed/syncd N/A users raw 10 10 1 closed/syncd N/A undotbs1 raw 10 10 1 closed/syncd N/A undotbs2 raw 10 10 1 closed/syncd N/A temp raw 10 10 1 closed/syncd N/A control1_1 raw 1 1 1 closed/syncd N/A control2_2 raw 1 1 1 closed/syncd N/A control3_3 raw 1 1 1 closed/syncd N/A spfile raw 1 1 1 closed/syncd N/A redo1_1 raw 2 2 1 closed/syncd N/A redo1_2 raw 2 2 1 closed/syncd N/A redo2_1 raw 2 2 1 closed/syncd N/A redo2_2 raw 2 2 1 closed/syncd N/A example raw 10 10 1 closed/syncd N/A index raw 10 10 1 closed/syncd N/A7、修改逻辑卷的属性和权限chown oracle:dba /dev/rac_ocr chown oracle:dba /dev/rac_vote chown oracle:dba /dev/system chown oracle:dba /dev/sysaux chown oracle:dba /dev/users chown oracle:dba /dev/undotbs1 chown oracle:dba /dev/undotbs2 chown oracle:dba /dev/temp chown oracle:dba /dev/control1_1 chown oracle:dba /dev/control2_2 chown oracle:dba /dev/control3_3 chown oracle:dba /dev/spfile chown oracle:dba /dev/redo1_1 chown oracle:dba /dev/redo1_2 chown oracle:dba /dev/redo2_1 chown oracle:dba /dev/redo2_2 chown oracle:dba /dev/example chown oracle:dba /dev/index chown oracle:dba /dev/rrac_ocr chown oracle:dba /dev/rrac_vote chown oracle:dba /dev/rsystem chown oracle:dba /dev/rsysaux chown oracle:dba /dev/rusers chown oracle:dba /dev/rundotbs1 chown oracle:dba /dev/rundotbs2 chown oracle:dba /dev/rtemp chown oracle:dba /dev/rcontrol1_1 chown oracle:dba /dev/rcontrol2_2 chown oracle:dba /dev/rcontrol3_3 chown oracle:dba /dev/rspfile chown oracle:dba /dev/rredo1_1 chown oracle:dba /dev/rredo1_2 chown oracle:dba /dev/rredo2_1 chown oracle:dba /dev/rredo2_2 chown oracle:dba /dev/rexample chown oracle:dba /dev/rindex chmod 660 /dev/rac_ocr chmod 660 /dev/rac_vote chmod 660 /dev/system chmod 660 /dev/sysaux chmod 660 /dev/users chmod 660 /dev/undotbs1 chmod 660 /dev/undotbs2 chmod 660 /dev/temp chmod 660 /dev/control1_1 chmod 660 /dev/control2_2 chmod 660 /dev/control3_3 chmod 660 /dev/spfile chmod 660 /dev/redo1_1 chmod 660 /dev/redo1_2 chmod 660 /dev/redo2_1 chmod 660 /dev/redo2_2 chmod 660 /dev/example chmod 660 /dev/index chmod 660 /dev/rrac_ocr chmod 660 /dev/rrac_vote chmod 660 /dev/rsystem chmod 660 /dev/rsysaux chmod 660 /dev/rusers chmod 660 /dev/rundotbs1 chmod 660 /dev/rundotbs2 chmod 660 /dev/rtemp chmod 660 /dev/rcontrol1_1 chmod 660 /dev/rcontrol2_2 chmod 660 /dev/rcontrol3_3 chmod 660 /dev/rspfile chmod 660 /dev/rredo1_1 chmod 660 /dev/rredo1_2 chmod 660 /dev/rredo2_1 chmod 660 /dev/rredo2_2 chmod 660 /dev/rexample chmod 660 /dev/rindex8、安装数据库软件9、dbca建库
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30135314/viewspace-1622541/ ,如需转载,请注明出处,否则将追究法律责任。