欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2024-04-05 22:31:31
...

Solaris10(x86)构建Oracle10gRAC之--建立数据库系统环境:操作系统:Solaris10(x86-64)Cluster:OracleCRS10.2.0.1.0Oracle:Oracle10.2.0.1.0如图所示:RAC系

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 系统架构

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


四、通过netca建立监听器

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

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


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


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建立数据库

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


建立集群库

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


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


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


数据库存储ASM设备

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


建立ASM Instance的pfile

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


建立ASM DISKGROUP

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


通过RAW建立ASM diskgroup

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


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


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


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


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


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


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