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