[Spacewalk-list] Oracle 11g issues

[Mark Watts]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


I'm currently trying to install Spacewalk 1.3 with Oracle 11g ("Standard
Edition One").

I've followed these guides:

https://fedorahosted.org/spacewalk/wiki/HowToInstall
https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
http://flakrat.blogspot.com/2010/04/migrate-red-hat-spacewalk-server-from.html

The latter guide being where I got my Oracle installation settings from.

I can install Oracle OK.
I can run "spacewalk-setup --disconnected", and it will happily populate
the "orcl" database for me.

My problems begin when the installer tries to restart osa-dispatcher,
which fails to start with the following:


2011/04/19 01:09:51 +01:00 31538 0.0.0.0:
rhnSQL/driver_cx_Oracle.check_connection('ERROR', "DATABASE CONNECTION
TO 'orcl' LOST", "Exception information: 'NoneType' object has no
attribute 'cursor'")
2011/04/19 01:09:51 +01:00 31538 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'orcl')
2011/04/19 01:09:51 +01:00 31538 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed',
12154, 'ORA-12154: TNS:could not resolve the connect identifier
specified\n')
2011/04/19 01:09:51 +01:00 31538 0.0.0.0: osad/jabber_lib.main('ERROR',
'Error caught:')
2011/04/19 01:09:51 +01:00 31538 0.0.0.0: osad/jabber_lib.main('ERROR',
'Traceback (most recent call last):\n  File
"/usr/share/rhn/osad/jabber_lib.py", line 118, in main\n
self.setup_config(config)\n  File
"/usr/share/rhn/osad/osa_dispatcher.py", line 80, in setup_config\n
rhnSQL.initDB()\n  File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 121, in initDB\n    __init__DB(backend, host, port, username,
password, database)\n  File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py",
line 59, in __init__DB\n    __DB.check_connection()\n  File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 489, in check_connection\n    self.connect() # only allow one try\n
 File
"/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 385, in connect\n    raise apply(sql_base.SQLConnectError,
err_args)\nSQLConnectError: (12154, \'ORA-12154: TNS:could not resolve
the connect identifier specified\\n\', \'orcl\', \'Connection_Connect():
server attach\')\n')


I'm not really sure why its failing; my hostname (spacewalk.example.com)
is in /etc/hosts and I've also got a local DNS server which is
pretending to be authoritative for example.com.

Connecting on the commandline as my spacewalk user works just fine
though, so I'm stumped:

[root at spacewalk ~]# sqlplus spacewalk/spacewalk at orcl

SQL*Plus: Release 11.2.0.1.0 Production on Tue Apr 19 01:11:59 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL>


Can anyone offer any advice?

Regards,

Mark.

- -- 
Mark Watts, BSc RHCE
http://www.linux-corner.info/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJNrNO3AAoJEA67+nBFe32mf3kH/iJwwb/nR5dDi+JV5/QHd6jn
UdNR6DljQedkJA4auHCFPj6tWZ+4AMVTnsYGeyNbFfD1gtbTgicmcvlZoMij94DW
zm4p0PslqpzGweH5H6Qlz4Nf4+ZGLKeoqS/xHTEWBrbIUE7gT7D/kdbSu6dja2O9
3DW+5wjVg52TQcbgfm7m3s3AuYLSDdSqft4U4U3T8QCtqLmzOAO2UitO76JhsPMK
wirkJL2YPgi0uRV9F9A/xeq0gvfVnsnp+Cgw+u2vunuCkBHnKSW+bw0mRUPF5CfD
6fngU1DoZfjqXgYkKvok7i/Hqi5/WGPFP9UEXNQt6QmmC8euWfW8IVkyCxZvAqU=
=Dscx
-----END PGP SIGNATURE-----