系统环境:
操作系统: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 -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建立数据库
建立集群库
数据库存储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_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已经架构完成 !
本文转自 客居天涯 51CTO博客,原文链接:http://blog.51cto.com/tiany/1606987,如需转载请自行联系原作者