数据库报错

有个召唤师 · 发表于 2014-8-14 14:54:20

SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/proddb/spfileproddb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/proddb/spfileproddb.ora
ORA-15056: additional error message
ORA-17503: ksfdopn

GOpenFile05 Failed to open file +DATA/proddb/spfileproddb.ora
ORA-17503: ksfdopn:2 Failed to open file +DATA/proddb/spfileproddb.ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-06512: at line 4

这个如何解决

有个召唤师 · 发表于 2014-8-14 14:57:46

之前只做了crsctl stop crs和crsctl start crs操作

老李 · 发表于 2014-8-15 09:47:24

查看rac中ASM的资源是否online，如果是11g，就重新启动crs；
crsctl start crs，如果10g可以用srvctl重新启动asm资源

老李 · 发表于 2014-8-15 09:48:07

然后，再查看ASM diskgroup 是否mount

HAN · 发表于 2016-3-31 12:06:06

ORA-15001: diskgroup "DATA" does not exist or is not mounted

		自动登录	找回密码
密码			立即注册