I was running a satellite-sync on a Red Hat Satellite Server v5.4 when I ran into an Oracle error: 'ORA-01654: unable to extend index ... in tablespace DATA_TBS'. Turns out that I needed to extend the DATA_TBS table in Oracle, which was an easy fix.
I picked up the info at http://www.redhat.com/magazine/023sep06/features/tips_tricks/?intcmp=bcm_edmsept_007
You should backup the database first but since this satellite-server is a VMWare VM I simply snapshot the server first.
First kill all satellite related processes, this also stops Oracle: #rhn-satellite stop
Once the shutdown is done restart oracle then su to the oracle user:
#service oracle start
#su - oracle
Then run a db-control report:
$db-control report
The DATA_TBS table had only 200M space so I decided to grow that to over a gig. There probably is a correct size but a short search in Red Hat docs did not make it clear. The extend command only adds about 500M at a time to the tablespace so I ran it a couple times then exited from oracle’s login:
$db-control extend DATA_TBS
$exit
After that was accomplished I restarted rhn-satellite. Since oracle was already running a Bitchin-Betty message appeared saying satellite might have crashed, this can be ignored:
#rhn-satellite start.
No comments:
Post a Comment