Re: [Spacewalk-list] Oracle 12/ 18 Database Support
Hey Richard, > On 20 May 2019, at 8:36 pm, Richard wrote: > > As we'd discussed on this thread that Oracle 18 should work, I modified the > /usr/share/perl5/vendor_perl/Spacewalk file and adjusted the > allowed_db_versions list to make it read: Yes, that’s one of the changes we’d make upstream once our testing has completed and our 2.9 build is published. We’re waiting for the general availability of Oracle Linux 8 before releasing our next version of Spacewalk, so some of this has been postponed until that’s completed. Cheers, Avi -- Avi Miller | Senior Manager | +61 (03) 8616-3496 Oracle Linux and VM Product Management 417 St Kilda Road, Melbourne VIC 3004 Australia ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Oracle 12/ 18 Database Support
On Thursday, May 2, 2019, 8:53:16 PM GMT+1, Avi Miller wrote: Hey Richard, > On 2 May 2019, at 7:01 pm, Richard wrote: > > My DBA tells me we are running in Oracle 11.2.0 compatibility mode (Database > Upgrade Guide). Is there any reason we should not move to Oracle 18.6.0 > compatibility ? None that I can think of. Our plan is to complete testing of Spacewalk 2.9 with the latest Oracle Instant Client 18c (which is available from yum.oracle.com with no click-through license any more[1]) and then push the spec file changes to shift to this client upstream. The updated Instant Client will work with all DB versions from 11gR2 all the way up to 19c. However, I don’t have an ETA on the completion of this testing yet. Our suite has to run across three database versions with the server on two major versions of the distro and two architectures for one of those versions, so it can take weeks to complete. :) Thanks, Avi [1] http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/index.html --- Hi Avi, By way of an update in case this is useful for you or anyone else. We were running Spacewalk 2.8 with Oracle 18.0.0. We upgraded to Spacewalk 2.9. The following error was generated when upgrading the database: # spacewalk-setup --external-oracle --upgrade* Setting up Oracle environment.* Setting up database.** Database: Setting up database connection for Oracle backend.Global Database Name or SID (requires tnsnames.ora)? X Username? X Password?Could not connect to the database. Your connection information may be incorrect. Error: Version [18.0.0] is not supported (does not match 12.2.0, 12.1.0, 11.2.0, 11.1.0, 10.2.0). As we'd discussed on this thread that Oracle 18 should work, I modified the /usr/share/perl5/vendor_perl/Spacewalk file and adjusted the allowed_db_versions list to make it read: my @allowed_db_versions = qw/18.0.0 12.2.0 12.1.0 11.2.0 11.1.0 10.2.0/; This allowed the installer to complete successfully and Spacewalk seems to be performing correctly. Richard. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Oracle 12/ 18 Database Support
Hey Richard, > On 2 May 2019, at 7:01 pm, Richard wrote: > > My DBA tells me we are running in Oracle 11.2.0 compatibility mode (Database > Upgrade Guide). Is there any reason we should not move to Oracle 18.6.0 > compatibility ? None that I can think of. Our plan is to complete testing of Spacewalk 2.9 with the latest Oracle Instant Client 18c (which is available from yum.oracle.com with no click-through license any more[1]) and then push the spec file changes to shift to this client upstream. The updated Instant Client will work with all DB versions from 11gR2 all the way up to 19c. However, I don’t have an ETA on the completion of this testing yet. Our suite has to run across three database versions with the server on two major versions of the distro and two architectures for one of those versions, so it can take weeks to complete. :) Thanks, Avi [1] http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/index.html -- Avi Miller | Senior Manager | +61 (03) 8616-3496 Oracle Linux and VM Product Management 417 St Kilda Road, Melbourne VIC 3004 Australia ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Oracle 12/ 18 Database Support
Hi Avi, On Wednesday, April 24, 2019, 9:46:47 PM GMT+1, Avi Miller wrote: > Spacewalk works fine with Oracle Database 11, 12, 18 and 19. Our upcoming > release of Spacewalk 2.9 is planned to be rebased (for want of a better word) > to the Oracle 18c Instant Client as well. > In the interim, the 11gR2 Instant Client that is required by the upstream > Spacewalk RPMs will connect just fine to newer database versions. > Let me know if you have any issues. Just a quick update in case this is of use. This morning we upgraded our database from 11.2.0.4 to Oracle 18.0.6. We continue to run Spacewalk 2.8, but will upgrade to Spacewalk 2.9 shortly. We had ORACLE_HOME defined in a couple of places which needed adjusting to point to the new Oracle release location: /root/.bash_profile /etc/sysconfig/osa-dispatcher /etc/rhn/cluster.ini After correcting these entries, Spacewalk started successfully. My DBA tells me we are running in Oracle 11.2.0 compatibility mode (Database Upgrade Guide). Is there any reason we should not move to Oracle 18.6.0 compatibility ? Richard. | | | | Database Upgrade Guide If new features are incompatible with your earlier release, then Database compatibility can cause issues. | | | ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
Re: [Spacewalk-list] Oracle 12/ 18 Database Support
Hi, > On 24 Apr 2019, at 6:22 pm, Richard wrote: > > Is anyone running Spacewalk using any of the above database versions? Spacewalk works fine with Oracle Database 11, 12, 18 and 19. Our upcoming release of Spacewalk 2.9 is planned to be rebased (for want of a better word) to the Oracle 18c Instant Client as well. In the interim, the 11gR2 Instant Client that is required by the upstream Spacewalk RPMs will connect just fine to newer database versions. Let me know if you have any issues. Thanks, Avi -- Avi Miller | Senior Manager | +61 (03) 8616-3496 Oracle Linux and VM Product Management 417 St Kilda Road, Melbourne VIC 3004 Australia ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
[Spacewalk-list] Oracle 12/ 18 Database Support
Hi there, We are currently running Spacewalk 2.8 with Oracle 11.2.0.4 We plan to upgrade to Spacewalk 2.9 shortly, but before we do we're considering updating Oracle to one of the following: 12.1.0.2 12.2.0.218 I found an old posting at Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1 database where someone had success with Oracle 12.1 and I think the Oracle 11 Instant Client 11.2.0.4.0 is compatible with version 18. | | | | Re: [Spacewalk-list] Connect Spacewalk (2.2) to Oracle 12.1 database | | | Is anyone running Spacewalk using any of the above database versions? Richard. ___ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list