ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 8.1 Oracle数据库识别不了存储Diskgroup ORA-01078,需要Mount

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

原创 Linux操作系统 作者:mengzhaoliang 时间:2011-12-01 10:57:02 0 删除 编辑

HOST-> sqlplus "/as sysdba"

 

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:13:58 2011

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

Connected to an idle instance.

 

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:

 

HOST-> sqlplus "/as sysdba"

 

SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 1 10:32:27 2011

 

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

 

SQL> select * from v$instance;

 

 

SQL> select name,state from v$asm_diskgroup;

 

NAME                           STATE

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

GRIDDG                         MOUNTED

DATADG                         DISMOUNTED

ARCHDG                         DISMOUNTED

 

 

SQL> alter diskgroup archdg mount;

alter diskgroup archdg mount

*

ERROR at line 1:

ORA-15032: not all alterations performed

ORA-15260: permission denied on ASM disk group

 

Oracle11gasm实例不能使用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

 

SQL> alter diskgroup datadg mount;

 

Diskgroup altered.

 

SQL> select name,state from v$asm_diskgroup;

 

NAME                           STATE

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

GRIDDG                         MOUNTED

DATADG                         MOUNTED

ARCHDG                         MOUNTED

 

SQL>

 

 

切换到数据库实例的用户

su - oraoms

 

 

sqlplus "/as sysdba"

SQL> startup

ORACLE instance started.

 

Total System Global Area 4.7835E+10 bytes

Fixed Size                  2180736 bytes

Variable Size            4.3889E+10 bytes

Database Buffers         3892314112 bytes

Redo Buffers               51732480 bytes

Database mounted.

Database opened.

SQL>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12778571/viewspace-712526/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-14452:问题处理
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2008-01-30

  • 博文量
    335
  • 访问量
    2901307