Oracle Study之-AIX6.1构建Oracle 10gR2 RAC(5)

喜欢ヅ旅行 2022-07-28 08:53 223阅读 0赞

**一、安装Oracle软件**

**以Oracle身份安装：**

**![Center][]**

**![Center 1][]**

**Oracle软件安装完成后，运行“root.sh”脚本，完成Oracle安装！**

**二、配置网络（Listener）**

**通过netca配置网络：**

**![Center 2][]**

**\[oracle@aix203 Disk1\]$lsnrctl status**

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 16-MAR-2016 17:39:24
    Copyright (c) 1991, 2005, Oracle.  All rights reserved.
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER_AIX203
    Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
    Start Date                16-MAR-2016 17:06:09
    Uptime                    0 days 0 hr. 33 min. 14 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      ON
    Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener_aix203.log
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.251)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.203)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

**三、通过DBCA建库**

**建库准备工作：**

**    由于DataBase是通过raw存储，在建库时为管理方便需做以下准备工作：**

**1）建立raw的链接文件**

**\[oracle@aix203 oracle\]$mkdir -p oradata/prod**  
**\[oracle@aix203 oracle\]$ls**  
**oraInventory  oradata       product**  
**\[oracle@aix203 ~\]$cat mkln.sh**

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

**\[oracle@aix203 ~\]$sh mkln.sh**

**\[oracle@aix203 ~\]$ls -l /u01/app/oracle/oradata/prod/**

total 0
    lrwxrwxrwx    1 oracle   oinstall         16 Mar 16 17:49 control01.ctl -> /dev/rcontrol1_1
    lrwxrwxrwx    1 oracle   oinstall         16 Mar 16 17:49 control02.ctl -> /dev/rcontrol2_2
    lrwxrwxrwx    1 oracle   oinstall         16 Mar 16 17:49 control03.ctl -> /dev/rcontrol3_3
    lrwxrwxrwx    1 oracle   oinstall         13 Mar 16 17:49 example01.dbf -> /dev/rexample
    lrwxrwxrwx    1 oracle   oinstall         11 Mar 16 17:49 index01.dbf -> /dev/rindex
    lrwxrwxrwx    1 oracle   oinstall         13 Mar 16 17:49 log11.log -> /dev/rredo1_1
    lrwxrwxrwx    1 oracle   oinstall         13 Mar 16 17:49 log12.log -> /dev/rredo1_2
    lrwxrwxrwx    1 oracle   oinstall         13 Mar 16 17:49 log21.log -> /dev/rredo2_1
    lrwxrwxrwx    1 oracle   oinstall         13 Mar 16 17:49 log22.log -> /dev/rredo2_2
    lrwxrwxrwx    1 oracle   oinstall         12 Mar 16 17:49 spfile01 -> /dev/rspfile
    lrwxrwxrwx    1 oracle   oinstall         12 Mar 16 17:49 sysaux01.dbf -> /dev/rsysaux
    lrwxrwxrwx    1 oracle   oinstall         12 Mar 16 17:49 system01.dbf -> /dev/rsystem
    lrwxrwxrwx    1 oracle   oinstall         10 Mar 16 17:49 temp01.dbf -> /dev/rtemp
    lrwxrwxrwx    1 oracle   oinstall         14 Mar 16 17:49 undotbs01.dbf -> /dev/rundotbs1
    lrwxrwxrwx    1 oracle   oinstall         14 Mar 16 17:49 undotbs02.dbf -> /dev/rundotbs2
    lrwxrwxrwx    1 oracle   oinstall         11 Mar 16 17:49 users01.dbf -> /dev/rusers

**2）建立raw存储映射**  
**\[oracle@aix203 ~\]$cat 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

**在安装时，DataBase选择“裸设备”**

**![Center 3][]**

**![Center 4][]**

**![Center 5][]**

**四、验证**

**\[oracle@aix203 ~\]$crs\_stat -t**

Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora....03.lsnr application    ONLINE    ONLINE    aix203      
    ora.aix203.gsd application    ONLINE    ONLINE    aix203      
    ora.aix203.ons application    ONLINE    ONLINE    aix203      
    ora.aix203.vip application    ONLINE    ONLINE    aix203      
    ora....04.lsnr application    ONLINE    ONLINE    aix204      
    ora.aix204.gsd application    ONLINE    ONLINE    aix204      
    ora.aix204.ons application    ONLINE    ONLINE    aix204      
    ora.aix204.vip application    ONLINE    ONLINE    aix204      
    ora.prod.db    application    ONLINE    ONLINE    aix204      
    ora....d1.inst application    ONLINE    ONLINE    aix203      
    ora....d2.inst application    ONLINE    ONLINE    aix204

**连接和访问数据库：  
\[oracle@aix203 ~\]$sqlplus '/as sysdba'**

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 16 18:12:43 2016
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options

**SQL> select instance\_name,status from gv$instance;**  
INSTANCE\_NAME    STATUS  
\---------------- ------------  
prod1            OPEN  
prod2            OPEN  
**SQL> select name from v$datafile;**

NAME
    --------------------------------------------------------------------------------
    /u01/app/oracle/oradata/prod/system01.dbf
    /u01/app/oracle/oradata/prod/undotbs01.dbf
    /u01/app/oracle/oradata/prod/sysaux01.dbf
    /u01/app/oracle/oradata/prod/users01.dbf
    /u01/app/oracle/oradata/prod/example01.dbf
    /u01/app/oracle/oradata/prod/undotbs02.dbf
    6 rows selected.

**----------- 至此，整个AIX 6.1下构建Oracle 10gR2 RAC 任务完成！**

[Center]: /images/20220727/92867af134f94cb4be192993acb676e4.png
[Center 1]: /images/20220727/42ed895e56ea4d3ab06d15e51b28ffe8.png
[Center 2]: /images/20220727/0583860b5cae40b8be50839ab7b70c74.png
[Center 3]: /images/20220727/1e846bc4783a467f97cadbb900a56906.png
[Center 4]: /images/20220727/043175b8e2c044b0adee2fef088f06b9.png
[Center 5]: /images/20220727/4ecf047320c640769e87b0719b9ffed1.png