Satellite upgrade throws an error : "ORA-01653: unable to extend table xxx by 128 in tablespace DATA_TBS"

Solution Verified - Updated -

Issue

  • Upgrading From Satellite 5.4 to Satellite 5.7 exits with errors in /var/log/rhn/rhn_db_migration.log :
Running: psql -U rhnuser -d rhnschema -v ON_ERROR_STOP=ON -f -
DBD::Oracle::st execute failed: ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOGDATA by 128 in tablespace DATA_TBS (DBD ERROR: error possibly near <*> indicator at char 25 in '    insert /*+append*/ into <*>rhnPackageChangeLogData (id, name, text, time, created)              select min(id), name, text, time, min(created)          from rhnPackageChangelog                group by name, text, time') [for Statement "    insert /*+append*/ into rhnPackageChangeLogData (id, name, text, time, created)         select min(id), name, text, time, min(created)          from rhnPackageChangelog                group by name, text, time"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOGDATA by 128 in tablespace DATA_TBS (DBD ERROR: error possibly near <*> indicator at char 25 in '    insert /*+append*/ into <*>rhnPackageChangeLogData (id, name, text, time, created)              select min(id), name, text, time, min(created)          from rhnPackageChangelog                group by name, text, time') [for Statement "    insert /*+append*/ into rhnPackageChangeLogData (id, name, text, time, created)         select min(id), name, text, time, min(created)          from rhnPackageChangelog                group by name, text, time"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in '   drop table <*>rhnOrgConfiguration') [for Statement "    drop table rhnOrgConfiguration"] at /usr/bin/spacewalk-dump-schema line 442.
DBD::Oracle::st execute failed: ORA-00942: table or view does not exist (DBD ERROR: error possibly near <*> indicator at char 12 in '   drop table <*>rhnOrgConfiguration') [for Statement "    drop table rhnOrgConfiguration"] at /usr/bin/spacewalk-dump-schema line 442.
END failed--call queue aborted at /usr/bin/spacewalk-dump-schema line 442.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Oracle::db handle rhnsat at /usr/bin/spacewalk-dump-schema line 442.

  • Command db-control extend throws an error :
No such command 'extend'

Environment

  • Red Hat Satellite 5.4
  • Red Hat Enterprise Linux (RHEL6)
  • x86_64 Architecture

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.