While upgrading database schema on Red Hat Satellite 5.7 (minor version upgrade), it failed with error "identifier 'LOCK_COUNTS' must be declared"
Issue
- While upgrading database schema on Red Hat Satellite 5.7 (minor version upgrade), it failed with below errors:
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY RHN_CHANNEL:
LINE/COL
---------------------------------------------------------------------------------
ERROR
39/9
PL/SQL: Statement ignored
39/9
PLS-00201: identifier 'LOCK_COUNTS' must be declared
declare
*
ERROR at line 1:
ORA-20001: SCHEMA POPULATION ENDS WITH INVALD OBJECTS
ORA-06512: at line 10
Environment
- Red Hat Satellite v 5.7
- External Oracle 11g Database. (Can be seen on embedded PostgreSQL database)
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.