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.