ORA-00905: missing keyword

How to fix ORA-00905: missing Keyword


ERROR at line 1:
ORA-00905: missing Keyword

Cause

You tried to execute a statement, but you missed a required Keyword

Resolution

Verify the Syntax correct the Errors and rerun it.

An example

QL>  create diskgroup DATA normal redundency FAILGROUP FG1 disk '/dev/oracleasm/disks/DISK5' FAILGROUP FG2 '/dev/oracleasm/disks/DISK6';

 create diskgroup DATA normal redundency FAILGROUP FG1 disk '/dev/oracleasm/disks/DISK5' FAILGROUP FG2 '/dev/oracleasm/disks/DISK6'
                              *
ERROR at line 1:
ORA-00905: missing Keyword

Findings

1> spelling mistake at keword redundency (redundancy)

2> missing Keyword disk after FG2

Corrected Version of the command executed successfully

create diskgroup DATA normal redundancy FAILGROUP FG1 disk '/dev/oracleasm/disks/DISK5' FAILGROUP FG2 disk '/dev/oracleasm/disks/DISK6';

Diskgroup created.

7 comments: