Tags

11g (3) 12c (4) 18c (2) 19c (3) ASM (3) Critical Patch (12) Dataguard (10) GRID (3) GitLab (2) Linux (10) OEM (2) ORA Errors (15) Oracle (20) RMAN (5)

Friday, January 24, 2020

ORA-15100: invalid or missing diskgroup name



ORA-15100: invalid or missing diskgroup name

ORA-15100:

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

SQL> alter diskgroup DATE mount;
alter diskgroup DATE mount
                *
ERROR at line 1:
ORA-15100: invalid or missing diskgroup name

SOLUTION:
Login into ASM and check the
select name,state from v$asm_diskgroup;
NAME                           STATE
------------------------------ -----------
DATE                           DISMOUNTED

Reason:
Because the diskgroup name DATE interpreted as date. This is the reason that the diskgroup with name DATE cannot start.

You need to start it manually as follow by using apostrophe.

alter diskgroup "DATE" mount;

NOTE: Always avoid to you such type of disk group Name.

No comments:

Post a Comment

SGA resize

How to resize SGA PURPOSE:   All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it i...