Satellite encountering "could not find program unit being called: PUBLIC.PLITBLM" Oracle errors

Solution Verified - Updated -

Issue

  • Satellite WebUI encountering "500 Internal Server Error"
  • /var/log/tomcat5/catalina.out mentions "could not find program unit being called: PUBLIC.PLITBLM"
  • satellite-sync is failing with a similar error:
[root@satellite ~]# satellite-sync
08:44:31 Red Hat Network Satellite - live synchronization
08:44:31    url: https://satellite.rhn.redhat.com
08:44:31    debug/output level: 1
08:44:32    db:  rhnsat/<password>@//localhost:1521/rhnsat.world
08:44:32
08:44:32 Retrieving / parsing channel-families data
08:44:35 channel-families data complete
08:44:35
08:44:35 Retrieving / parsing product names data
08:44:36 product names data complete
+++ sending log as an email +++

SYNC ERROR: unhandled exception occurred:

(Check logs/email for potentially more detail)

SQLError(4068, 'ORA-04068: existing state of packages has been discarded\nORA-04065: not executed, altered or dropped stored procedure "PUBLIC.PLITBLM"\nORA-06508: PL/SQL: could not find program unit being called: "PUBLIC.PLITBLM"\nORA-06512: at "RHNSAT.RHN_ENTITLEMENTS", line 844\nORA-06512: at line 1\n')
(4068, 'ORA-04068: existing state of packages has been discarded\nORA-04065: not executed, altered or dropped stored procedure "PUBLIC.PLITBLM"\nORA-06508: PL/SQL: could not find program unit being called: "PUBLIC.PLITBLM"\nORA-06512: at "RHNSAT.RHN_ENTITLEMENTS", line 844\nORA-06512: at line 1\n')

Environment

  • Red Hat Satellite 5.2 and later

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