数据库常见问题解决办法.docVIP

数据库实例关闭时无法停止： 解决方法： 使用ps –ef|grep ora_pmon命令查询进程状态，将死锁的进程杀掉。 使用shutdown abort命令强制关闭数据库 数据库实例启动出现如下错误： SQL?startup? ORA-01078:?failure?in?processing?system?parameters ORA-01565:?error?in?identifying?file?+DATA/train/spfiletrain.ora ORA-17503:?ksfdopn:2?Failed?to?open?file?+DATA/train/spfiletrain.ora ORA-15077:?could?not?locate?ASM?instance?serving?a?required?diskgroup 解决方法：磁盘组加载，或者启动时出现错误 --检查ASM实例运行情况 rac2- srvctl status asm -n rac1 ASM 实例 +ASM1 正在节点 rac1 上运行。 rac2- srvctl status asm -n rac2 ASM 实例 +ASM2 不在节点 rac2 上运行。 [root@rac2 ~]# /etc/init.d/oracleasm listdisks???? 没有结果输出表示ASM磁盘组没有加载,之前配置ASM的时候已经配置了自动加载ASM,可能是因为其他原因没有加载成功.下面手工加载: [root@rac2 ~]# /etc/init.d/oracleasm enable Writing Oracle ASM library driver configuration: [ OK ] Loading module oracleasm: [ OK ] Mounting ASMlib driver filesystem: [ OK ] Scanning system for ASM disks: [ OK ] --再查看ASM磁盘组信息: [root@rac2 ~]# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 --可以看出,ASM磁盘组加载好了. --下面要做的是启动ASM实例 rac2- export ORACLE_SID=+ASM2 rac2- sqlplus /as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:36:18 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL startup ASM instance started Total System Global Areabytes Fixed Size 1217884 bytes Variable Sizebytes ASM Cachebytes ASM diskgroups mounted SQL exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters and Data Mining options --启动数据库 rac2- export ORACLE_SID=train2 rac2- sqlplus /as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 11 20:39:57 2014 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 188743680 bytes Fixed Size 1218436 bytes Variable Sizebytes Database Buffers 100663296 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. 至此,