[Spacewalk-list] Change from Oracle XE to 11gR2

[Mike Hanby]

I finally got around to migrating from Oracle XE to Oracle 11gR2. The operation was a success. Along the way I got to familiarize myself with Oracle again, I hadn't done much with Oracle since 2000.

Here are my notes in case they help others on the list:
http://flakrat.blogspot.com/2010/04/migrate-red-hat-spacewalk-server-from.html

Mike

-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Santi Saez
Sent: Thursday, March 25, 2010 11:19 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Change from Oracle XE to 11gR2

El 23/03/10 9:42, Michael Mraka escribió:

> % I have a Spacewalk 0.7 server that has just hit the 4GB Oracle XE barrier. We have a license for Oracle 11gR2 that I can use for this server.
> %
> % Is it possible to do a migration? Something like stop Spacewalk, dump the database in XE, Uninstall XE, Install 11gR2 and import, start Spacewalk?

> http://www.mail-archive.com/spacewalk-list@redhat.com/msg03837.html

Hi! I started this thread a month ago to migrate XE to Oracle SE1.

I have changed /etc/tnsnames.ora to point to the new Oracle server IP 
and we get this traceback:

	http://pastebin.com/vxswfvsL

Also I tried changing "db_host" in /etc/rhn/rhn.conf, but I get same error.

Using sqlplus I connect without problems to the new Oracle server.

When we try to logging into Spacewalk web interface (rhn/Login.do) we 
get this traceback error:

	http://pastebin.com/U0ZpkzQR

What can I do to solve this? thanks!

Regards,

-- 
Santi Saez
http://woop.es

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list