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

[Coy Hile]

It looks good now.

As an aside, work is using satellite 5.3 with the embedded oracle option.  Will the same edits work there if I can convince the satellie admin to stuff the rhnsat DB onto one of our DBAs' clusters?

Let me ask one more question -- say I want to migrate from the oracle-instant-client for 10.2.0.4 to a full-on oracle client; what do I have to change to point it at those libraries?  I ask because I'll likely have to do that anyhow should I move from 10gR2 to 11gR2 at some point...

Thanks,

-Coy
________________________________
From: spacewalk-list-bounces at redhat.com [spacewalk-list-bounces at redhat.com] on behalf of Mike Hanby [mhanby at uab.edu]
Sent: Tuesday, July 20, 2010 09:34
To: 'spacewalk-list at redhat.com'
Subject: Re: [Spacewalk-list] Migrating from local XE instance to remote database

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/74798b47/attachment.htm>