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

physical standby without duplicate command

physical standby without duplicate command create a physical standby database using RMAN without using duplicate command PURPOSE:   All docu...