在路上

创建测试表空间：SQL> create tablespace test datafile '+data';Tablespace created.SQL> alter tablespace test add datafile '+data' size 10m;Tablespace altered.查看文件：ASMCMD> lsSYSAUX.257.893081249

是指Grid infrastructure Home ，在单实例环境下，Grid infrastructure 有一个组件叫 Oracle Restart ,目的是为了 数据库 ASM 监听 等资源可以随操作系统启动，自动启动。或者数据库 等资源crash ，Oracle Restart可以自动把他拉起来。要用到上面的功能，可以先安装 Grid infrastructure ，再安装数据库

1.新加三块共享盘设置权限（记得两个节点都做处理）[root@rac1 ~]# raw /dev/raw/raw6 /dev/sdg/dev/raw/raw6: bound to major 8, minor 96[root@rac1 ~]# raw /dev/raw/raw7 /dev/sdh/dev/raw/raw7: bound to major 8, minor 112[ro

[root@rac2 bin]# ./ocrconfig -add +OCR_DATAPROT-30: The Oracle Cluster Registry location to be added is not usablePROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes r

1.查看OCR[root@rac1 bin]# ./ocrcheckStatus of Oracle Cluster Registry is as follows : Version : 3 Total space (kbytes) : 262120 Used space

[root@rac1 bin]# ./crsctl replace votedisk +OCR_DATACRS-4602: Failed 27 to add voting file b0df323d70a04fa9bf93b1f6611b5ac9.CRS-4602: Failed 27 to add voting file 40feea1f5e094fcabfc4f0a9b1e4c1ef.C

1.原有状态NAME FAILGROUP FAILGRO TOTAL_MB FREE_MB---------- ------------------------------ ------- ---------- ----------OCR_DATA FG2 REGULAR

11gR2数据库启动之后，发现TMP磁盘组未MOUNT：GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB USABLE_FILE_MB------------ ------------------------------ ----------- ------ -------