vCloud Director Install - ORA-00972 Error During Oracle Setup

Posted on in System Administration

If you are unfamiliar with Oracle and setting up your vCloud Director Oracle database, don't make the same mistake I made:

SQL> CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" SIZE 1000M AUTOEXTEND ON ;
CREATE TABLESPACE "CLOUD_DATA" DATAFILE "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" SIZE 1000M AUTOEXTEND ON
                                        *
ERROR at line 1:
ORA-00972: identifier is too long

That doesn't cut and paste very well, but the point is that "/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf" is too long. The fix is much easier than you might suspect:

Use single quotes instead of double quotes.

SQL> CREATE TABLESPACE "CLOUD_DATA" DATAFILE '/home/oracle/app/oracle/oradata/orcl/cloud_data01.dbf' SIZE 1000M AUTOEXTEND ON ;

Tablespace created.

Slaptijack's Koding Kraken