oracle10g 是rac,dbca建库-RAC安装完成 - Oracle10.2.0.4-RAC两节点集群环境搭建_数据库技术_Linux公社-Linux系统门户网站...

Oracle用户下,dbca启动界面，来创建数据库实例：

选择节点：

配置ORACLE_SID

选择ASM存储(ASM磁盘之前已经创建)

换成pfile

这里提示没有监听，选Yes，会自动配置监听

/oracle/product/10.2.0/crs_1/log/dbcc1/crsd/crsd.log日志信息

2014-02-2010:12:07.926: [ CRSRES][1515489600]0Resource Registered: ora.dbcc1.LISTENER_DBCC1.lsnr

2014-02-2010:12:14.012: [ CRSRES][1515489600]0Resource Registered: ora.dbcc2.LISTENER_DBCC2.lsnr

2014-02-2010:12:15.792: [ CRSRES][1515489600]0startRunnable: setting CLI values

2014-02-2010:12:15.953: [ CRSRES][1515489600]0Attempting to start `ora.dbcc1.LISTENER_DBCC1.lsnr`on member `dbcc1`

2014-02-2010:12:16.809: [ CRSRES][1515489600]0Start of `ora.dbcc1.LISTENER_DBCC1.lsnr` on member`dbcc1` succeeded.

2014-02-2010:12:17.796: [ CRSRES][1515489600]0Attempting to start `ora.dbcc2.LISTENER_DBCC2.lsnr`on member `dbcc2`

2014-02-2010:12:18.745: [ CRSRES][1515489600]0Startof `ora.dbcc2.LISTENER_DBCC2.lsnr` on member `dbcc2` succeeded.

2014-02-2010:12:32.655: [ CRSRES][1492408640]0Resource Registered: ora.dbcc1.ASM1.asm

2014-02-2010:12:35.042: [ CRSRES][1515489600]0startRunnable: setting CLI values

2014-02-2010:12:35.267: [ CRSRES][1515489600]0Attempting to start `ora.dbcc1.ASM1.asm` on member`dbcc1`

2014-02-2010:12:37.484: [ CRSRES][1515489600]0Start of `ora.dbcc1.ASM1.asm` on member `dbcc1`succeeded.

2014-02-2010:12:43.520: [ CRSRES][1492408640]0ResourceRegistered: ora.dbcc2.ASM2.asm

2014-02-2010:12:45.959: [ CRSRES][1515489600]0Attempting to start `ora.dbcc2.ASM2.asm` on member`dbcc2`

2014-02-2010:12:50.868: [ CRSRES][1515489600]0Start of `ora.dbcc2.ASM2.asm` on member `dbcc2`succeeded.

下面开始创建ASM磁盘：Create New

输入磁盘组名称DATA，选择之前创建的DATA asmdisk

再创建一个磁盘组

ASM磁盘组创建完成：

选择数据文件存放在那个磁盘组

选择Flash Recovery Area存放位置，大小；是否开启归档。这里不选，以后手工开启；

现在ASM配置完成了，可以查看一下组件状态

[root@dbcc1~]# /oracle/product/10.2.0/crs_1/bin/crs_stat -t

Name Type Target State Host

---------------------------------------------------------------------------------

ora....SM1.asmapplication ONLINE ONLINE dbcc1

ora....C1.lsnrapplication ONLINE ONLINE dbcc1

ora.dbcc1.gsd application ONLINE ONLINE dbcc1

ora.dbcc1.ons application ONLINE ONLINE dbcc1

ora.dbcc1.vip application ONLINE ONLINE dbcc1

ora....SM2.asmapplication ONLINE ONLINE dbcc2

ora....C2.lsnrapplication ONLINE ONLINE dbcc2

ora.dbcc2.gsd application ONLINE ONLINE dbcc2

ora.dbcc2.ons application ONLINE ONLINE dbcc2

ora.dbcc2.vip application ONLINE ONLINE dbcc2

多了ASM和监听；

配置内存参数，这里我的物理内存是3G，内存参数默认

配置数据库语言

这里我勾选生成建库脚本，留着研究实例创建过程

实例创建中，等一会可以看到实例组件以及注册，但是是OFFLINE的

[root@dbcc1~]#/oracle/product/10.2.0/crs_1/bin/crs_stat-t

Name Type Target State Host

---------------------------------------------------------------------------------

ora.dbcc.db application OFFLINE OFFLINE

ora....c1.inst application OFFLINE OFFLINE

ora....c2.inst application OFFLINE OFFLINE

ora....SM1.asm application ONLINE ONLINE dbcc1

ora....C1.lsnr application ONLINE ONLINE dbcc1

ora.dbcc1.gsd application ONLINE ONLINE dbcc1

ora.dbcc1.ons application ONLINE ONLINE dbcc1

ora.dbcc1.vip application ONLINE ONLINE dbcc1

ora....SM2.asm application ONLINE ONLINE dbcc2

ora....C2.lsnr application ONLINE ONLINE dbcc2

ora.dbcc2.gsd application ONLINE ONLINE dbcc2

ora.dbcc2.ons application ONLINE ONLINE dbcc2

ora.dbcc2.vip application ONLINE ONLINE dbcc2

继续等待实例创建

在88%的地方，比较慢

报错：查阅资料，这是10.2.0.4和10.2.0.5RAC的 EM bug：

这里可以忽略，继续建库；最后再来修复

修复过程参考：http://blog.csdn.net/dbseesee/article/details/19547621

点‘OK’ 继续

最终创建成功，CRS也注册实例，启动；

看crsd日志：

[Worker 3] [10:48:52:930][RuntimeExec.runCommand:74] Calling Runtime.exec()withthe command

[Worker 1] [10:48:52:930][RuntimeExec.runCommand:76] -f

[Worker 3] [10:48:52:930][RuntimeExec.runCommand:76] /oracle/product/10.2.0/crs_1/bin/crs_start

[Worker 3] [10:48:52:930][RuntimeExec.runCommand:76] USR_ORA_OPEN_MODE=open

[Worker 1] [10:48:52:930][RuntimeExec.runCommand:76] -c

[Worker 3] [10:48:52:930][RuntimeExec.runCommand:76] ora.dbcc.dbcc1.inst

[Worker 1] [10:48:52:930][RuntimeExec.runCommand:76] dbcc2

[Worker 3] [10:48:52:931][RuntimeExec.runCommand:76] -f

[Worker 3] [10:48:52:931][RuntimeExec.runCommand:76] -c

[Worker 3] [10:48:52:931][RuntimeExec.runCommand:76] dbcc1

[Thread-690] [10:48:52:947] [StreamReader.run:61] InStreamReader.run

[Worker 3] [10:48:52:947][RuntimeExec.runCommand:131] runCommand:Waiting forthe process

[Thread-689] [10:48:52:947][StreamReader.run:61] In StreamReader.run

[Thread-688] [10:48:52:948][StreamReader.run:61] In StreamReader.run

[Worker 1] [10:48:52:948][RuntimeExec.runCommand:131] runCommand:Waiting forthe process

[Thread-687] [10:48:52:948][StreamReader.run:61] In StreamReader.run

[Thread-689] [10:48:54:141][StreamReader.run:65] OUTPUT>Attemptingto start `ora.dbcc.dbcc1.inst` on member`dbcc1`

[Thread-687] [10:48:54:154][StreamReader.run:65] OUTPUT>Attemptingto start `ora.dbcc.dbcc2.inst` on member`dbcc2`

[root@dbcc1~]#/oracle/product/10.2.0/crs_1/bin/crs_stat-t

Name Type Target State Host

------------------------------------------------------------------------------

ora.dbcc.db application ONLINE ONLINE dbcc1

ora....c1.inst application ONLINE ONLINE dbcc1

ora....c2.inst application ONLINE ONLINE dbcc2

ora....SM1.asm application ONLINE ONLINE dbcc1

ora....C1.lsnr application ONLINE ONLINE dbcc1

ora.dbcc1.gsd application ONLINE ONLINE dbcc1

ora.dbcc1.ons application ONLINE ONLINE dbcc1

ora.dbcc1.vip application ONLINE ONLINE dbcc1

ora....SM2.asm application ONLINE ONLINE dbcc2

ora....C2.lsnr application ONLINE ONLINE dbcc2

ora.dbcc2.gsd application ONLINE ONLINE dbcc2

ora.dbcc2.ons application ONLINE ONLINE dbcc2

ora.dbcc2.vip application ONLINE ONLINE dbcc2

修复em的bug后，启动oem

改用火狐浏览器

RAC10.2.0.4 OracleLinux5.5 x64配置完成；

查看一些信息：

SQL>setlinesize200 pagesize200

SQL>select*fromv$version;

BANNER

------------------------------------------------------------

Oracle Database10gEnterpriseEdition Release10.2.0.4.0- 64bi

PL/SQL Release10.2.0.4.0- Production

CORE 10.2.0.4.0 Production

TNS forLinux:Version10.2.0.4.0- Production

NLSRTL Version10.2.0.4.0- Production

SQL>columncomp_name format a40

SQL>columnversionformat a30

SQL>columnstatus format a10

SQL> col name format a60

SQL> col member format a60

SQL> select name from v$datafile;

NAME

------------------------------------------------------------

+DATA/dbcc/datafile/system.256.840018313

+DATA/dbcc/datafile/undotbs1.258.840018315

+DATA/dbcc/datafile/sysaux.257.840018313

+DATA/dbcc/datafile/users.259.840018315

+DATA/dbcc/datafile/undotbs2.264.840018741

SQL> select name from v$controlfile;NAME------------------------------------------------------------

+DATA/dbcc/controlfile/current.260.840018585

+BACK/dbcc/controlfile/current.256.840018591

SQL> select GROUP#,BYTES,STATUS,MEMBERS from v$log;GROUP# BYTESSTATUS MEMBERS---------- ---------- --------------------- ----------

1 52428800 CURRENT 2

2 52428800 INACTIVE 2

3 52428800 CURRENT 2

4 52428800 INACTIVE 2SQL> select GROUP#,TYPE,MEMBER from v$logfile order by 1;

GROUP# TYPE MEMBER

---------- -------------- ------------------------------------------------------------

1 ONLINE +BACK/dbcc/onlinelog/group_1.257.840018611

1 ONLINE +DATA/dbcc/onlinelog/group_1.261.840018597

2 ONLINE +BACK/dbcc/onlinelog/group_2.258.840018641

2 ONLINE +DATA/dbcc/onlinelog/group_2.262.840018623

3 ONLINE +DATA/dbcc/onlinelog/group_3.265.840018775

3 ONLINE +BACK/dbcc/onlinelog/group_3.259.840018785

4 ONLINE +DATA/dbcc/onlinelog/group_4.266.840018797

4 ONLINE +BACK/dbcc/onlinelog/group_4.260.840018813

8 rows selected.