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

[Frédéric SOSSON]

thanks, it looks like useful...

On 28 April 2010 18:40, Mike Hanby <mhanby at uab.edu> wrote:
> 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
Frédéric SOSSON
Tél.: 0032 496 29 29 88