Solaris 10(x86)构建Oracle 10g RAC之--建立数据库

青旅半醒 2022-08-07 10:40 199阅读 0赞

**Solaris 10(x86)构建Oracle 10g RAC之--建立数据库**

**系统环境：**

**操作系统：Solaris 10（x86-64）**

**Cluster： Oracle CRS 10.2.0.1.0**

**Oracle：  Oracle 10.2.0.1.0**

**如图所示：RAC 系统架构**

**[![wKiom1S\_b-OSHjhcAAGktznT6W4920.jpg][wKiom1S_b-OSHjhcAAGktznT6W4920.jpg]][wKiom1S_b-OSHjhcAAGktznT6W4920.jpg]**

**四、通过netca建立监听器**

**     对于listener可以通过netca在建库之前建立，也可以在用dbca建库时来建立。**

[![wKioL1TAl56xSNlmAALoQZqnPW0979.jpg][]][wKioL1TAl56xSNlmAALoQZqnPW0979.jpg]

[![wKioL1TAl5-C1eceAAMJCYaIYt4401.jpg][]][wKioL1TAl5-C1eceAAMJCYaIYt4401.jpg]

**Listener建立成功，验证：**

[root@node1:/]# crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora....E1.lsnr application    ONLINE    ONLINE    node1       
    ora.node1.gsd  application    ONLINE    ONLINE    node1       
    ora.node1.ons  application    ONLINE    ONLINE    node1       
    ora.node1.vip  application    ONLINE    ONLINE    node1       
    ora....E2.lsnr application    ONLINE    ONLINE    node2       
    ora.node2.gsd  application    ONLINE    ONLINE    node2       
    ora.node2.ons  application    ONLINE    ONLINE    node2       
    ora.node2.vip  application    ONLINE    ONLINE    node2       
    
    [root@node1:/]# su - oracle
    Oracle Corporation      SunOS 5.10      Generic Patch   January 2005
    
    [oracle@node1:/export/home/oracle]$ lsnrctl status
    LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 21-JAN-2015 15:51:45
    Copyright (c) 1991, 2005, Oracle.  All rights reserved.
    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER_NODE1
    Version                   TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
    Start Date                21-JAN-2015 15:50:43
    Uptime                    0 days 0 hr. 1 min. 2 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /export/home/ora10/product/10.2.0/db_1/network/admin/listener.ora
    Listener Log File         /export/home/ora10/product/10.2.0/db_1/network/log/listener_node1.log
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.13)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.8.11)(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建立数据库**

[![wKioL1TAmEewikJBAAMMuS4G2SA257.jpg][]][wKioL1TAmEewikJBAAMMuS4G2SA257.jpg]

**建立集群库**

[![wKioL1TAmEnSnie\_AAHnRU\_RlQM456.jpg][wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg]][wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg]

[![wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg][]][wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg]

[![wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg][]][wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg]

**数据库存储ASM设备**

[![wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg][]][wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg]

**建立ASM Instance的pfile**

[![wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg][]][wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg]

**建立ASM DISKGROUP**

[![wKioL1TAmE2wAqafAALmC3k8qqM358.jpg][]][wKioL1TAmE2wAqafAALmC3k8qqM358.jpg]

**通过RAW建立ASM diskgroup**

[![wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg][]][wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg]

[![wKiom1TAl3jTRkltAAKWNeaILM4231.jpg][]][wKiom1TAl3jTRkltAAKWNeaILM4231.jpg]

[![wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg][]][wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg]

[![wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg][]][wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg]

[![wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg][]][wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg]

[![wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg][]][wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg]

[![wKioL1TAmFWCcxxZAAMw\_tE4vz0963.jpg][wKioL1TAmFWCcxxZAAMw_tE4vz0963.jpg]][wKioL1TAmFWCcxxZAAMw_tE4vz0963.jpg]

**验证：**

[root@node1:/]# crs_stat -t
    Name           Type           Target    State     Host        
    ------------------------------------------------------------
    ora....SM1.asm application    ONLINE    ONLINE    node1       
    ora....E1.lsnr application    ONLINE    ONLINE    node1       
    ora.node1.gsd  application    ONLINE    ONLINE    node1       
    ora.node1.ons  application    ONLINE    ONLINE    node1       
    ora.node1.vip  application    ONLINE    ONLINE    node1       
    ora....SM2.asm application    ONLINE    ONLINE    node2       
    ora....E2.lsnr application    ONLINE    ONLINE    node2       
    ora.node2.gsd  application    ONLINE    ONLINE    node2       
    ora.node2.ons  application    ONLINE    ONLINE    node2       
    ora.node2.vip  application    ONLINE    ONLINE    node2       
    ora.prod.db    application    ONLINE    ONLINE    node2       
    ora....d1.inst application    ONLINE    ONLINE    node1       
    ora....d2.inst application    ONLINE    ONLINE    node2  
    
    查询ASM diskgroup：
    SQL> col name for a20
    SQL> select GROUP_NUMBER,name,STATE,TOTAL_MB,FREE_MB,TYPE from v$asm_diskgroup
    GROUP_NUMBER NAME                 STATE         TOTAL_MB    FREE_MB TYPE
    ------------ -------------------- ----------- ---------- ---------- ------
               1 DG1                  MOUNTED          10244       5962 NORMAL
               2 RCY1                 MOUNTED           8204       7268 NORMAL
    
    查询RDBMS Instance：
    [oracle@node1:/export/home/oracle]$ sqlplus '/as sysdba'
    SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 21 17:13:50 2015
    Copyright (c) 1982, 2005, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 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> alter user scott identified by tiger account unlock;
    User altered.
    
    SQL> conn scott/tiger
    Connected.
    SQL> select * from tab;
    TNAME                          TABTYPE  CLUSTERID
    ------------------------------ ------- ----------
    DEPT                           TABLE
    EMP                            TABLE
    BONUS                          TABLE
    SALGRADE                       TABLE

@至此，整个Oracle 10g的RAC已经架构完成 ！

本文出自 “[天涯客的blog][blog]” 博客，请务必保留此出处[http://tiany.blog.51cto.com/513694/1606987][http_tiany.blog.51cto.com_513694_1606987]

[wKiom1S_b-OSHjhcAAGktznT6W4920.jpg]: /images/20220805/9a3a3211172b4f4785ef84d595bf0c26.png
[wKioL1TAl56xSNlmAALoQZqnPW0979.jpg]: /images/20220805/f018a5b01aa44bd5848e1b98bdd10e40.png
[wKioL1TAl5-C1eceAAMJCYaIYt4401.jpg]: /images/20220805/e86449fcb2e74a96be0afe8085604c41.png
[wKioL1TAmEewikJBAAMMuS4G2SA257.jpg]: /images/20220805/1ad773228cff46189ef4d319d040a1ad.png
[wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg]: /images/20220805/02d7f6bfd5ff45d993e92719b56e89ce.png
[wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg]: /images/20220805/71f1e011fed946d48355150972976b64.png
[wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg]: /images/20220805/b940c62ca69c4def8ca6c00f93c7dbf0.png
[wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg]: /images/20220805/e080564c064d46169331f0b754e28f94.png
[wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg]: /images/20220805/a52f589f46474f47ae993968060a8758.png
[wKioL1TAmE2wAqafAALmC3k8qqM358.jpg]: /images/20220805/9b6a7afc221e4563ad89f9ccef50502c.png
[wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg]: /images/20220805/ff91985826434f7b87c305674b7aef69.png
[wKiom1TAl3jTRkltAAKWNeaILM4231.jpg]: /images/20220805/29b2c32685564ad58d1f457e54594d76.png
[wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg]: /images/20220805/14ac60f07ce646bdbc95e8996c4bec37.png
[wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg]: /images/20220805/1ee29ab2fcb34462ba5f97c4913aacb5.png
[wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg]: /images/20220805/58b22bda9e13430ba1bcec470cc7ca3e.png
[wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg]: /images/20220805/472abea453b84ea5b88bbacb8de009e7.png
[wKioL1TAmFWCcxxZAAMw_tE4vz0963.jpg]: /images/20220805/fae02e238674484aae520cc93b27aaf3.png
[blog]: http://tiany.blog.51cto.com
[http_tiany.blog.51cto.com_513694_1606987]: http://tiany.blog.51cto.com/513694/1606987