Discussion of the cx_Oracle Python interface to Oracle ()

Stefan Scriba | 1 Dec 2009 16:34

Oracle instant client

Hi

I apologise if the following question has been asked a million times, but I have not found an obvious answer to date:

I am trying to use cx_Oracle for Python2.6.4 with Oracle 11 in Windows XP. I was hoping that I may be able to just use the Oracle instant client (instantclient-basic-win32-11.1.0.7.0), which basically just seems to consist of a bunch of DLL files. I copied these into a subdirectory of the Python2.6 main folder. I then updated the windows path to include this subfolder and rebooted. The path is definitely now pointing correctly, but when I import the cx_Oracle library it still complains that it cannot find the correct DLL files.

So: Do I need the full Oracle client installed on each client PC running the Python code or does the MUCH smaller instant client suffice?

Regards
Stefan

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users@...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

headers

Fawcett, David (MPCA | 1 Dec 2009 16:46

Re: Oracle instant client

Stefan,

I am using cx_Oracle on XP with Python 2.5 and Oracle’s instantclient.

I am guessing that you either didn’t install them correctly, or you need to add the instantclient folder to your path environment variable.

David.

From: Stefan Scriba [mailto:scribas-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Tuesday, December 01, 2009 9:34 AM
To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: [cx-oracle-users] Oracle instant client

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users@...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

headers

Jim St.Cyr | 1 Dec 2009 18:28

Re: Oracle instant client

Stefan-

You need to add the directory to your path and set TNS_ADMIN to the same path.

Jim

Fawcett, David (MPCA) wrote:

Stefan,

I am using cx_Oracle on XP with Python 2.5 and Oracle’s instantclient.

I am guessing that you either didn’t install them correctly, or you need to add the instantclient folder to your path environment variable.

David.

From: Stefan Scriba [mailto:scribas-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Tuesday, December 01, 2009 9:34 AM
To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: [cx-oracle-users] Oracle instant client

Hi

I apologise if the following question has been asked a million times, but I have not found an obvious answer to date:

I am trying to use cx_Oracle for Python2.6.4 with Oracle 11 in Windows XP. I was hoping that I may be able to just use the Oracle instant client (instantclient-basic-win32-11.1.0.7.0), which basically just seems to consist of a bunch of DLL files. I copied these into a subdirectory of the Python2.6 main folder. I then updated the windows path to include this subfolder and rebooted. The path is definitely now pointing correctly, but when I import the cx_Oracle library it still complains that it cannot find the correct DLL files.

So: Do I need the full Oracle client installed on each client PC running the Python code or does the MUCH smaller instant client suffice?

Regards
Stefan

------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users@...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

headers

Anthony Tuininga | 1 Dec 2009 18:32

Re: Oracle instant client

Hi,

You can definitely use the instant client with cx_Oracle and it is
fairly straightforward to do so.

Modify your PATH environment variable to include the path in which the
files were extracted. This is by default something like
C:\Oracle\InstantClient11_1.

Set TNS_ADMIN environment variable to point to the location of
sqlnet.or and tnsnames.ora or you can use "easy naming" and avoid any
of that stuff.

My suggestion is to extract the SQL*Plus zip file as well and use that
to test your connection strings. If you can connect with SQL*Plus you
should be able to connect with the same connection string using
cx_Oracle.

Hope that helps.

Anthony

On Tue, Dec 1, 2009 at 8:34 AM, Stefan Scriba <scribas@...> wrote:
> Hi
>
> I apologise if the following question has been asked a million times, but I
> have not found an obvious answer to date:
>
> I am trying to use cx_Oracle for Python2.6.4 with Oracle 11 in Windows XP. I
> was hoping that I may be able to just use the Oracle instant client
> (instantclient-basic-win32-11.1.0.7.0), which basically just seems to
> consist of a bunch of DLL files. I copied these into a subdirectory of the
> Python2.6 main folder. I then updated the windows path to include this
> subfolder and rebooted. The path is definitely now pointing correctly, but
> when I import the cx_Oracle library it still complains that it cannot find
> the correct DLL files.
>
> So: Do I need the full Oracle client installed on each client PC running the
> Python code or does the MUCH smaller instant client suffice?
>
> Regards
> Stefan
>
> ------------------------------------------------------------------------------
> Join us December 9, 2009 for the Red Hat Virtual Experience,
> a free event focused on virtualization and cloud computing.
> Attend in-depth sessions from your desk. Your couch. Anywhere.
> http://p.sf.net/sfu/redhat-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users@...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

headers

Jani Tiainen | 1 Dec 2009 18:56

Re: Oracle instant client

There used to be instant client version..? At least I've used
cx_Oracle with instantclient while ago.

Have you tried to set ORACLE_HOME environment variable? It seems to
resolve usually many problems.

On 12/1/09, Stefan Scriba <scribas@...> wrote:
> Hi
>
> I apologise if the following question has been asked a million times, but I
> have not found an obvious answer to date:
>
> I am trying to use cx_Oracle for Python2.6.4 with Oracle 11 in Windows XP. I
> was hoping that I may be able to just use the Oracle instant client
> (instantclient-basic-win32-11.1.0.7.0), which basically just seems to
> consist of a bunch of DLL files. I copied these into a subdirectory of the
> Python2.6 main folder. I then updated the windows path to include this
> subfolder and rebooted. The path is definitely now pointing correctly, but
> when I import the cx_Oracle library it still complains that it cannot find
> the correct DLL files.
>
> So: Do I need the full Oracle client installed on each client PC running the
> Python code or does the MUCH smaller instant client suffice?
>
> Regards
> Stefan
>

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

headers

Stefan Scriba | 1 Dec 2009 21:27

Re: Oracle instant client

Hi

To David, Jim and Anthony - wooohooo, it's working! No more DLL complaints. Thanks for the help!

So, the problem was definitely me not setting the TNS_ADMIN variable to the correct directory. In which documentation would I have found the TNS_ADMIN mentioned, had I not short-circuited the problem and asked this mailing list?

Yet another brilliant example of how the open source community kicks ass.

Stefan

From: "Fawcett, David (MPCA)" <David.Fawcett-fCHpU6nV2zRzbRFIqnYvSA@public.gmane.org>
Subject: Re: [cx-oracle-users] Oracle instant client
Stefan,
I am using cx_Oracle on XP with Python 2.5 and Oracle's instantclient.
I am guessing that you either didn't install them correctly, or you need to add the instantclient folder to your path environment variable.
David.

From: "Jim St.Cyr" <jim.stcyr-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [cx-oracle-users] Oracle instant client
Stefan-
You need to add the directory to your path and set TNS_ADMIN to the same
path.
Jim

From: Anthony Tuininga <anthony.tuininga-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [cx-oracle-users] Oracle instant client
Hi,
You can definitely use the instant client with cx_Oracle and it is
fairly straightforward to do so.
Modify your PATH environment variable to include the path in which the
files were extracted. This is by default something like
C:\Oracle\InstantClient11_1.
Set TNS_ADMIN environment variable to point to the location of
sqlnet.or and tnsnames.ora or you can use "easy naming" and avoid any
of that stuff.
My suggestion is to extract the SQL*Plus zip file as well and use that
to test your connection strings. If you can connect with SQL*Plus you
should be able to connect with the same connection string using
cx_Oracle.
Hope that helps.
Anthony

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users@...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

headers

Anthony Tuininga | 1 Dec 2009 22:52

Re: Oracle instant client

On Tue, Dec 1, 2009 at 1:27 PM, Stefan Scriba <scribas@...> wrote:
> Hi
>
> To David, Jim and Anthony - wooohooo, it's working! No more DLL complaints.
> Thanks for the help!

You're welcome.
>
> So, the problem was definitely me not setting the TNS_ADMIN variable to the
> correct directory. In which documentation would I have found the TNS_ADMIN
> mentioned, had I not short-circuited the problem and asked this mailing
> list?

You would have to search the Oracle documentation or ask on an Oracle
mailing list since this is "basic" stuff for Oracle and not specific
to Python. I put "basic" in quotes because its necessary to even get
things up and running but its not even remotely obvious. There is a
FAQ entry for it here:

http://www.oracle.com/technology/tech/oci/instantclient/ic-faq.html#A4428

> Yet another brilliant example of how the open source community kicks ass.



Anthony

------------------------------------------------------------------------------
Join us December 9, 2009 for the Red Hat Virtual Experience,
a free event focused on virtualization and cloud computing. 
Attend in-depth sessions from your desk. Your couch. Anywhere.
http://p.sf.net/sfu/redhat-sfdev2dev