Oracle returns error message 'ORA-01654/ORA-01653: unable to extend index ... in tablespace DATA_TBS' on a Satellite server

Solution Verified - Updated -

Environment

  • Red Hat Satellite v.5.x

Issue

  • RHN Satellite server  giving Oracle errors - "ORA-01654: unable to extend  index DATA_TBS"

  • Unable to import channel via satellite-sync. Satellite-sync fails with following error:

    RHNSAT.RHN_PKG_CL_PID_N_TXT_TIME_UQ by 16 in tablespace DATA_TBS', 'insert into rhnPackageChangeLog (package_id, name, text, time) values (:package_id, :name, :text, :time)')

  • Satellite-sync fails with following error:

    SQLError Exception caught during import: (1653, 'ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOG by 1024 in tablespace DATA_TBS\n', 'insert into rhnPackageChangeLog (package_id, name, text, time) values (:package_id, :name, :text, :time)')

    or

    <rhnFault class (code = 54, text = 'ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOG by 8192 in tablespace DATA_TBS')>(54, 'ORA-01653: unable to extend table RHNSAT.RHNPACKAGECHANGELOG by 8192 in tablespace DATA_TBS\n', '\n     Package Upload Failed due to uniqueness constraint violation.\n     Make sure the package does not have any duplicate dependencies or\n     does not already exists on the server\n     ')

  • Error while importing a channel into satellite. Satellite-sync fails with following error:

    rhnFault: (54, 'ORA-01654: unable to extend index RHNSAT.RHN_PACKAGE_FILE_CID_PID_IDX by 1024 in tablespace DATA_TBS\n','\nPackage Upload Failed due to uniqueness constraint violation.\n
Make sure the package does not have any duplicate dependencies or\n does not already exists on the server\n     ')

  • While registering system on satellite server it fails with following error:

    SQLError: (1654, 'ORA-01654: unable to extend index RHNSAT.RHN_SNAPSHOTPKG_SID_NID_UQ by 128 in tablespace DATA_TBS\nORA-06512: at "RHNSAT.RHN_SERVER", line 231\nORA-06512: at line 1\n')

  • Satellite-sync fails with following error:

    (23, 'ORA-01654: unable to extend index RHNSAT.RHN_CNP_CNEP_IDX by 128 in tablespace DATA_TBS\nORA-06512: at "RHNSAT.RHN_CHANNEL", line 1091\nORA-06512: at line 1\n', 'Could not update database entry.')

Resolution

Root Cause

  • There is not enough space available in DATA_TBS table-space in the RH Satellite database for the update that is occurring.

Note:

The auto extend of the table-space on satellite :

1. We do not recommend auto extend because, you loses control of disk usage, also if there is maybe a bug/problem with your satellite causing unseen issues with consuming lots of DB space. The SysAdmin of the system, including disk usage is unaware of Satellite DB's growth or what is normal growth for their usage.

2. We do provide a nightly cron job to check table-space usage and email notifications are sent when you get close.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments