ORA-01501: CREATE DATABASE failed

Problem:
========

During the creation of a new database the CREATE DATABASE
command fails with the following errors:

ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 406
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool",
"unknown object","KQLS heap","KQLS MEM BLOCK")


Solution:
=========

1. Increase the shared_pool_size parameter in the init.ora file.

2. Shutdown abort your database.

3. Startup nomount your database.

4. Execute the CREATE DATABASE command again.


Explanation:
============

If your shared_pool_size is too small, the CREATE DATABASE command cannot
finish successfully.

This happens typically on small test instances when you just want to
test anything on an empty instance and do not want to waste too much
memory on a server. In this case you often edit init.ora manually
to set shared_pool_size as small as possible, and the value you use is
too small.

Another typical case where this happens is when you are upgrading an
Oracle database using full export and import. You are pre-creating an
empty database on a new version using the copy of your older init.ora
file. During the CREATE DATABASE command on a new version, you get the
errors above, because the new version needs more memory to perform all the
actions to create a database.