spacewalk:ORA-01654: Unable to Extend Index SW_USER.RHN_PKG_CAP_NAME_VERSION_UQ by 32 in Tablespace USERS

(Doc ID 2333078.1)

Last updated on DECEMBER 04, 2017

Applies to:

Linux OS - Version Oracle Linux 7.4 with Unbreakable Enterprise Kerne [4.1.12] and later
Linux x86-64

Goal

While syncing the channels we are getting errors on database

# /usr/bin/spacewalk-repo-sync --channel oraclelinux7-x86_64 --type uln --latest
10:16:46 ======================================
10:16:46 | Channel: oraclelinux7-x86_64
10:16:46 ======================================
10:16:46 Sync of channel started.
10:16:46 Repo URL: uln:///ol7_x86_64_latest
The download URL is: https://linux-update.oracle.com/XMLRPC/GET-REQ/ol7_x86_64_latest
10:17:02 Packages in repo: 22843
10:17:05 Packages already synced: 0
10:17:05 Packages to sync: 5220

--snip

10:17:05 59/5220 : PyQt4-devel-4.10.1-13.el7-0.i686
10:17:26 (1654, 'ORA-01654: unable to extend index SW_USER.RHN_PKG_CAP_NAME_VERSION_UQ by 32 in tablespace USERS\nORA-06512: at "SW_USER.INSERT_PACKAGE_CAPABILITY", line 7\nORA-06512: at "SW_USER.LOOKUP_PACKAGE_CAPABILITY", line 23\nORA-01403: no data found\nORA-06512: at line 1\n', 'select lookup_package_capability(:name, :version) as id from dual')


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms