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"
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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
