[Spacewalk-list] Spacewalk with oracle standard edition errors

[Michael Mraka]

Matt Carey wrote:
% I'm trying to get my Spacewalk instance to work with Oracle standard edition. The install went off without a hitch and populating the channels with spacewalk-repo-sync worked properly.  I created the kickstart distributions and the profiles for the CentOS channels.  Cobbler looks like it picked up the configurations properly:
...
% I'm starting to think this is a wider issue with python scripts not being able to connect because of the following entries:
% [root at spacewalk ~]# tail -2 /var/log/rhn/osa-dispatcher.log
% 2009/10/18 22:38:44 -04:00 3172 0.0.0.0: osad/jabber_lib.main('ERROR', 'Error caught:')
% 2009/10/18 22:38:44 -04:00 3172 0.0.0.0: osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 119, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n    rhnSQL.initDB()\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB\n    __init__DB(backend, host, port, username, password, database)\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 59, in __init__DB\n    __DB.check_connection()\n  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 490, in check_connection\n    self.connect() # only allow one try\n  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 370, in connect\n    self.dbh = self._connect()\n  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 396, in _connect\n    dbh = cx_Oracle.Connection(self.dsn)\nInterfaceError: Unable to acquire Oracle environment
%  handle\n')
% 
% Does anyone have any ideas as to what the potential issue could be? Any help would be greatly appreciated.

Typically it means osa-dispatcher (maybe whole python stack) is unable to find
oracle libraries.

Check
# ldd `rpm -ql cx_Oracle | grep cx_Oracle.so`
and
# lsof -p `ps ax | awk '/[o]sa-dispatcher/ {print $1}' ` | grep oracle


% Regards,
% Matt

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat