构建AIX环境下的RAC之--安装Oracle及建库(终结篇)
构建AIX环境下的RAC之--安装Oracle及建库(终结篇)
环境:
操作系统: AIX 5300-09
集群软件: CRS 10.2.0.1
数据库: Oracle 10.2.0.1
Oracle 软件安装和但实例安装相似。
1、以oracle 用户登录,图形安装
2、以oracle用户通过dbca建库
建库前的准备工作:
1、建立raw的链接文件(所有节点)
[[email protected] ~]$ mkdir -p /u01/app/oracle/oradata/prod
------建立链接
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
ln -s /dev/rsystem /u01/app/oracle/oradata/prod/system01.dbf ln -s /dev/rsysaux /u01/app/oracle/oradata/prod/sysaux01.dbf ln -s /dev/rusers /u01/app/oracle/oradata/prod/users01.dbf ln -s /dev/rundotbs1 /u01/app/oracle/oradata/prod/undotbs01.dbf ln -s /dev/rundotbs2 /u01/app/oracle/oradata/prod/undotbs02.dbf ln -s /dev/rtemp /u01/app/oracle/oradata/prod/temp01.dbf ln -s /dev/rcontrol1_1 /u01/app/oracle/oradata/prod/control01.ctl ln -s /dev/rcontrol2_2 /u01/app/oracle/oradata/prod/control02.ctl ln -s /dev/rcontrol3_3 /u01/app/oracle/oradata/prod/control03.ctl ln -s /dev/rredo1_1 /u01/app/oracle/oradata/prod/log11.log ln -s /dev/rredo1_2 /u01/app/oracle/oradata/prod/log12.log ln -s /dev/rredo2_1 /u01/app/oracle/oradata/prod/log21.log ln -s /dev/rredo2_2 /u01/app/oracle/oradata/prod/log22.log ln -s /dev/rindex /u01/app/oracle/oradata/prod/index01.dbf ln -s /dev/rspfile /u01/app/oracle/oradata/prod/spfile01 ln -s /dev/rexample /u01/app/oracle/oradata/prod/example01.dbf |
2、共享存储选择raw ,建立raw的map 文件
[[email protected] ~]$ vi map.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
system=/u01/app/oracle/oradata/prod/system01.dbf sysaux=/u01/app/oracle/oradata/prod/sysaux01.dbf users=/u01/app/oracle/oradata/prod/users01.dbf undotbs1=/u01/app/oracle/oradata/prod/undotbs01.dbf undotbs2=/u01/app/oracle/oradata/prod/undotbs02.dbf temp=/u01/app/oracle/oradata/prod/temp01.dbf control1=/u01/app/oracle/oradata/prod/control01.ctl control2=/u01/app/oracle/oradata/prod/control02.ctl control3=/u01/app/oracle/oradata/prod/control03.ctl redo1_1=/u01/app/oracle/oradata/prod/log11.log redo1_2=/u01/app/oracle/oradata/prod/log12.log redo2_1=/u01/app/oracle/oradata/prod/log21.log redo2_2=/u01/app/oracle/oradata/prod/log22.log index=/u01/app/oracle/oradata/prod/index01.dbf spfile=/u01/app/oracle/oradata/prod/spfile01 example=/u01/app/oracle/oradata/prod/example01.dbf |
3、验证:
[[email protected]@ /]#crs_stat -t
1
2
3
4
5
6
7
8
9
10
11
12
13
|
Name Type Target State Host ------------------------------------------------------------ ora... .11. lsnr application ONLINE ONLINE aix211
ora.aix211.gsd application ONLINE ONLINE aix211 ora.aix211.ons application ONLINE ONLINE aix211 ora.aix211.vip application ONLINE ONLINE aix211 ora... .12. lsnr application ONLINE ONLINE aix212
ora.aix212.gsd application ONLINE ONLINE aix212 ora.aix212.ons application ONLINE ONLINE aix212 ora.aix212.vip application ONLINE ONLINE aix212 ora.prod.db application ONLINE ONLINE aix212 ora....d1.inst application ONLINE ONLINE aix211 ora....d2.inst application ONLINE ONLINE aix212 |
SQL> select instance_name,status from gv$instance;
1
2
3
4
|
INSTANCE_NAME STATUS ---------------- ------------ prod2 OPEN prod1 OPEN |
@至此,整个AIX 平台下的RAC 构建完成,对AIX下的RAC的应用和管理,还是一个任重道远的工作!
本文转自 客居天涯 51CTO博客,原文链接:http://blog.51cto.com/tiany/1390742,如需转载请自行联系原作者