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