<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style></style></head><body lang=DE link=blue vlink=purple><div class=WordSection1>Hi,<o:p></o:p><o:p> </o:p>just wanted to report that everything went smoothly as it should. What I did was the following (mind the order of steps before doing the same):<o:p></o:p><o:p> </o:p><![if !supportLists]>1. <![endif]>Update OS to latest version (CentOS 6.7 in my case) and do a reboot<o:p></o:p><![if !supportLists]>2. <![endif]>Download Oracle Instantclient packages in version 11.2.0.4<o:p></o:p><![if !supportLists]>3. <![endif]>Copy those packages to server<o:p></o:p><![if !supportLists]>4. <![endif]>Now point the spacewalk repo to 2.3<o:p></o:p><![if !supportLists]>5. <![endif]>Install the instantclient packages with yum to resolve the dependencies<o:p></o:p><![if !supportLists]>6. <![endif]>Upgrade Spacewalk packages with yum upgrade<o:p></o:p><![if !supportLists]>7. <![endif]>stop spacewalk-services<o:p></o:p><![if !supportLists]>8. <![endif]>do the schema upgrade<o:p></o:p><![if !supportLists]>9. <![endif]>now dump the oracle database from 11.2 backend to 12.1 backend<o:p></o:p><![if !supportLists]>10. <![endif]>run spacewalk-setup --disconnected --external-oracle --upgrade (mind --external-oracle, before it was --external-database=oracle; this has to be changed in upgrading notes on spacewalk homepage) and put in new connection data<o:p></o:p><![if !supportLists]>11. <![endif]>now do a reboot again and run spacewalk-services if it isn’t started automatically<o:p></o:p><![if !supportLists]>12. <![endif]>Profit!<o:p></o:p><o:p> </o:p>Maybe there is an easier way / other ways to accomplish this, the above is how I solved it, just for future reference<o:p></o:p>As I wrote above, please fix the spacewalk-setup upgrade with external database, this is wrong in <a href="https://fedorahosted.org/spacewalk/wiki/HowToUpgrade">https://fedorahosted.org/spacewalk/wiki/HowToUpgrade</a>.<o:p></o:p><o:p> </o:p>Happy Upgrading and kind regards,<o:p></o:p>Daniel Souvignier<o:p></o:p><o:p> </o:p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'>Von: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] Im Auftrag von Souvignier, Daniel Gesendet: Montag, 31. August 2015 15:35 An: spacewalk-list@redhat.com Betreff: Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1 database<o:p></o:p></div></div><o:p> </o:p>Hi,<o:p></o:p><o:p> </o:p>thanks for your answer, I’ll try that as soon as possible and report back if it worked. To connect to an upgraded database with just new connection data, I run spacewalk-setup again with skip populate database setting, right?<o:p></o:p><o:p> </o:p>Regards,<o:p></o:p>Daniel<o:p></o:p><o:p> </o:p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'>Von: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] Im Auftrag von Avi Miller Gesendet: Mittwoch, 26. August 2015 23:10 An: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Betreff: Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1 database<o:p></o:p></div></div><o:p> </o:p>Hi,<o:p></o:p><div><o:p> </o:p><div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div>On 26 Aug 2015, at 10:23 pm, Souvignier, Daniel <<a href="mailto:Souvignier@itc.rwth-aachen.de">Souvignier@itc.rwth-aachen.de</a>> wrote:<o:p></o:p></div><o:p> </o:p><div><div>is there a possibility to connect Spacewalk to an Oracle 12.1 database? <o:p></o:p></div></div></blockquote><div><o:p> </o:p></div><div>Yes, from Spacewalk 2.3 and higher, or Spacewalk 2.2 provided by Oracle.<o:p></o:p></div><o:p> </o:p><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div>I read in <a href="http://docs.oracle.com/cd/E37670_01/E64575/E64575.pdf">http://docs.oracle.com/cd/E37670_01/E64575/E64575.pdf</a> that it is supported, but in <a href="http://spacewalk.redhat.com/yum/2.2/RHEL/6/x86_64/">http://spacewalk.redhat.com/yum/2.2/RHEL/6/x86_64/</a> the packages for 12.1 are missing (like oracle-lib-compat and others). Our dbas want to upgrade all our databases to 12.1, so it would be great if we could upgrade the Spacewalk DB as well. Thanks! <o:p></o:p></div></blockquote><o:p> </o:p></div><div>We haven't (yet) upgraded the Instant Client requirements, but the 11.2.0.4 Instant Client is 100% certified with 12c database. You continue to use the existing oracle-instantclient-11.2.0.4 RPMs on the Spacewalk server but you can switch to a 12c database on the backend.<o:p></o:p></div><div><o:p> </o:p></div><div>Cheers,<o:p></o:p></div><div>Avi<o:p></o:p></div><div><o:p> </o:p></div><div>-- Oracle <<a href="http://www.oracle.com">http://www.oracle.com</a>> Avi Miller | Product Management Director | +61 (3) 8616 3496 Oracle Linux and Virtualization 417 St Kilda Road, Melbourne, Victoria 3004 Australia <o:p></o:p></div><o:p> </o:p></div></div></body></html>