satellite-sync throws the error ORA-03114: not connected to ORACLE

Solution Verified - Updated -

Issue

  • When running satellite-sync it throws the error ORA-03114: not connected to ORACLE
Exception Handler Information
Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 139, in main
    return satsync.Runner().main()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 229, in main
    ret = method()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 343, in _step_packages
    self._affected_channels = self.syncer.import_packages()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1602, in import_packages
    [sources])
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1576, in _proces_batch
    prompt, nevermorethan, process_function_args)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1556, in _processWithProgressBar
    process_function(chunk, *process_function_args)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1583, in _import_packages_process
    sync_handlers.import_packages(batch, sources)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 385, in import_packages
    importer.run()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 646, in run
    self.fix()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", line 292, in fix
    self.backend.rollback()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1473, in rollback
    self.dbmodule.rollback()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 186, in rollback
    return db.rollback(name)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 507, in rollback
    return self.dbh.rollback()
OperationalError: ORA-03114: not connected to ORACLE
  • Client systems registered to satellite are not getting latest updates.

From taskomatic logs we can see below error :

INFO   | jvm 1    | 2017/04/23 22:21:32 | Caused by: 
INFO   | jvm 1    | 2017/04/23 22:21:32 | java.lang.reflect.InvocationTargetException
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at java.lang.reflect.Method.invoke(Method.java:620)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   ... 7 more
INFO   | jvm 1    | 2017/04/23 22:21:32 | Caused by: 
INFO   | jvm 1    | 2017/04/23 22:21:32 | java.sql.SQLException: ORA-03114: not connected to ORACLE
INFO   | jvm 1    | 2017/04/23 22:21:32 | 
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at oracle.jdbc.driver.T2CConnection.doRollback(T2CConnection.java:489)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1189)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:273)
INFO   | jvm 1    | 2017/04/23 22:21:32 |   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:288)

Environment

  • Red Hat Satellite 5.6
  • Red Hat Satellite 5.7

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