[Spacewalk-list] Pointing spacewalk at another database

[Butcher, Nathan]

Hi,

I've got another copy of my local oracle 10g database on another server, and now I want spacewalk to use this other database server (which is an Oracle 11g database)

I have edited /etc/rhn/rhn.conf from

db_backend = oracle
db_user = spacewalk
db_password = spacewalk
db_name = SPACEWLK
db_host =
db_port =

to

db_backend = oracle
db_user = spacewalk
db_password = spacewalk
db_name = SPACEWLK
db_host = new.db.host.com
db_port = 1521

However, this doesn't work. Spacewalk starts up as normal and uses it's local database as per usual.
I am clearly missing something. Spacewalk still uses the local database.

... and yes, the listener port on the other host is reachable over the network (tested with telnet)
I decided to do some testing and disabled the startup of the local Oracle database, and I get these errors in the start script:

Starting osa-dispatcher: RHN 7091 2014/03/20 16:49:45 +10:30: ('Connection attempt failed', 12541, 'ORA-12541: TNS:no listener\n')
RHN 7091 2014/03/20 16:49:45 +10:30: ('Error caught:',)
RHN 7091 2014/03/20 16:49:45 +10:30: ('Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 117, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 112, in setup_config\n    rhnSQL.initDB()\n  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", line 102, 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 55, in __init__DB\n    __DB.connect()\n  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 387, in connect\n    self.dbh = self._connect()\n  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 413, in _connect\n    dbh = cx_Oracle.Connection(self.username, self.password, self.database)\nSQLConnectError: (12541, \'ORA-12541: TNS:no listener\\n\', \'spacewalk at SPACEWLK\', \'Connection_Connect(): server attach\')\n',)

So clearly there is another step I am missing. FYI I am using spacewalk 1.9
Can somebody fill me in on what that could be?

Thanks,

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140320/073dfbf2/attachment.htm>