Error running "db-control gather-stats" when upgrading from RHN Satellite version 5.3 to 5.4

Solution Verified - Updated -

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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content