徐长亮的专栏

***************************************************************************** 请阅读原文： blog.youkuaiyun.com/clark_xu  ***** 欢迎关注微信公众号：clark_blog*********************************************************

第三步，查看需要删除的disk的路径select name,total_mb/1024,free_mb/1024,path from v$asm_disk;DGDATA_0003 556 1347.5625 /dev/raw/raw9第四步，查看需要删除的disk的使用情况：select name,total_mb/1024,free_mb/1024 from v$asm_disk_statDGDATA_0003 1556 1347.5625第五步，查看

3.       删除启动项：rm  -rf /etc/oracle/* 5. 删除四个文件：rm -rf /tmp/.oracle/rm -rf /var/tmp/.oracle/rm -rf /usr/tmp/.oracle/rm -rf /var/opt/oracle/6. 删除orc.loc ： rm –rf /etc/oracle/orc.loc7. 在Universal Installer删除 crs产品。8. 删

1删除ocr盘，vote盘,数据盘（1）备份数据库之后，停止数据库，使用dbca删除数据库（2）移除diskgroup  进入节点2：export ORACLE_SID=+ASM2                             sqlplus/ as sysdba             Alter diskgroup dgdata dismount;

rac需要至少需要四个日志组，分配到每个线程上各两组，两个线程的日志组不共享。一、查看各个节点的线程分配：节点一SQL> show parameters threadNAME TYPE VALUE----------------------------------------------- ------------------------------parallel_threads_per_cpu

Root.sh的原理1.      In root.sh script, it will addCRS related entry in /etc/inittab,2.      Root.sh运行/oracle/product/crs/install/rootinstall/oracle/product/crs/install/rootconfig3.      Rootin

删除crsOracle CRS stack is already configured and will berunning under init(1M)Failure at final check of Oracle CRS stack.crsctlcheck crs Failure 1 contacting CSS daemon Cannot communicate with CRS Cannotcommunicate with EVMPROT-1: Failed to initialize o

#hangcheck模块echo "options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180" >> /etc/modprobe.confecho "/sbin/modprobe hangcheck-timer">> /etc/rc.local #配置VNC vi /root/.vnc/xstartup #!/bin/sh# Uncomment the following two lines for normal deskt

修改主机名之后，无法启动数据库[oracle@k1-1-os2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Fri Feb 21 05:14:32 2014Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to

启动数据库，默认启动到open状态[root@raw1 bin]# ./srvctl start database -draw2）指定启动状态[root@raw1 bin]# ./srvctl start database -draw -i raw1 -o mount[root@raw1 bin]# ./srvctl start database -draw -i raw1 -o nomount3）关闭对象，并指定关闭方式[root@raw1 bin]# ./srvctl stop

[oracle@host1 ~]$ srvctl start nodeapps -n host2CRS-1028: Dependency analysis failed because of:CRS-0223: Resource 'ora.host2.gsd' has placement error.出现placement error这个问题的原因，主要是资源占用，也就是说两个实例资源出现在同一个节点上，导致另外一个节点得不到需要得资源

因为crs_start属于应用层的指令，启动crs的时候会失败[oracle@host1 ~]$ crs_start  -allCRS-0184: Cannot communicate with the CRS daemon.[oracle@host1 ~]$ crs_stat -tCRS-0184: Cannot communicate with the CRS daemon.

1.关机顺序（1）关闭集群oememctl stop dbconsole -cluster（2）关闭数据库实例srvctl stop instance -d EDWPRD -i EDWPRD1srvctl stop instance -d EDWPRD -i EDWPRD2或者直接：srvctl stop database -d EDWPRD（3）关闭asm实例srvctl stop asm -n host1srvctl stop asm -n host2（4）关