Tags

11g (5) 12c (6) 18c (3) 19c (4) ASM (1) Critical Patch (11) Data Pump (1) Dataguard (9) Diverse (3) GRID (7) GitLab (2) Linux (8) OEM (2) ORA Errors (13) Oracle (12) RMAN (4)

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

April Patch 19c 2025

   Oracle Critical Patch Update on 19c - January 2025 Oracle Critical Patch Update (CPU) 19.27.0.0.250415 GI RU Combo: Patch 37591516 - Comb...