Red Hat Knowledgebase

Note: Before extending the tablespace, ensure there is a current working backup of the database.

This problem arises if the tablespace within the Embedded Oracle database has become 100% full. Verify that it is 100% full by running the command:

su -l oracle -c 'db-control report'

NOTE: Due to a bug in db-control for earlier RHN Satellites, if the output of this command does not contain a row for DATA_TBS tablespace, then assume that the tablespace is full.

If the output of this command shows that the DATA_TBS is 100% then proceed to add more space using command below.

There is currently no supported method to automate the extension of tablespaces, however, the following command will effect the extension:

# service rhn-satellite stop
# service rhn-database start
# su - oracle
# db-control extend DATA_TBS
# exit
# service rhn-database stop
# service rhn-satellite start

Each usage of the 'extend' option to the db-control command will add another 512MB of space to the database on the tablespace specified. Re-run db-control with the report option to verify the new current space usage.