Bug 1449635 - can not activate when installed against Oracle DB backend
Summary: can not activate when installed against Oracle DB backend
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 580
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
Assignee: Michael Mráka
QA Contact: Jan Hutař
URL:
Whiteboard:
: 1449723 (view as bug list)
Depends On:
Blocks: 1400201
TreeView+ depends on / blocked
 
Reported: 2017-05-10 11:51 UTC by Jan Hutař
Modified: 2017-06-21 12:07 UTC (History)
6 users (show)

Fixed In Version: spacewalk-backend-2.5.3-140-sat
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-06-21 12:07:19 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2017-05-10 11:51:44 UTC
Description of problem:
Can not activate when installed against Oracle DB backend


Version-Release number of selected component (if applicable):
spacewalk-backend-2.5.3-123.el6sat.noarch
This was not happening 2 days ago


How reproducible:
always on 2 machines


Steps to Reproduce:
1. Install disconnected 5.8.0 with external Oracle
2. # rhn-satellite-activate --manifest /root/manifest.zip


Actual results:
# rhn-satellite-activate -v --manifest /root/manifest.zip
20:31:12 HTTP_PROXY: None
20:31:12 HTTP_PROXY_USERNAME: None
20:31:12 HTTP_PROXY_PASSWORD: <password>
 
ERROR: unhandled exception occurred:
Traceback (most recent call last):
  File "/usr/bin/rhn-satellite-activate", line 38, in <module>
    sys.exit(abs(mod.main() or 0))
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/rhn_satellite_activate.py", line 475, in main
    cdn_activate = cdn_activation.Activation(options.manifest)
  File "/usr/lib/python2.6/site-packages/spacewalk/cdn_tools/activation.py", line 36, in __init__
    rhnSQL.initDB()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 145, in initDB
    __init__DB(backend, host, port, username, password, database, sslmode, sslrootcert)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 57, in __init__DB
    __DB.connect()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 407, in connect
    self.dbh = self._connect()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 434, in _connect
    dbh = cx_Oracle.Connection(self.username, self.password, self.database)
cx_Oracle.InterfaceError: Unable to acquire Oracle environment handle


Expected results:
Should work.


Additional info:
mmraka was looking into this and we have not found what might have caused this. Also looks like once you run activation few times with pdb imported or with strace, it starts to work. This all might be just some issue with mine setup. I'll try to dig more.

Comment 1 Jan Hutař 2017-05-10 11:53:48 UTC
One thing mmraka noticed is that when it fails in strace, it tries to load library from incorrect location:

# ls /usr/lib/oracle/10.2.0.4/client64/lib/libclntsh.so.10.1/libociei.so
ls: cannot access /usr/lib/oracle/10.2.0.4/client64/lib/libclntsh.so.10.1/libociei.so: Not a directory

instead of:

# ls /usr/lib/oracle/10.2.0.4/client64/lib/libociei.so
/usr/lib/oracle/10.2.0.4/client64/lib/libociei.so

Comment 3 Tomas Lestach 2017-05-11 15:00:35 UTC
*** Bug 1449723 has been marked as a duplicate of this bug. ***

Comment 4 Tomas Lestach 2017-05-11 15:01:28 UTC
The same traceback reported twice during one day ...


Note You need to log in before you can comment on or make changes to this bug.