Error running "db-control gather-stats" when upgrading from RHN Satellite version 5.3 to 5.4
Issue
-
When upgrading from Satellite 5.3 to Satellite 5.4, the instructions ask you to run "db-control gather-stats" as the Oracle user. It is likely that you will see this message:
user@machine ~ $ sudo -u oracle db-control gather-stats Gathering statistics... WARNING: this may be a very slow process. DBD::Oracle::db do failed: ORA-12801: error signaled in parallel query server P002 ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS ORA-06512: at "SYS.DBMS_STATS", line 13591 ORA-06512: at "SYS.DBMS_STATS", line 13937 ORA-06512: at "SYS.DBMS_STATS", line 14015 ORA-06512: at "SYS.DBMS_STATS", line 13974 ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) [for Statement "begin dbms_stats.gather_schema_stats(NULL, ESTIMATE_PERCENT=> 15, DEGREE=>DBMS_STATS.DEFAULT_DEGREE, CASCADE=>TRUE); end;"] at /usr/lib/perl5/vendor_perl/5.8.8/Dobby/DB.pm line 194.
Environment
- Red Hat Enterprise Linux 5.5
- Red Hat Network Satellite 5.3, being upgraded to 5.4
- x86_64 Architecture
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
