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 系统架构 650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/
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 系统架构
四、通过netca建立监听器
对于listener可以通过netca在建库之前建立，也可以在用dbca建库时来建立。
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建立数据库
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153J5C-3.jpg" style="max-width:90%" title="d1.png" alt="wKioL1TAmEewikJBAAMMuS4G2SA257.jpg" />
建立集群库
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153KZ1-4.jpg" style="max-width:90%" title="d2.png" alt="wKioL1TAmEnSnie_AAHnRU_RlQM456.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153G138-5.jpg" style="max-width:90%" title="d3.png" alt="wKiom1TAl3OjMxTyAAKyoesYAcM960.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153KU8-6.jpg" style="max-width:90%" title="d4.png" alt="wKioL1TAmEuhQWgSAAM-ZXZvCcU142.jpg" />
数据库存储ASM设备
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153L603-7.jpg" style="max-width:90%" title="d5.png" alt="wKiom1TAl3bDPaEdAANlFEJKxDc609.jpg" />
建立ASM Instance的pfile
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153H046-8.jpg" style="max-width:90%" title="d6.png" alt="wKioL1TAmE3waBgIAAJWPTAdi1Q655.jpg" />
建立ASM DISKGROUP
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153I216-9.jpg" style="max-width:90%" title="d7.png" alt="wKioL1TAmE2wAqafAALmC3k8qqM358.jpg" />
通过RAW建立ASM diskgroup
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153H519-10.jpg" style="max-width:90%" title="d8.png" alt="wKiom1TAl3jAhkF8AAKwqddg3lc157.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153IT5-11.jpg" style="max-width:90%" title="d9.png" alt="wKiom1TAl3jTRkltAAKWNeaILM4231.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153L1D-12.jpg" style="max-width:90%" title="d10.png" alt="wKioL1TAmFCi7sKTAALd6GH0Et0509.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153MF2-13.jpg" style="max-width:90%" title="d11.png" alt="wKiom1TAl3vxsJe0AAKYrJDxKG4772.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153I3D-14.jpg" style="max-width:90%" title="d12.png" alt="wKioL1TAmFPiFDT8AAKmLOppX9I679.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153IX3-15.jpg" style="max-width:90%" title="d13.png" alt="wKiom1TAl32RthFPAAL4Zts5ZF4375.jpg" />
650) this.width=650;" src="http://www.68idc.cn/help/uploads/allimg/151111/12153JL9-16.jpg" style="max-width:90%" title="d14.png" alt="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已经架构完成 ！
