20 创建ASM磁盘组及RAC数据库
以oracle用户在图形界面下,调用dbca命令来执行:
Next:
Next:
Next:
指定SYS用户口令:oracle
PFILE:{ORACLE_BASE}/admin/+ASM/pfile/init.ora
Next:
Next:
Next:
Next:
Next:
这里可能提示找不到磁盘:在搜索路径中给出事先创建出来的ASM磁盘的绝对路径:
[root@node1 ~]# ll /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle oinstall 8, 49 Dec 21 23:02 ASMDISK1
brw-rw---- 1 oracle oinstall 8, 65 Dec 21 23:02 ASMDISK2
[root@node1 ~]#
Next:
键入磁盘组名data,外部冗余策略,选择第一块磁盘。
Next:
Next:
Next:
单击Create new 继续创建第2块磁盘:
Next:
Next:
Next:
至此,ASM磁盘组创建完毕。可以从SQL*PLUS里查看相关信息:
[root@node1 ~]# su - oracle
node1-> hostname
node1.oracleonlinux.cn
node1-> . oraenv
ORACLE_SID = [devdb1] ? +ASM1
node1-> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sun Dec 22 10:38:04 2013
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> col name for a10
SQL> select name,state,total_mb,free_mb from v$asm_disk;
NAME STATE TOTAL_MB FREE_MB
---------- ------------------------ ---------- ----------
FRA_0000 NORMAL 3067 2974
DATA_0000 NORMAL 3067 2974
SQL> select name,state,total_mb,free_mb from v$asm_diskgroup;
NAME STATE TOTAL_MB FREE_MB
---------- --------------------------------- ---------- ----------
DATA MOUNTED 3067 2974
FRA MOUNTED 3067 2974
SQL>
单击Finish!选择继续执行其它操作。
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
Next:
至此,我们完成对RAC数据库的创建!
至此,我们一步一步完成在OEL5.5 X86_64机器上安装Oracle 10gR2 RAC数据库,并将数据库升级至10.2.0.5.0版本!!!!!
如无特别说明,本站文章皆为原创,若要转载,务必请注明以下原文信息:
日志标题:《一步一步在OEL5.5 64位Linux上安装Oracle 10gR2 RAC(8-》
日志链接:http://www.oracleonlinux.cn/2013/12/step-by-step-install-10gr2rac-on-oel-8/
博客名称:OracleOnLinux