cx-oracle-users

[cx-oracle-users] Minimum client requirements for cx_Oracle

[Nik B. <Nik...@pe...>]

Hi,

Does cx_Oracle require a full Oracle client installation, or is there a more
"lightweight" option?

Currently this hasn't been an issue as our product requires the full client
anyway, but the question's been raised by one of our support people as some
customers' IT departments don't like rolling out the Oracle client to all
users.

Regards,

Nick Barron

Re: [cx-oracle-users] Minimum client requirements for cx_Oracle

[D.R. B. <da...@as...>]

Hoi Nik,

You - and your customers - can use the Oracle Instant Client.
See

   http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html

the "basic" and "sdk" parts of the OIC are sufficient for installing cx_Oracle.
You just have to change the setup.py a bit

   50c50
   <     includeDirs = ["rdbms/demo", "rdbms/public", "network/public", "sdk/include"]
   ---
   >     includeDirs = ["rdbms/demo", "rdbms/public", "network/public"]
   58c58
   <     libDirs = [oracleHome, libPath]
   ---
   >     libDirs = [libPath]


This just appends "sdk/include" to the include searchpath and prepends the value
of the ORACLE_HOME environment variable to the library searchpath.
Hmmm, Anthony, maybe something like this should go into the distributed
cx_Oracle setup.py as well.

This is as "lightweight" as you can get, apart from creating your own
cx_Oracle+Oracle libraries distribution.

Hoping that this helps,

                                                   Danny



On Fri, Oct 21, 2005 at 10:42:02AM +0100, Nik Barron wrote:
> Hi,
> 
> Does cx_Oracle require a full Oracle client installation, or is there a more
> "lightweight" option?
> 
> Currently this hasn't been an issue as our product requires the full client
> anyway, but the question's been raised by one of our support people as some
> customers' IT departments don't like rolling out the Oracle client to all
> users.
> 
> Regards,
> 
> Nick Barron
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Minimum client requirements for cx_Oracle

[Anthony T. <ant...@gm...>]

I can definitely add something like that to the setup.py that comes
with cx_Oracle. If anyone on this list has done the same thing with
Windows and Cygwin I'd like to know the changes needed for those
platforms.

On 10/21/05, D.R.   Boxhoorn <da...@as...> wrote:
>
> Hoi Nik,
>
> You - and your customers - can use the Oracle Instant Client.
> See
>
>    http://www.oracle.com/technology/tech/oci/instantclient/instantclient.=
html
>
> the "basic" and "sdk" parts of the OIC are sufficient for installing cx_O=
racle.
> You just have to change the setup.py a bit
>
>    50c50
>    <     includeDirs =3D ["rdbms/demo", "rdbms/public", "network/public",=
 "sdk/include"]
>    ---
>    >     includeDirs =3D ["rdbms/demo", "rdbms/public", "network/public"]
>    58c58
>    <     libDirs =3D [oracleHome, libPath]
>    ---
>    >     libDirs =3D [libPath]
>
>
> This just appends "sdk/include" to the include searchpath and prepends th=
e value
> of the ORACLE_HOME environment variable to the library searchpath.
> Hmmm, Anthony, maybe something like this should go into the distributed
> cx_Oracle setup.py as well.
>
> This is as "lightweight" as you can get, apart from creating your own
> cx_Oracle+Oracle libraries distribution.
>
> Hoping that this helps,
>
>                                                    Danny
>
>
>
> On Fri, Oct 21, 2005 at 10:42:02AM +0100, Nik Barron wrote:
> > Hi,
> >
> > Does cx_Oracle require a full Oracle client installation, or is there a=
 more
> > "lightweight" option?
> >
> > Currently this hasn't been an issue as our product requires the full cl=
ient
> > anyway, but the question's been raised by one of our support people as =
some
> > customers' IT departments don't like rolling out the Oracle client to a=
ll
> > users.
> >
> > Regards,
> >
> > Nick Barron
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by:
> > Power Architecture Resource Center: Free content, downloads, discussion=
s,
> > and more. http://solutions.newsforge.com/ibmarch.tmpl
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Minimum client requirements for cx_Oracle

[Mark H. <mh...@pi...>]

D.R. Boxhoorn wrote:
> Hoi Nik,
> 
> You - and your customers - can use the Oracle Instant Client.
> See
> 
>    http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
> 
> the "basic" and "sdk" parts of the OIC are sufficient for installing cx_Oracle.
> You just have to change the setup.py a bit
> 
>    50c50
>    <     includeDirs = ["rdbms/demo", "rdbms/public", "network/public", "sdk/include"]
>    ---
>    >     includeDirs = ["rdbms/demo", "rdbms/public", "network/public"]
>    58c58
>    <     libDirs = [oracleHome, libPath]
>    ---
>    >     libDirs = [libPath]
> 

We did a similar patch and it worked well.  In order to match our software distribution
environment, we repackacked the instantclient installation into the traditional
./{bin,lib/include} hierarchy.  Here's our patch:


50c50
<     includeDirs = ["rdbms/demo", "rdbms/public", "network/public", "sdk/include"]
---
 >     includeDirs = ["include"]
55c55
<     libPath = os.path.join(oracleHome, ".")
---
 >     libPath = os.path.join(oracleHome, "lib")

HTH,
Mark

-- 
Mark Harrison
Pixar Animation Studio