[Spacewalk-list] Migrating from local XE instance to remote database

[Mike Hanby]

Edit the /etc/rhn/cluster.ini and replace 'xe' with 'orcl' (or whatever sid)

LocalConfig.0.dbname=orcl

Let us know if that works,

Mike

From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Coy Hile
Sent: Monday, July 19, 2010 9:08 PM
To: spacewalk-list at redhat.com
Subject: [Spacewalk-list] Migrating from local XE instance to remote database

Hi all,


I've managed to dump my data from the local XE instance to a new database (and the oracle box is listening on the relevant ports).  I'm currently running spacewalk 0.8; what do I have to change in the RHN config so that things will Just Work(tm) and point at that new database?

I've updated the following:

default_db = user/pass at SID

db_user = user
db_password = pass

hibernate.connection.username = user
hibernate.connection.password = pass

I've also updated the line

hibernate.connection.url=jdbc:oracle:thin:@oracle.server.fqdn:1521:SID

Is there something I'm missing?  I noticed that rhn-satellite start still starts the local Oracle XE Instance.

Note that tsnames.ora is configured appropriately, and sqlplus user/pass at SID logs me in successfully.

thanks in advance,

--
Coy Hile
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100720/b0a444c5/attachment.htm>