Oracle Database cannot identify storage DiskgroupORA-01078, need Mount

Oracle Database cannot identify storage DiskgroupORA-01078, need Mount

Oracle database does not recognize the storage Diskgroup ORA-01078 and requires 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,200 9, 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

Mount the diskgroup of the disk to be stored.

1. the user accessing asm has started 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,200 9, Oracle. All rights reserved.

Connected:

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 saved med

ORA-15260: permission denied on ASM disk group

In Oracle11g, the asm instance cannot use sys users, but sysasm users:

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>

User who switches to the database instance

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>

,