Oracle数据库识别不了存储DiskgroupORA-01078，需要Mount

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

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

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

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>