Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1449635

Summary: can not activate when installed against Oracle DB backend
Product: Red Hat Satellite 5 Reporter: Jan Hutař <jhutar>
Component: ServerAssignee: Michael Mráka <mmraka>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hutař <jhutar>
Severity: high Docs Contact:
Priority: unspecified    
Version: 580CC: dyordano, jhutar, mmraka, pstudeni, tkasparek, tlestach
Target Milestone: ---Keywords: Reopened
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-backend-2.5.3-140-sat Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-06-21 12:07:19 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1400201    

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 ...