[Spacewalk-list] Oracle 11g issues

Mark Watts m.watts at linux-corner.info
Tue Apr 19 11:02:18 UTC 2011


On Tue, 19 Apr 2011 11:18:46 +0200, Michael Mraka
<michael.mraka at redhat.com> wrote:
> Mark Watts wrote:
> % 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:
> 
> Hi Mark,
> 
> is it 'nothing works' or 'everything but osa-dispatcher works' issue?
> Are there any errors in alert_*.log or listener.log on your oracle
database
> server?

Well since the installer never completes (it never gets a page back from
the server), I guess nothing works.

https://satellite.example.com/ redirects me to
https://satellite.example.com/rhn/Login.do 

But I get a blank page and a 500 in the logs.

For reference, if I add "orcl.example.com" and "orcl" to my /etc/hosts
file (and dns) I get the following, different, error:
I'm not sure if this is a red herring though - I'm not sure I should need
this.

2011/04/19 11:48:22 +01:00 31192 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'orcl')
2011/04/19 11:48:22 +01:00 31192 0.0.0.0:
rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed',
12504, 'ORA-12504: TNS:listener was not given the SERVICE_NAME in
CONNECT_DATA\n')
2011/04/19 11:48:22 +01:00 31192 0.0.0.0: osad/jabber_lib.main('ERROR',
'Error caught:')
2011/04/19 11:48:22 +01:00 31192 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 52, in __init__DB\n    __DB.connect()\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: (12504, \'ORA-12504: TNS:listener was not given
the SERVICE_NAME in CONNECT_DATA\\n\', \'orcl\', \'Connection_Connect():
server attach\')\n')


Mark.




More information about the Spacewalk-list mailing list