[soci-users] Any users of Oracle InstantClient 11g?

Discussion:

Mateusz Loskot

2013-04-03 13:05:10 UTC

Hi,

If you are a user of the InstantClient 11g on Linux,
how do you install it?

Do you simply download the .zip packages (i.e. into /opt), then

unzip instantclient-basic-linux-11.2.0.3.0.zip
unzip instantclient-sdk-linux-11.2.0.3.0.zip

getting all files unpacked into:

/opt/instantclient_11_2

That seems to be the canonical way Oracle expects users
to install the Instant Client (whatever the prefix, /opt or other).

Do you install it this way?

I use Arch Linux, so I use the package that dispatches
files in Linux-way, into /usr/include and /usr/lib.
But, I want to support the simple unzip installation method
and make FindOracle.cmake detect the client properly.

Certainly, without requirement of setting ORACLE_HOME,
as the InstantClient does not require this env variable

Best regards,

--
Mateusz Loskot, http://mateusz.loskot.net

Viacheslav Naydenov

2013-04-03 13:30:17 UTC

Permalink

Post by Mateusz Loskot
If you are a user of the InstantClient 11g on Linux,
how do you install it?
Do you simply download the .zip packages (i.e. into /opt), then
unzip instantclient-basic-linux-11.2.0.3.0.zip
unzip instantclient-sdk-linux-11.2.0.3.0.zip
/opt/instantclient_11_2

--
Best regards,
Viacheslav Naydenov.

Mateusz Loskot

2013-04-03 13:35:50 UTC

Permalink

Post by Viacheslav Naydenov

Sounds good.

My plan in greater details is this:
- repackage Oracle .zip files into zingle one or ideally, package as .deb
- expose the custom apckage from my server
- our tests run at travis-ci.org grab the custom package to install
InstantClient 11g
- tests run against Oracle 11g I host on my server

Where can I learn about how you repack .zip to .deb?
That would be really helpful, as after travis-ci.org moved to 64-bit
I no longer can use the deprecated 10g packages at oss.debian.org

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net

Viacheslav Naydenov

2013-04-03 13:52:34 UTC

Permalink

Post by Mateusz Loskot
Where can I learn about how you repack .zip to .deb?

This link may be helpful:
http://www.debian.org/doc/manuals/packaging-tutorial/packaging-tutorial.en.pdf

--
Best regards,
Viacheslav Naydenov.

Mateusz Loskot

2013-04-03 17:14:13 UTC

Permalink

I was hoping you know ready to use configuration. Sorry, I have no time or
interest in learning any packaging system, unless it's simpler than Arch's.
I'll stick to zips.
--
Mateusz Loskot, http://mateusz.loskot.net
(Sent from mobile, apology for top-posting or broken quotes)

Post by Viacheslav Naydenov

Post by Mateusz Loskot
Where can I learn about how you repack .zip to .deb?

http://www.debian.org/doc/manuals/packaging-tutorial/packaging-tutorial.en.pdf
--
Best regards,
Viacheslav Naydenov.
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
soci-users mailing list
https://lists.sourceforge.net/lists/listinfo/soci-users

Bruce Adams

2013-04-03 14:09:48 UTC

Permalink

Oracle provide several billion different downloads for reasons only they can fathom.
Some of those are RPMs. RPM is the only package format officially recognised by the Linux standards base
All linux variants are required to support it.
(http://en.wikipedia.org/wiki/Linux_Standard_Base#Choice_of_RPM_package_format)
I'd go with the RPMs where possible.
It works for 10.2, the hardest part is finding the download on Oracle's website.

________________________________
Sent: Wednesday, April 3, 2013 2:30 PM
Subject: Re: [soci-users] Any users of Oracle InstantClient 11g?

You nearly guessed, we re-pack the .zip files' contents into a .deb package
placing all the files under /opt/oracle/instantclient_11_2
Headers go to
/opt/oracle/instantclient_11_2/sdk/include/
Libraries go strait to
/opt/oracle/instantclient_11_2/
tnsnames.ora goes to
/opt/oracle/instantclient_11_2/network/admin/
--
Best regards,
Viacheslav Naydenov.
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
soci-users mailing list
https://lists.sourceforge.net/lists/listinfo/soci-users

Mateusz Loskot

2013-04-04 00:45:32 UTC

Permalink

Post by Bruce Adams
Oracle provide several billion different downloads for reasons only they can fathom.
Some of those are RPMs. RPM is the only package format officially recognised
by the Linux standards base
All linux variants are required to support it.
(http://en.wikipedia.org/wiki/Linux_Standard_Base#Choice_of_RPM_package_format)
I'd go with the RPMs where possible.
It works for 10.2, the hardest part is finding the download on Oracle's website.

I'm experimenting with custom. zip package which combines content of
instantclient-basic and instanclient-sdk and is available from my priv server.
It's ~60M, but wget pulls it onto travis-ci node within 7 seconds
and unzips into /opt/instantclient_11_2

https://github.com/SOCI/soci/blob/e1133e7/bin/ci/before_install.sh#L21-L26

I'm going to make it visible to CMake, testing it now.
This should help to bring the regular testing from Travis CI against
Oracle back.

Best regards,

--
Mateusz Loskot, http://mateusz.loskot.net

Vadim Zeitlin

2013-04-03 13:32:06 UTC

Permalink

On Wed, 3 Apr 2013 14:05:10 +0100 Mateusz Loskot <***@loskot.net> wrote:

ML> Do you simply download the .zip packages (i.e. into /opt), then
ML>
ML> unzip instantclient-basic-linux-11.2.0.3.0.zip
ML> unzip instantclient-sdk-linux-11.2.0.3.0.zip
ML>
ML> getting all files unpacked into:
ML>
ML> /opt/instantclient_11_2
ML>
ML> That seems to be the canonical way Oracle expects users
ML> to install the Instant Client (whatever the prefix, /opt or other).
ML>
ML> Do you install it this way?

Yes, this is what I did. To be honest, I have zero knowledge of Oracle so
I have no idea if it was the right thing to do but it worked for me.

ML> Certainly, without requirement of setting ORACLE_HOME,
ML> as the InstantClient does not require this env variable

I don't think it's a big problem to require setting ORACLE_HOME, provided
it's clearly documented (ideally by giving an error message if it's not set
telling what it should be set to). But I also think that I compiled SOCI
successfully without setting it but by setting ORACLE_INCLUDE and
ORACLE_LIBRARY manually. The latter was not obvious however as it must
contain several libraries (libclntsh.so, libnnz11.so and libocci.so I
believe). Again, I am far from being sure that this was the right thing to
do but it seemed to have worked... It was some time ago though (when I was
first evaluating SOCI) so I'm not sure if it still works with the current
sources.

Regards,
VZ