在路上

创建测试表空间： SQL> create tablespace test datafile '+data'; Tablespace created. SQL> alter tablespace test add datafile '+data' size 10m; Tablespace altered. 查看文件： ASMCMD> ls SYSAUX.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_DATA PROT-30: The Oracle Cluster Registry location to be added is not usable PROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes r

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

[root@rac1 bin]# ./crsctl replace votedisk +OCR_DATA CRS-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 ------------ ------------------------------ ----------- ------ -------