Upgrading to Satellite 5.6 with external Oracle DB is encountering the error "ORA-06550: line 1, column 7:\nPLS-00201: identifier 'LOGGING.CLEAR_LOG_ID' must be declared"

Solution Verified - Updated -

Issue

  • Upgrading our 5.5 Satellite with an external Oracle DB to 5.6.
  • This step worked fine:
./install.pl --upgrade --external-oracle --disconnected
  • But trying to activate the Satellite (with rhn-satellite-activate) to get access the 5.6 software channel on RHN is encountering this error:
ERROR: unhandled exception occurred:
Traceback (most recent call last):
  File "/usr/bin/rhn-satellite-activate", line 42, in <module>
    sys.exit(abs(mod.main() or 0))
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/rhn_satellite_activate.py", line 580, in main
    rhnSQL.clear_log_id()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 202, in clear_log_id
    clear_log_id()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 292, in __call__
    retval = self._call_proc(args)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 326, in _call_proc
    return self._call_proc_ret(args, ret_type=None)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 341, in _call_proc_ret
    return self.cursor.callproc(self.name, args)
spacewalk.server.rhnSQL.sql_base.SQLError: (6550, "ORA-06550: line 1, column 7:\nPLS-00201: identifier 'LOGGING.CLEAR_LOG_ID' must be declared\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored\n")

Environment

  • Upgrading Red Hat Satellite to version 5.6
  • External Oracle database

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