bay——RAC_ASM ORA-15001 diskgroup DATA does not exist or is not mounted.docx

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

Oracle数据库识别不了存储Diskgroup ORA-01078,需要Mount

问题:

HOST-> sqlplus "/as sysdba"

SQL> startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATADG/xcoms/spfilexcoms.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.ora

ORA-15056: additional error message

ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +DATADG/xcoms/spfilexcoms.or

a

ORA-17503: ksfdopn:2 Failed to open file +DATADG/xcoms/spfilexcoms.ora

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

ORA-06512: at line 4

SQL> exit

需要把存储的磁盘diskgroup组mount进来。

1、进入到asm的用户,asm已经启动

HOST-> su - grid

Password:

SQL> select * from v$instance;

SQL> select name,state from v$asm_diskgroup;

NAME                          STATE

------------------------------ -----------

GRIDDG                        MOUNTED

DATADG                        DISMOUNTED

ARCHDG                        DISMOUNTED

解决:

Oracle11g中asm实例不能使用sys用户,使用sysasm用户:

SQL> conn /as sysasm

Connected.

SQL> alter diskgroup archdg mount;

Diskgroup altered.

SQL> select name,state from v$asm_diskgroup;

NAME                          STATE

------------------------------ -----------

GRIDDG                        MOUNTED

DATADG                        DISMOUNTED

ARCHDG                        MOUNTED

切换到数据库实例的用户

sqlplus "/as sysdba"

SQL> startup

 

上一篇:採用Android中的httpclient框架发送post请求


下一篇:ELK + Filebeat 日志分析系统