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@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,
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
