[Spacewalk-list] SpaceWalk 2.8 Install Error

[philippe bidault]

Hi,

Not sure if this is relevant, but on the Spacewalk 2.8 installation
instructions, there are references about Oracle 10g and 11g, but nothing
about Oracle 12 :

https://github.com/spacewalkproject/spacewalk/wiki/HowToInstall28

In order to get Spacewalk to run with Oracle database backend, you need:

   - Instant Client 11.2.0.4.0 installed on the Spacewalk machine
   - Oracle database server, either on the Spacewalk machine or on another
   host; versions 10g and 11g are known to work


Regards,
Phlilippe.

On Wed, 5 Dec 2018 at 14:38, Bruce Wainer <bruce at brucewainer.com> wrote:

> I don’t have any specific experience with using an Oracle backend for
> spacewalk (although I was an Oracle 9i certified database administrator)
> but have you verified using some other program that the database can be
> reached from this server? I’m just wondering if the Spacewalk setup is
> giving you an error about the tablespace when in reality it might have
> failed to connect, or the user you supplied does not have the proper
> permissions.
>
> Hope this helps,
> Bruce Wainer
>
> > On Dec 5, 2018, at 8:24 AM, Worner, Frank <F.Worner at exeter.ac.uk> wrote:
> >
> > Hi Michael
> >
> > Thanks for the swift reply, but unfortunately there was an omission in
> my typing ... I should have said;
> >
> > "We have confirmed that the tableSPACE SWALK_DATA does indeed exist"
> >
> > Sorry, my mistake - but the original issue still exists - any other
> suggestion, anyone ??
> >
> > Regards
> >
> > Frank
> >
> > -----Original Message-----
> > From: spacewalk-list-bounces at redhat.com <
> spacewalk-list-bounces at redhat.com> On Behalf Of Michael Mraka
> > Sent: 05 December 2018 12:38
> > To: spacewalk-list at redhat.com
> > Subject: Re: [Spacewalk-list] SpaceWalk 2.8 Install Error
> >
> > Worner, Frank:
> >>
> >> Hi All - I wonder if anyone can shed light on the following error ??
> >>
> >> # spacewalk-setup --external-oracle
> >> * Setting up SELinux..
> >> * Setting up Oracle environment.
> >> * Setting up database.
> >> ** Database: Setting up database connection for Oracle backend.
> >> Global Database Name or SID (requires tnsnames.ora)? ABCD
> >> Username? WXYZ
> >> Password?
> >> ** Database: Testing database connection.
> >> Tablespace 'SWALK_DATA' does not appear to exist.
> >  ^^^^^^^^^^
> >> Use of uninitialized value in string ne at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1528, <STDIN> line 3.
> >> Use of uninitialized value $_[2] in sprintf at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 162, <STDIN> line 3.
> >> Use of uninitialized value in string ne at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1528, <STDIN> line 3.
> >> Use of uninitialized value $_[2] in sprintf at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 162, <STDIN> line 3.
> >> Use of uninitialized value in string ne at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 1528, <STDIN> line 3.
> >> Use of uninitialized value $_[2] in sprintf at
> /usr/share/perl5/vendor_perl/Spacewalk/Setup.pm line 162, <STDIN> line 3.
> >> Tablespace errors: tablespace SWALK_DATA has STATUS set to  where
> ONLINE is expected;tablespace SWALK_DATA has LOGGING set to  where LOGGING
> is expected;tablespace SWALK_DATA has CONTENTS set to  where PERMANENT is
> expected
> >>
> >> We are trying to install SpaceWalk 2.8 on a Centos7 host, connecting to
> a remote host running an Oracle 12C instance. We have confirmed that the
> table SWALK_DATA does indeed exist, so are unsure why we get the error
> stating the table doesn't exist. We are also unsure what the subsequent
> errors are complaining about too, so any help or advice would be gratefully
> received !!
> >
> > Tablespace != table. You need to create *tablespace* SWALK_DATA (a place
> > where Oracle stores tables).
> >
> >> Many Thanks
> >>
> >> Frank
> >
> >
> > Regards,
> >
> > --
> > Michael Mráka
> > System Management Engineering, Red Hat
> >
> > _______________________________________________
> > 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20181205/49923cf8/attachment.htm>