Tags

11g (3) 12c (4) 18c (2) 19c (3) ASM (3) Critical Patch (13) Dataguard (10) GRID (3) GitLab (2) Linux (11) OEM (2) ORA Errors (16) 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

Critical Patch 19c April 2026

    Oracle Critical Patch Update on 19c - April 2026 GI RU Combo: Patch 39062956 - Combo of OJVM Component Release Update 19.31.0.0.260421 +...