After upgrade to Satellite v5.5, getting errors " ORA-00942: table or view does not exist ". How do we fix it?

Solution Unverified - Updated -

Issue

  • After upgrade to Satellite v5.5, getting errors " ORA-00942: table or view does not exist ". How do we fix it?
$ /sbin/runuser oracle -c "db-control shrink-segments"
Running segment advisor to find out shrinkable segments...
WARNING: this may be a slow process.
Shrinking recomended segments...
RHNPACKAGECHANGELOG               222.8M reclaimable
DBD::Oracle::db do failed: ORA-00942: table or view does not exist (DBD ERROR: OCIStmtExecute) [for Statement "alter table "RHNSAT"."RHNPACKAGECHANGELOG" shrink space COMPACT"] at /usr/share/perl5/vendor_perl/Dobby/DB.pm line 262.
  • After upgrade to v5.5 satellite several tables were dropped but the table appears in the schema with the WinDOS tool used to query the database
  • When we browse for data using WinDOS tool, weI get an error :
   Browse data generated an error.
   ORA-00942: table or view does not exist

Environment

  • RHN Satellite v5.5 (post-upgrade)

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