分享程序员开发的那些事...
更新时间：2022-03-11 14:22:01
系统环境：
操作系统：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建立成功，验证：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
[root@node1:/]# crs_stat -tName 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 - oracleOracle Corporation SunOS 5.10 Generic Patch January 2005
[oracle@node1:/export/home/oracle]$ lsnrctl statusLSNRCTL 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_NODE1Version 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 offSecurity ON: Local OS AuthenticationSNMP OFFListener 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建立数据库
建立集群库
数据库存储ASM设备
建立ASM Instance的pfile
建立ASM DISKGROUP
通过RAW建立ASM diskgroup
验证：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
[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_diskgroupGROUP_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 optionsSQL> select instance_name,status from gv$instance;INSTANCE_NAME STATUS---------------- ------------prod1 OPENprod2 OPENSQL> alter user scott identified by tiger account unlock;User altered.SQL> conn scott/tigerConnected.SQL> select * from tab;TNAME TABTYPE CLUSTERID------------------------------ ------- ----------DEPT TABLEEMP TABLEBONUS TABLESALGRADE TABLE |
@至此，整个Oracle 10g的RAC已经架构完成 ！
