[Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1 database

Mon Aug 31 15:49:24 UTC 2015

Hi,

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):

1.      Update OS to latest version (CentOS 6.7 in my case) and do a reboot

2.      Download Oracle Instantclient packages in version 11.2.0.4

3.      Copy those packages to server

4.      Now point the spacewalk repo to 2.3

5.      Install the instantclient packages with yum to resolve the
dependencies

6.      Upgrade Spacewalk packages with yum upgrade

7.      stop spacewalk-services

8.      do the schema upgrade

9.      now dump the oracle database from 11.2 backend to 12.1 backend

10.   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

11.   now do a reboot again and run spacewalk-services if it isn't started
automatically

12.   Profit!

Maybe there is an easier way / other ways to accomplish this, the above is
how I solved it, just for future reference

As I wrote above, please fix the spacewalk-setup upgrade with external
database, this is wrong in
https://fedorahosted.org/spacewalk/wiki/HowToUpgrade.

Happy Upgrading and kind regards,

Daniel Souvignier

Von: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Souvignier, Daniel
Gesendet: Montag, 31. August 2015 15:35
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1
database

Hi,

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?

Regards,

Daniel

Von: spacewalk-list-bounces at redhat.com
<mailto:spacewalk-list-bounces at redhat.com>
[mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Avi Miller
Gesendet: Mittwoch, 26. August 2015 23:10
An:  <mailto:spacewalk-list at redhat.com> spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1
database

Hi,

On 26 Aug 2015, at 10:23 pm, Souvignier, Daniel
<Souvignier at itc.rwth-aachen.de <mailto:Souvignier at itc.rwth-aachen.de> >
wrote:

is there a possibility to connect Spacewalk to an Oracle 12.1 database? 

Yes, from Spacewalk 2.3 and higher, or Spacewalk 2.2 provided by Oracle.

I read in  <http://docs.oracle.com/cd/E37670_01/E64575/E64575.pdf>
http://docs.oracle.com/cd/E37670_01/E64575/E64575.pdf that it is supported,
but in   <http://spacewalk.redhat.com/yum/2.2/RHEL/6/x86_64/>
http://spacewalk.redhat.com/yum/2.2/RHEL/6/x86_64/ 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! 

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.

Cheers,

Avi

--
Oracle <http://www.oracle.com>
Avi Miller | Product Management Director | +61 (3) 8616 3496
Oracle Linux and Virtualization
417 St Kilda Road, Melbourne, Victoria 3004 Australia 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150831/086bc8a6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5804 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20150831/086bc8a6/attachment.p7s>