构建AIX环境下的RAC之--安装Oracle及建库(终结篇)

环境:

操作系统: AIX 5300-09

集群软件: CRS 10.2.0.1

数据库:   Oracle 10.2.0.1

Oracle 软件安装和但实例安装相似。

1、以oracle 用户登录,图形安装


wKiom1M-gyPRB5rVAAbdmugqyLs786.jpg

wKioL1M-gvvx3N-sAATbXQb9DG4622.jpg

wKioL1M-gvyCLO3tAAW9nHfEXo8619.jpg

wKiom1M-gySDix52AATePVrAoLg731.jpg

wKioL1M-gvygDkSzAAVpWmIzChc186.jpg

2、以oracle用户通过dbca建库

建库前的准备工作:

1、建立raw的链接文件(所有节点)

[oracle@aix211 ~]$ mkdir -p /u01/app/oracle/oradata/prod

------建立链接

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 文件

[oracle@aix211 ~]$ vi map.txt

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

wKiom1M-g1CC_VU7AAQMUC1ReDw257.jpg

wKioL1M-g27T-8Y_AAN5ZqNOr5E071.jpg

wKiom1M-g5fTp5jjAAOMqL6ad2A821.jpg

wKioL1M-g2-jkUIwAAXeDp3C8OA003.jpg

wKioL1M-g2_g_EbjAAP1CPVqcfE984.jpg

wKiom1M-g5fBo35TAARfkeQqFVI017.jpg

3、验证:

[root@aix212@ /]#crs_stat -t

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;

INSTANCE_NAME    STATUS
---------------- ------------
prod2            OPEN
prod1            OPEN

@至此,整个AIX 平台下的RAC 构建完成,对AIX下的RAC的应用和管理,还是一个任重道远的工作!