cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle

Re: [cx-oracle-users] cx_Oracle 4.1, Oracle 10.2 in Solaris

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

Glad to be of help. The symlink should not be an issue so it would
appear that you are running 32-bit Python and the default Oracle
install is 64-bit.

On 12/16/05, Mikel Larreategi <mla...@co...> wrote:
> Anthony Tuininga wrote:
> > You'll need to find that library. Its normally located in
> > $ORACLE_HOME/lib but if you are using the Oracle instant client that
> > can be found elsewhere. I have patches to setup.py that deal with some
> > of these issues but they are quite simple for you to make as well.
> > Locate the shared library and change the line that specifies "libDirs
> > =3D " and then run setup.py again. The alternative is to simply copy th=
e
> > command line that failed and modify it to include the -L directive.
> > Hope that helps.
>
> Well, the library is indeed at $ORACLE_HOME/lib although it's a symlink
> to libclntsh.so.10.1
>
> I've found another libclntsh.so at $ORACLE_HOME/lib32 and pointing
> libDirs to it, cx_Oracle was built correctly and after putting it in the
> LD_LIBRARY_PATH works correctly form Python.
>
> Thank you for your help
>
> --
> Mikel Larreategi
> mla...@co...
>
> CodeSyntax
> Azitaingo Industrialdea 3 K
> E-20600 Eibar
> Tel: (+34) 943 82 17 80
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] cx_Oracle 4.1, Oracle 10.2 in Solaris

[Mikel L. <mla...@co...>]

Anthony Tuininga wrote:
> You'll need to find that library. Its normally located in
> $ORACLE_HOME/lib but if you are using the Oracle instant client that
> can be found elsewhere. I have patches to setup.py that deal with some
> of these issues but they are quite simple for you to make as well.
> Locate the shared library and change the line that specifies "libDirs
> = " and then run setup.py again. The alternative is to simply copy the
> command line that failed and modify it to include the -L directive.
> Hope that helps.

Well, the library is indeed at $ORACLE_HOME/lib although it's a symlink
to libclntsh.so.10.1

I've found another libclntsh.so at $ORACLE_HOME/lib32 and pointing
libDirs to it, cx_Oracle was built correctly and after putting it in the
LD_LIBRARY_PATH works correctly form Python.

Thank you for your help

-- 
Mikel Larreategi
mla...@co...

CodeSyntax
Azitaingo Industrialdea 3 K
E-20600 Eibar
Tel: (+34) 943 82 17 80

Re: [cx-oracle-users] cx_Oracle 4.1, Oracle 10.2 in Solaris

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

You'll need to find that library. Its normally located in
$ORACLE_HOME/lib but if you are using the Oracle instant client that
can be found elsewhere. I have patches to setup.py that deal with some
of these issues but they are quite simple for you to make as well.
Locate the shared library and change the line that specifies "libDirs
=3D " and then run setup.py again. The alternative is to simply copy the
command line that failed and modify it to include the -L directive.
Hope that helps.

On 12/16/05, Mikel Larreategi <mla...@co...> wrote:
> Hi:
>
> I'm trying to build cx_Oracle 4.1 from source in a sun solaris computer
> using GCC 3.4.2 and Python 2.3.5 but I receive an error regarding
> "-lclntsh". I reproduce the error below.
>
> My environment variables look like these:
>
> bash-2.03$ uname -a
> SunOS arqfotos 5.8 Generic_117350-27 sun4u sparc SUNW,Sun-Fire-280R
>
> bash-2.03$ echo $ORACLE_HOME
> /home1/programas/oracle/oracle/product/10.2.0/db_1
>
> bash-2.03$ echo $LD_LIBRARY_PATH
> /usr/lib:/usr/local/lib:/usr/local/lib/sparcv9:/home1/programas/oracle/or=
acle/product/10.2.0/db_1/lib
>
> But when building I get this error.
>
> bash-2.03$ /home1/zope/python/235/bin/python setup.py install
> running install
> running build
> running build_ext
> building 'cx_Oracle' extension
> creating build
> creating build/temp.solaris-2.8-sun4u-2.3
> gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
> -I/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/demo
> -I/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public
> -I/home1/programas/oracle/oracle/product/10.2.0/db_1/network/public
> -I/home1/zope/python/235/include/python2.3 -c cx_Oracle.c -o
> build/temp.solaris-2.8-sun4u-2.3/cx_Oracle.o -DBUILD_TIME=3D"December 16,
> 2005 10:56:13"
> In file included from
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:265=
1,
>                  from cx_Oracle.c:9:
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci1.h:14=
8:
> warning: function declaration isn't a prototype
> In file included from
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:2=
25,
>
>                  from
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:267=
5,
>                  from cx_Oracle.c:9:
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:676=
:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:266=
7:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:267=
6:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:268=
6:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:269=
5:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:270=
4:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:271=
3:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:272=
1:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:273=
1:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:273=
8:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:274=
6:
> warning: function declaration isn't a prototype
> In file included from
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:267=
5,
>                  from cx_Oracle.c:9:
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:1=
0068:
> warning: function declaration isn't a prototype
> /home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:1=
0074:
> warning: function declaration isn't a prototype
> creating build/lib.solaris-2.8-sun4u-2.3
> gcc -shared build/temp.solaris-2.8-sun4u-2.3/cx_Oracle.o
> -L/home1/programas/oracle/oracle/product/10.2.0/db_1/lib -lclntsh -o
> build/lib.solaris-2.8-sun4u-2.3/cx_Oracle.so -s
> /usr/local/lib/gcc/sparc-sun-solaris2.8/3.4.2/../../../../sparc-sun-solar=
is2.8/bin/ld:
> skipping incompatible
> /home1/programas/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so when
> searching for -lclntsh
> /usr/local/lib/gcc/sparc-sun-solaris2.8/3.4.2/../../../../sparc-sun-solar=
is2.8/bin/ld:
> cannot find -lclntsh
> collect2: ld returned 1 exit status
> error: command 'gcc' failed with exit status 1
> bash-2.03$
>
>
> Any idea of what can happen?
>
> Thank you in advance,
>
> Mikel
>
>
> --
> Mikel Larreategi
> mla...@co...
>
> CodeSyntax
> Azitaingo Industrialdea 3 K
> E-20600 Eibar
> Tel: (+34) 943 82 17 80
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] cx_Oracle 4.1, Oracle 10.2 in Solaris

[Mikel L. <mla...@co...>]

Hi:

I'm trying to build cx_Oracle 4.1 from source in a sun solaris computer
using GCC 3.4.2 and Python 2.3.5 but I receive an error regarding
"-lclntsh". I reproduce the error below.

My environment variables look like these:

bash-2.03$ uname -a
SunOS arqfotos 5.8 Generic_117350-27 sun4u sparc SUNW,Sun-Fire-280R

bash-2.03$ echo $ORACLE_HOME
/home1/programas/oracle/oracle/product/10.2.0/db_1

bash-2.03$ echo $LD_LIBRARY_PATH
/usr/lib:/usr/local/lib:/usr/local/lib/sparcv9:/home1/programas/oracle/oracle/product/10.2.0/db_1/lib

But when building I get this error.

bash-2.03$ /home1/zope/python/235/bin/python setup.py install
running install
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.solaris-2.8-sun4u-2.3
gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
-I/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/demo
-I/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public
-I/home1/programas/oracle/oracle/product/10.2.0/db_1/network/public
-I/home1/zope/python/235/include/python2.3 -c cx_Oracle.c -o
build/temp.solaris-2.8-sun4u-2.3/cx_Oracle.o -DBUILD_TIME="December 16,
2005 10:56:13"
In file included from
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:2651,
                 from cx_Oracle.c:9:
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci1.h:148:
warning: function declaration isn't a prototype
In file included from
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:225,

                 from
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:2675,
                 from cx_Oracle.c:9:
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:676:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2667:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2676:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2686:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2695:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2704:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2713:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2721:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2731:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2738:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/nzt.h:2746:
warning: function declaration isn't a prototype
In file included from
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/oci.h:2675,
                 from cx_Oracle.c:9:
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:10068:
warning: function declaration isn't a prototype
/home1/programas/oracle/oracle/product/10.2.0/db_1/rdbms/public/ociap.h:10074:
warning: function declaration isn't a prototype
creating build/lib.solaris-2.8-sun4u-2.3
gcc -shared build/temp.solaris-2.8-sun4u-2.3/cx_Oracle.o
-L/home1/programas/oracle/oracle/product/10.2.0/db_1/lib -lclntsh -o
build/lib.solaris-2.8-sun4u-2.3/cx_Oracle.so -s
/usr/local/lib/gcc/sparc-sun-solaris2.8/3.4.2/../../../../sparc-sun-solaris2.8/bin/ld:
skipping incompatible
/home1/programas/oracle/oracle/product/10.2.0/db_1/lib/libclntsh.so when
searching for -lclntsh
/usr/local/lib/gcc/sparc-sun-solaris2.8/3.4.2/../../../../sparc-sun-solaris2.8/bin/ld:
cannot find -lclntsh
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1
bash-2.03$


Any idea of what can happen?

Thank you in advance,

Mikel


-- 
Mikel Larreategi
mla...@co...

CodeSyntax
Azitaingo Industrialdea 3 K
E-20600 Eibar
Tel: (+34) 943 82 17 80

Re: [cx-oracle-users] Re: Compiling cx_Oracle with Linux Oracle Instantclient 10.2

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

Ah yes, I downloaded the zip file to take a look inside it and the
directory structure is as you say. Trust Oracle to be consistent. :-)
I've included your patches since the additional search directories
won't harm a "normal" installation.

On 11/10/05, Nicolas Duboc <ni...@du...> wrote:
>
> [In reply to Anthony reply to my post. I'm not subscribed to the list so
> I did not receive Anthony's reply]
>
> Anthony wrote:
> > >    Hi all,
> > >
> > >  Below is a small patch I had to apply on cx_Oracle sources to make t=
hem
> > > compile on my Debian Linux testing box with the Oracle Instantclient
> > > 10.2.
> >
> >    Hmm, I certainly don't have the same directory structure as you do.
> > I've been using the RPM version and it puts the libraries in
> > /usr/lib/oracle/10.2.0.1/lib and the include files in
> > /usr/include/oracle/10.2.0.1/client. How did you install the client?
>
>   I used the .zip archives of Instantclient 10.2 and unpacked them in
> /opt.
>
>   Regards,
>
> --
> Nicolas Duboc <ni...@du...>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] Symbol reference error: OCIHandleFree - REPOST

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

There should be a symbolic link libclntsh.so which points to the
correct library (libclntsh.so.10.1). Its hard to tell from your
listing if its there but it would appear that it is not. Or did I miss
something in my quick read?

On 11/10/05, Ogbuji, Chimezie <OG...@cc...> wrote:
> Thanks, I went back and removed the reference to 7.3.2 from my
> LD_LIBRARY_PATH
>
> That looks to have been the culprit, but I'm now unable to build
> cx_Oracle against the 10.1.0.3 Solaris 32-bit Instance Client
> (http://download.oracle.com/otn/solaris/instantclient/instantclient-basi
> c-solaris32-10.1.0.3.zip)
>
> My LD_LIBRARY_PATH:
>
> LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/usr/lo=
c
> al/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/mysql/lib:/
> usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/Orac
> leClient:/usr/local/OracleClient/lib
>
> The contents of /usr/local/OracleClient (I simply unpacked them from the
> above zip - as directed by the installation instructions):
>
> bash-2.03$ ls /usr/local/OracleClient/
> classes12.jar         libclntsh.so.9.1.new  libocci.so.10.1
> libocijdbc10.so       sdk
> libclntsh.so.10.1     libnnz10.so           libociei.so
> ojdbc14.jar
>
> libclntsh.so.10.1 is there
>
> The build error:
>
> bash-2.03$ python setup.py install
> running install
> running build
> running build_ext
> building 'cx_Oracle' extension
> creating build
> creating build/temp.solaris-2.8-sun4u-2.4
> gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
> -I/usr/local/OracleClient/rdbms/demo
> -I/usr/local/OracleClient/rdbms/public
> -I/usr/local/OracleClient/network/public
> -I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4 -c
> cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> -DBUILD_TIME=3D"November 10, 2005 08:50:52"
> In file included from /usr/local/OracleClient/sdk/include/oci.h:2327,
>                  from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/oci1.h:148: warning: function
> declaration isn't a prototype
> In file included from /usr/local/OracleClient/sdk/include/ociap.h:206,
>                  from /usr/local/OracleClient/sdk/include/oci.h:2351,
>                  from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/nzt.h:674: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function
> declaration isn't a prototype
> In file included from /usr/local/OracleClient/sdk/include/oci.h:2351,
>                  from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function
> declaration isn't a prototype
> In file included from Variable.c:93,
>                  from Cursor.c:211,
>                  from Connection.c:303,
>                  from SessionPool.c:132,
>                  from cx_Oracle.c:73:
> DateTimeVar.c: In function `DateTimeVar_SetValue':
> DateTimeVar.c:81: warning: unused variable `status'
> creating build/lib.solaris-2.8-sun4u-2.4
> gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> -L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o
> build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s
> ld: fatal: library -lclntsh: not found
> ld: fatal: File processing errors. No output written to
> build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so
> collect2: ld returned 1 exit status
> error: command 'gcc' failed with exit status 1
>
> Searching google and google groups suggests people having issues with 64
> bit versions of the clntsh library and such, but I doubt that's the
> issue here as I'm pretty certain I have the right download for my
> system:
>
> bash-2.03$ uname -a
> SunOS joplin 5.8 Generic_117350-28 sun4u sparc SUNW,Sun-Fire-280R
>
> Any help would be appreciated as I'd love to be able to move on to
> pythonic interaction with the Oracle DB instead of using Jython w/ ZJDBC
>
> Chimezie Thomas-Ogbuji
> Lead Systems Analyst
> Thoracic and Cardiovascular Surgery
> Cleveland Clinic Foundation
> 9500 Euclid Avenue/ JJ40
> Cleveland, Ohio 44195
> Office: 216-444-8593
>
> -----Original Message-----
> From: cx-...@li...
> [mailto:cx-...@li...] On Behalf Of Chris
> Dunscombe
> Sent: Friday, October 28, 2005 3:56 AM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] Symbol reference error: OCIHandleFree -
> REPOST
>
> Chimezie,
>
> Just a quick point your LD_LIBRARY_PATH includes Oracle 7.3.2. Is this
> correct? I'd guess you'd
> need to have at least 8.1.7 as cx_Oracle isn't supported against Oracle
> 7 anymore.
>
> HTH
>
> Chris
>
> --- Chimezie Ogbuji <chi...@gm...> wrote:
>
> > I appologize for the repost, but I realized my original subject line
> > was incorrectly specified (OCI-22054 error using cx_Oracle) and
> > probably would have the email show up under a defunct thread and not
> > at the top level:
> >
> > I've been struggling for some time to find an easy (non-convoluted)
> > way to connect to Oracle 8,9, and 10g databases consistently from a
> > Solaris 8 MP box.  For some time I had been using DataDirects Oracle
> > Wire Protocol drivers with UNIX ODBC and egenix's mxODBC.  However,
> > DataDirect's drivers (which do not require an Oracle Client install -
> > which is the most attractive thing about them) have since exceeded my
> > evaluation period, so I'm giving cx_Oracle a shot.
> >
> > Following directions from this thread
> >
> (http://sourceforge.net/mailarchive/forum.php?thread_id=3D8719369&forum_i=
d
> =3D34464),
> > I've installed the the Oracle Instant Client, installed the SDK
> > package, modified the setup.py of cx_Oracle and was able to run python
> > setup.py install w/out any errors:
> >
> > bash-2.03$ python setup.py install
> > running install
> > running build
> > running build_ext
> > building 'cx_Oracle' extension
> > creating build
> > creating build/temp.solaris-2.8-sun4u-2.4
> > gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes
> > -fPIC -I/usr/local/OracleClient/rdbms/demo
> > -I/usr/local/OracleClient/rdbms/public
> > -I/usr/local/OracleClient/network/public
> > -I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4
> > -c cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> > -DBUILD_TIME=3D"October 27, 2005 10:01:17"
> > In file included from /usr/local/OracleClient/sdk/include/oci.h:2327,
> >                 from cx_Oracle.c:9:
> > /usr/local/OracleClient/sdk/include/oci1.h:148: warning: function
> > declaration isn't a prototype
> > In file included from /usr/local/OracleClient/sdk/include/ociap.h:206,
> >                 from /usr/local/OracleClient/sdk/include/oci.h:2351,
> >                 from cx_Oracle.c:9:
> > /usr/local/OracleClient/sdk/include/nzt.h:674: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function
> > declaration isn't a prototype
> > In file included from /usr/local/OracleClient/sdk/include/oci.h:2351,
> >                 from cx_Oracle.c:9:
> > /usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function
> > declaration isn't a prototype
> > /usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function
> > declaration isn't a prototype
> > In file included from Variable.c:93,
> >                 from Cursor.c:211,
> >                 from Connection.c:303,
> >                 from SessionPool.c:132,
> >                 from cx_Oracle.c:73:
> > DateTimeVar.c: In function `DateTimeVar_SetValue':
> > DateTimeVar.c:81: warning: unused variable `status'
> > creating build/lib.solaris-2.8-sun4u-2.4
> > gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> > -L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o
> > build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s
> > running install_lib
> > copying build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so ->
> > /usr/local/lib/python2.4/site-packages
> >
> > However, when I try to run any of the tests (or just try to import the
> > newly installed cx_Oracle) I get the following symbol reference error:
> >
> > bash-2.03$ python test/test.py
> > Traceback (most recent call last):
> >  File "test/test.py", line 3, in ?
> >    import cx_Oracle
> > ImportError: ld.so.1: python: fatal: relocation error: file
> > /usr/local/lib/python2.4/site-packages/cx_Oracle.so: symbol
> > OCIHandleFree: referenced symbol not found
> >
> > I wouldn't expect the build process to complete if there were symbol
> > reference issues, but I have the Instant Client binaries installed in
> > /usr/local/OracleClient
> > , the sdk package installed in /usr/local/OracleClient/sdk, my
> > ORACLE_HOME  variable points to /usr/local/OracleClient, and
> > LD_LIBRARY_PATH includes /usr/local/OracleClient:
> >
> > bash-2.03$ env | grep LD_LIBRARY_PATH
> >
> LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/vol/or=
a
> cle/product/7.3.2/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pg
> sql/lib:/usr/local/mysql/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/l
> ocal/pgsql/lib:/usr/local/OracleClient
> > bash-2.03$ env | grep ORACLE_HOME
> > ORACLE_HOME=3D/usr/local/OracleClient
> >
> > I'm not sure why it's unable to resolve the symbol.  Any help would be
> > greatly appreciated
> >
> > Chimezie
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.
> > Get Certified Today * Register for a JBoss Training Course
> > Free Certification Exam for All Training Attendees Through End of 2005
> > Visit http://www.jboss.com/services/certification for more information
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> -------------------------------------------------------------------------=
-----
> Confidentiality Note:  This message is intended for use only by the indiv=
idual or entity to which it is addressed and may contain information that i=
s privileged, confidential, and exempt from disclosure under applicable law=
.  If the reader of this message is not the intended recipient or the emplo=
yee or agent responsible for delivering the message to the intended recipie=
nt, you are hereby notified that any dissemination, distribution or copying=
 of this communication is strictly prohibited.  If you have received this c=
ommunication in error,  please contact the sender immediately and destroy t=
he material in its entirety, whether electronic or hard copy.  Thank you.
> ------------
> Visit us online at our award-winning http://www.clevelandclinic.org for a=
 complete listing of Cleveland Clinic services, staff and locations from on=
e of the country's leading hospitals.
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Re: Compiling cx_Oracle with Linux Oracle Instantclient 10.2

[Nicolas D. <ni...@du...>]

[In reply to Anthony reply to my post. I'm not subscribed to the list so
I did not receive Anthony's reply]

Anthony wrote:
> >    Hi all,
> > 
> >  Below is a small patch I had to apply on cx_Oracle sources to make them
> > compile on my Debian Linux testing box with the Oracle Instantclient
> > 10.2.
> 
>    Hmm, I certainly don't have the same directory structure as you do.
> I've been using the RPM version and it puts the libraries in
> /usr/lib/oracle/10.2.0.1/lib and the include files in
> /usr/include/oracle/10.2.0.1/client. How did you install the client?

  I used the .zip archives of Instantclient 10.2 and unpacked them in
/opt.

  Regards,

-- 
Nicolas Duboc <ni...@du...>

RE: [cx-oracle-users] Symbol reference error: OCIHandleFree - REPOST

[Ogbuji, C. <OG...@cc...>]

Thanks, I went back and removed the reference to 7.3.2 from my
LD_LIBRARY_PATH

That looks to have been the culprit, but I'm now unable to build
cx_Oracle against the 10.1.0.3 Solaris 32-bit Instance Client
(http://download.oracle.com/otn/solaris/instantclient/instantclient-basi
c-solaris32-10.1.0.3.zip)

My LD_LIBRARY_PATH:

LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/usr/loc
al/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/mysql/lib:/
usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pgsql/lib:/usr/local/Orac
leClient:/usr/local/OracleClient/lib

The contents of /usr/local/OracleClient (I simply unpacked them from the
above zip - as directed by the installation instructions):

bash-2.03$ ls /usr/local/OracleClient/
classes12.jar         libclntsh.so.9.1.new  libocci.so.10.1
libocijdbc10.so       sdk
libclntsh.so.10.1     libnnz10.so           libociei.so
ojdbc14.jar

libclntsh.so.10.1 is there

The build error:

bash-2.03$ python setup.py install
running install
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.solaris-2.8-sun4u-2.4
gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC
-I/usr/local/OracleClient/rdbms/demo
-I/usr/local/OracleClient/rdbms/public
-I/usr/local/OracleClient/network/public
-I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4 -c
cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
-DBUILD_TIME=3D"November 10, 2005 08:50:52"
In file included from /usr/local/OracleClient/sdk/include/oci.h:2327,
                 from cx_Oracle.c:9:
/usr/local/OracleClient/sdk/include/oci1.h:148: warning: function
declaration isn't a prototype
In file included from /usr/local/OracleClient/sdk/include/ociap.h:206,
                 from /usr/local/OracleClient/sdk/include/oci.h:2351,
                 from cx_Oracle.c:9:
/usr/local/OracleClient/sdk/include/nzt.h:674: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function
declaration isn't a prototype
In file included from /usr/local/OracleClient/sdk/include/oci.h:2351,
                 from cx_Oracle.c:9:
/usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function
declaration isn't a prototype
/usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function
declaration isn't a prototype
In file included from Variable.c:93,
                 from Cursor.c:211,
                 from Connection.c:303,
                 from SessionPool.c:132,
                 from cx_Oracle.c:73:
DateTimeVar.c: In function `DateTimeVar_SetValue':
DateTimeVar.c:81: warning: unused variable `status'
creating build/lib.solaris-2.8-sun4u-2.4
gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
-L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o
build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s
ld: fatal: library -lclntsh: not found
ld: fatal: File processing errors. No output written to
build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

Searching google and google groups suggests people having issues with 64
bit versions of the clntsh library and such, but I doubt that's the
issue here as I'm pretty certain I have the right download for my
system:

bash-2.03$ uname -a
SunOS joplin 5.8 Generic_117350-28 sun4u sparc SUNW,Sun-Fire-280R

Any help would be appreciated as I'd love to be able to move on to
pythonic interaction with the Oracle DB instead of using Jython w/ ZJDBC

Chimezie Thomas-Ogbuji
Lead Systems Analyst
Thoracic and Cardiovascular Surgery
Cleveland Clinic Foundation
9500 Euclid Avenue/ JJ40
Cleveland, Ohio 44195
Office: 216-444-8593

-----Original Message-----
=46rom: cx-...@li...
[mailto:cx-...@li...] On Behalf Of Chris
Dunscombe
Sent: Friday, October 28, 2005 3:56 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Symbol reference error: OCIHandleFree -
REPOST

Chimezie,

Just a quick point your LD_LIBRARY_PATH includes Oracle 7.3.2. Is this
correct=3F I'd guess you'd
need to have at least 8.1.7 as cx_Oracle isn't supported against Oracle
7 anymore.

HTH

Chris

--- Chimezie Ogbuji <chi...@gm...> wrote:

> I appologize for the repost, but I realized my original subject line
> was incorrectly specified (OCI-22054 error using cx_Oracle) and
> probably would have the email show up under a defunct thread and not
> at the top level:
>=20
> I've been struggling for some time to find an easy (non-convoluted)
> way to connect to Oracle 8,9, and 10g databases consistently from a
> Solaris 8 MP box.  For some time I had been using DataDirects Oracle
> Wire Protocol drivers with UNIX ODBC and egenix's mxODBC.  However,
> DataDirect's drivers (which do not require an Oracle Client install -
> which is the most attractive thing about them) have since exceeded my
> evaluation period, so I'm giving cx_Oracle a shot.
>=20
> Following directions from this thread
>
(http://sourceforge.net/mailarchive/forum.php=3Fthread_id=3D8719369&forum_id
=3D34464),
> I've installed the the Oracle Instant Client, installed the SDK
> package, modified the setup.py of cx_Oracle and was able to run python
> setup.py install w/out any errors:
>=20
> bash-2.03$ python setup.py install
> running install
> running build
> running build_ext
> building 'cx_Oracle' extension
> creating build
> creating build/temp.solaris-2.8-sun4u-2.4
> gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes
> -fPIC -I/usr/local/OracleClient/rdbms/demo
> -I/usr/local/OracleClient/rdbms/public
> -I/usr/local/OracleClient/network/public
> -I/usr/local/OracleClient/sdk/include -I/usr/local/include/python2.4
> -c cx_Oracle.c -o build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> -DBUILD_TIME=3D"October 27, 2005 10:01:17"
> In file included from /usr/local/OracleClient/sdk/include/oci.h:2327,
>                 from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/oci1.h:148: warning: function
> declaration isn't a prototype
> In file included from /usr/local/OracleClient/sdk/include/ociap.h:206,
>                 from /usr/local/OracleClient/sdk/include/oci.h:2351,
>                 from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/nzt.h:674: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2665: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2674: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2684: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2693: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2702: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2711: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2719: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2729: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2736: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/nzt.h:2744: warning: function
> declaration isn't a prototype
> In file included from /usr/local/OracleClient/sdk/include/oci.h:2351,
>                 from cx_Oracle.c:9:
> /usr/local/OracleClient/sdk/include/ociap.h:9952: warning: function
> declaration isn't a prototype
> /usr/local/OracleClient/sdk/include/ociap.h:9958: warning: function
> declaration isn't a prototype
> In file included from Variable.c:93,
>                 from Cursor.c:211,
>                 from Connection.c:303,
>                 from SessionPool.c:132,
>                 from cx_Oracle.c:73:
> DateTimeVar.c: In function `DateTimeVar_SetValue':
> DateTimeVar.c:81: warning: unused variable `status'
> creating build/lib.solaris-2.8-sun4u-2.4
> gcc -shared build/temp.solaris-2.8-sun4u-2.4/cx_Oracle.o
> -L/usr/local/OracleClient/lib -L/usr/local/OracleClient -lclntsh -o
> build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so -s
> running install_lib
> copying build/lib.solaris-2.8-sun4u-2.4/cx_Oracle.so ->
> /usr/local/lib/python2.4/site-packages
>=20
> However, when I try to run any of the tests (or just try to import the
> newly installed cx_Oracle) I get the following symbol reference error:
>=20
> bash-2.03$ python test/test.py
> Traceback (most recent call last):
>  File "test/test.py", line 3, in =3F
>    import cx_Oracle
> ImportError: ld.so.1: python: fatal: relocation error: file
> /usr/local/lib/python2.4/site-packages/cx_Oracle.so: symbol
> OCIHandleFree: referenced symbol not found
>=20
> I wouldn't expect the build process to complete if there were symbol
> reference issues, but I have the Instant Client binaries installed in
> /usr/local/OracleClient
> , the sdk package installed in /usr/local/OracleClient/sdk, my
> ORACLE_HOME  variable points to /usr/local/OracleClient, and
> LD_LIBRARY_PATH includes /usr/local/OracleClient:
>=20
> bash-2.03$ env | grep LD_LIBRARY_PATH
>
LD_LIBRARY_PATH=3D/programs/lsf/6.0/sparc-sol7-64/lib:/usr/dt/lib:/vol/ora
cle/product/7.3.2/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/local/pg
sql/lib:/usr/local/mysql/lib:/usr/local/lib:/usr/lib:/usr/ccs/lib:/usr/l
ocal/pgsql/lib:/usr/local/OracleClient
> bash-2.03$ env | grep ORACLE_HOME
> ORACLE_HOME=3D/usr/local/OracleClient
>=20
> I'm not sure why it's unable to resolve the symbol.  Any help would be
> greatly appreciated
>=20
> Chimezie
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.
> Get Certified Today * Register for a JBoss Training Course
> Free Certification Exam for All Training Attendees Through End of 2005
> Visit http://www.jboss.com/services/certification for more information
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>=20



=09
	=09
__________________________________=20
Yahoo! Mail - PC Magazine Editors' Choice 2005=20
http://mail.yahoo.com


-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.
Get Certified Today * Register for a JBoss Training Course
=46ree Certification Exam for All Training Attendees Through End of 2005
Visit http://www.jboss.com/services/certification for more information
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users


---------------------------------------------------------------------------=
---
Confidentiality Note:  This message is intended for use only by the =
individual or entity to which it is addressed and may contain information =
that is privileged, confidential, and exempt from disclosure under =
applicable law.  If the reader of this message is not the intended recipien=
t=
 or the employee or agent responsible for delivering the message to the =
intended recipient, you are hereby notified that any dissemination, =
distribution or copying of this communication is strictly prohibited.  If =
you have received this communication in error,  please contact the sender =
immediately and destroy the material in its entirety, whether electronic or=
 =
hard copy.  Thank you.
------------
Visit us online at our award-winning http://www.clevelandclinic.org for a =
complete listing of Cleveland Clinic services, staff and locations from one=
 =
of the country's leading hospitals.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

Re: [cx-oracle-users] Compiling cx_Oracle with Linux Oracle Instantclient 10.2

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

Hmm, I certainly don't have the same directory structure as you do.
I've been using the RPM version and it puts the libraries in
/usr/lib/oracle/10.2.0.1/lib and the include files in
/usr/include/oracle/10.2.0.1/client. How did you install the client?

The binary you built should be just fine, though. All that matters for
compilation is that your header files and your shared libary files
match. :-)

On 11/8/05, Nicolas Duboc <ni...@du...> wrote:
>    Hi all,
>
>  Below is a small patch I had to apply on cx_Oracle sources to make them
> compile on my Debian Linux testing box with the Oracle Instantclient
> 10.2.
>
>  There were compilation warnings but the module seems to work for me
> (and I don't plan to use it for production applications so not a problem
> for me).
>
>  Thanks,
>
> --
> Nicolas Duboc <ni...@du...>
>
>
> --- setup.py.bak        2005-01-21 06:17:28.000000000 +0100
> +++ setup.py            2005-11-08 15:33:15.000000000 +0100
> @@ -47,7 +47,7 @@
>          libDirs[i] =3D os.path.join(oracleHome, libDirs[i])
>      libs =3D ["oci"]
>  else:
> -    includeDirs =3D ["rdbms/demo", "rdbms/public", "network/public"]
> +    includeDirs =3D ["rdbms/demo", "rdbms/public", "network/public", "sd=
k/include"]
>      if sys.platform =3D=3D "darwin":
>          includeDirs.append("plsql/public")
>      for i in range(len(includeDirs)):
> @@ -56,6 +56,7 @@
>      if sys.platform =3D=3D "sunos5" and sys.maxint > 2147483647:
>          libPath =3D os.path.join(oracleHome, "lib64")
>      libDirs =3D [libPath]
> +    libDirs.append(oracleHome)
>      libs =3D ["clntsh"]
>
>  # determine the build time to use in the binary
>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] undefined symbol: __cmpdi2

[Lionel R. <lro...@li...>]

Thanks for your help, I found the response by happending -locijdbc9
to $ORACLE_HOME/lib/sysliblist and recall genclntsh. Now it's ok :-)
bye all

Le Mercredi 09 Novembre 2005 04:05, inkbottle a =C3=A9crit=C2=A0:
> google is your friend.
>
> http://mail.zope.org/pipermail/zope-db/2003-September/002117.html
> http://sourceware.org/ml/binutils/2001-06/msg00670.html
>
> and others.  Perhaps you can get some ideas from these.
>
> Lionel Roubeyrie wrote:
> >hi all,
> >I have installed cx_Oracle-4.1 on a RedHat 7.1 server supporting Oracle9=
i.
> >The compile and install processes seem ok, but when I try to import with
> >python2.4.2 -v:
> >import cx_Oracle
> >dlopen("/home/xair/partage/python2.4/lib/python2.4/site-packages/cx_Orac=
le
> >.so", 2);
> >Traceback (most recent call last):
> >  File "<stdin>", line 1, in ?
> >ImportError: /home/oracle9/app/oracle/product/9.0.1/lib/libclntsh.so.9.0:
> >undefined symbol: __cmpdi2
> >
> >Do you have an idea?
> >Thanks
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server.
> Download it for free - -and be entered to win a 42" plasma tv or your very
> own Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

=2D-=20
Lionel Roubeyrie - lro...@li...
LIMAIR
http://www.limair.asso.fr

Re: [cx-oracle-users] undefined symbol: __cmpdi2

[inkbottle <ink...@gm...>]

google is your friend. 

http://mail.zope.org/pipermail/zope-db/2003-September/002117.html
http://sourceware.org/ml/binutils/2001-06/msg00670.html

and others.  Perhaps you can get some ideas from these.


Lionel Roubeyrie wrote:

>hi all,
>I have installed cx_Oracle-4.1 on a RedHat 7.1 server supporting Oracle9i.
>The compile and install processes seem ok, but when I try to import with 
>python2.4.2 -v:
>import cx_Oracle
>dlopen("/home/xair/partage/python2.4/lib/python2.4/site-packages/cx_Oracle.so", 
>2);
>Traceback (most recent call last):
>  File "<stdin>", line 1, in ?
>ImportError: /home/oracle9/app/oracle/product/9.0.1/lib/libclntsh.so.9.0: 
>undefined symbol: __cmpdi2
>
>Do you have an idea?
>Thanks
>
>  
>

[cx-oracle-users] Compiling cx_Oracle with Linux Oracle Instantclient 10.2

[Nicolas D. <ni...@du...>]

   Hi all,

 Below is a small patch I had to apply on cx_Oracle sources to make them
compile on my Debian Linux testing box with the Oracle Instantclient
10.2.

 There were compilation warnings but the module seems to work for me
(and I don't plan to use it for production applications so not a problem
for me).

 Thanks,

-- 
Nicolas Duboc <ni...@du...>


--- setup.py.bak	2005-01-21 06:17:28.000000000 +0100
+++ setup.py            2005-11-08 15:33:15.000000000 +0100
@@ -47,7 +47,7 @@
         libDirs[i] = os.path.join(oracleHome, libDirs[i])
     libs = ["oci"]
 else:
-    includeDirs = ["rdbms/demo", "rdbms/public", "network/public"]
+    includeDirs = ["rdbms/demo", "rdbms/public", "network/public", "sdk/include"]
     if sys.platform == "darwin":
         includeDirs.append("plsql/public")
     for i in range(len(includeDirs)):
@@ -56,6 +56,7 @@
     if sys.platform == "sunos5" and sys.maxint > 2147483647:
         libPath = os.path.join(oracleHome, "lib64")
     libDirs = [libPath]
+    libDirs.append(oracleHome)
     libs = ["clntsh"]
 
 # determine the build time to use in the binary

[cx-oracle-users] undefined symbol: __cmpdi2

[Lionel R. <lro...@li...>]

hi all,
I have installed cx_Oracle-4.1 on a RedHat 7.1 server supporting Oracle9i.
The compile and install processes seem ok, but when I try to import with 
python2.4.2 -v:
import cx_Oracle
dlopen("/home/xair/partage/python2.4/lib/python2.4/site-packages/cx_Oracle.so", 
2);
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ImportError: /home/oracle9/app/oracle/product/9.0.1/lib/libclntsh.so.9.0: 
undefined symbol: __cmpdi2

Do you have an idea?
Thanks

-- 
Lionel Roubeyrie - lro...@li...
LIMAIR
http://www.limair.asso.fr

[cx-oracle-users] Re: Usage of makedsn()

[<pw...@re...>]

Yes, thank you.  That explains it.  I was thinking that this was something that read the tnsnames file.  My bad.

>  From: Anthony Tuininga <ant...@gm...>
>  To: cx-...@li...
>  Subject: Re: [cx-oracle-users] Re: cx-oracle-users digest, Vol 1 #167 - 4 msgs
>  Reply-To: cx-...@li...
>  
>  Ah, makedsn() is not "smart" -- its simply a glorified string
>  substitution method so it takes what you give it so if you want it to
>  contain HOST=3D172.16.0.80 then specify that in your makedsn() call as
>  in
>  
>  dsn =3D cx_Oracle.makedsn("172.16.0.80", 1521, "TRAIN")
>  
>  which will yield
>  
>  '(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D172.16.0=
>  .80)(PORT=3D1521)))(CONNECT_DATA=3D(SID=3DTRAIN)))'
>  
>  Hope that helps.

[cx-oracle-users] Philip SION/cg13 est absent(e).

[<phi...@cg...>]

Je serai absent(e) du  07/11/2005 au 09/11/2005.

Merci de limiter vos messages pendant mon absence.

Pour les probl=E8mes techniques, la boite aux lettres
srt...@cg... reste trait=E9e pendant mon absence.

Merci.=

Re: [cx-oracle-users] Re: cx-oracle-users digest, Vol 1 #167 - 4 msgs

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

Ah, makedsn() is not "smart" -- its simply a glorified string
substitution method so it takes what you give it so if you want it to
contain HOST=3D172.16.0.80 then specify that in your makedsn() call as
in

dsn =3D cx_Oracle.makedsn("172.16.0.80", 1521, "TRAIN")

which will yield

'(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D172.16.0=
.80)(PORT=3D1521)))(CONNECT_DATA=3D(SID=3DTRAIN)))'

Hope that helps.

On 11/6/05, Paul Watson <pw...@re...> wrote:
> >  Hmm, I'm not sure exactly what you think the problem is. From your
> >  demo below the dsn produced by your call to makedsn() looks just fine.
> >  Can you indicate what you were expecting to happen?
>
> Sorry.  I guess that it is less than obvious that my hostname (pwatson) i=
s not the IP address of the Oracle host.
>
> I was expecting makedns() to contain 'HOST=3D172.16.0.80' which is the ad=
dress of the Oracle engine server, not my local IP address.
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] Re: cx-oracle-users digest, Vol 1 #167 - 4 msgs

[<pw...@re...>]

>  Hmm, I'm not sure exactly what you think the problem is. From your
>  demo below the dsn produced by your call to makedsn() looks just fine.
>  Can you indicate what you were expecting to happen?

Sorry.  I guess that it is less than obvious that my hostname (pwatson) is not the IP address of the Oracle host.

I was expecting makedns() to contain 'HOST=172.16.0.80' which is the address of the Oracle engine server, not my local IP address.

Re: [cx-oracle-users] Installing cx_Oracle under Cygwin

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

Hmm, the installer is meant to install under Windows the normal way --
not the Cygwin way so that is why it behaves as it does. That said,
you should be able to use the actual binary without any trouble.
You'll simply have to extract it yourself. I believe that WinZip (or
Python itself) can read the zip file that is part of the installer.
Simply extract cx_Oracle.pyd and put it somewhere on your PYTHONPATH.

On 11/5/05, Paul Watson <pw...@re...> wrote:
> How can I install cx_Oracle for use by the Cygwin /usr/bin/python?
>
> The Windows installer appears to only permit installation under Pythons f=
ound in the Windows registry.
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] cx_Oracle.makedsn not using remote host

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

Hmm, I'm not sure exactly what you think the problem is. From your
demo below the dsn produced by your call to makedsn() looks just fine.
Can you indicate what you were expecting to happen?

On 11/5/05, Paul Watson <pw...@re...> wrote:
> When I use cx_Oracle.makedsn for a remote connection, the host is replace=
d with my own local hostname and not that of the system running the Oracle =
engine.  I also tried "@TRAIN" for the SID with no effect.  Am I doing some=
thing incorrectly.  Please advise.
>
> C:\src\python\db\cx_Oracle>python
> Python 2.4.2 (#67, Sep 28 2005, 12:41:11) [MSC v.1310 32 bit (Intel)] on =
win32
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import cx_Oracle
> >>> cx_Oracle.version
> 'HEAD'
> >>> cx_Oracle.buildtime
> 'January 26, 2005 14:37:48'
> >>> dsn =3D cx_Oracle.makedsn("pwatson", 1521, "TRAIN")
> >>> dsn
> '(DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dpwatso=
n)(PORT=3D1521)))(CONNECT_DATA=3D(SID=3DTRAIN)))'
> >>> ^Z
>
>
> C:\src\python\db\cx_Oracle>cat \oracle\ora81\network\admin\tnsnames.ora
> # TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\=
tnsnames.ora
> # Generated by Oracle configuration tools.
>
> TRAIN.ADOMAIN.COM =3D
>   (DESCRIPTION =3D
>     (ADDRESS_LIST =3D
>       (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 172.16.0.80)(PORT =3D 1521=
))
>     )
>     (CONNECT_DATA =3D
>       (SERVICE_NAME =3D train)
>     )
>   )
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. Downl=
oad
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

[cx-oracle-users] cx_Oracle.makedsn not using remote host

[<pw...@re...>]

When I use cx_Oracle.makedsn for a remote connection, the host is replaced with my own local hostname and not that of the system running the Oracle engine.  I also tried "@TRAIN" for the SID with no effect.  Am I doing something incorrectly.  Please advise.

C:\src\python\db\cx_Oracle>python
Python 2.4.2 (#67, Sep 28 2005, 12:41:11) [MSC v.1310 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> cx_Oracle.version
'HEAD'
>>> cx_Oracle.buildtime
'January 26, 2005 14:37:48'
>>> dsn = cx_Oracle.makedsn("pwatson", 1521, "TRAIN")
>>> dsn
'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=pwatson)(PORT=1521)))(CONNECT_DATA=(SID=TRAIN)))'
>>> ^Z


C:\src\python\db\cx_Oracle>cat \oracle\ora81\network\admin\tnsnames.ora
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TRAIN.ADOMAIN.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.80)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = train)
    )
  )

[cx-oracle-users] Installing cx_Oracle under Cygwin

[<pw...@re...>]

How can I install cx_Oracle for use by the Cygwin /usr/bin/python?

The Windows installer appears to only permit installation under Pythons found in the Windows registry.

[cx-oracle-users] Re: Performance differences between bind parameters and string su bstitution

[Henning v. B. <H.v...@t-...>]

Perhaps it would help if you'd send the query SQL text.
How does it use your bind variables?

I mean, are you doing (using scott/tiger as an example)
"where ENAME like :P_ENAME"
or
"where ENAME = :P_ENAME" ?

This can be quite a difference in 10g, AFAIK.
That's because 10g has a new feature called
bind-variable inspection (or whatever).

When the query is first executed, the optimizer
checks the actual value of P_ENAME and then treats
the query as if it used a constant.

Thus, if your very first value is "%SMITH", for example,
Oracle will decide that it cannot use an index 
(even if ENAME was a primary key) and use a full table scan.

Never tested this, anyway.
Perhaps your query is a good candidate for Tom Kyte's asktom web site ?

Henning

RE: [cx-oracle-users] Performance differences between bind parameters and string substitution

[Hancock, D. \(DHANCOCK\) <DHA...@ar...>]

Platform stuff:

Platform: White Box Enterprise Linux 3.0 (clone of Redhat Enterprise
Linux 3.0);
Hardware: Intel dual Xeon processors, 3.0 GHz, 6GB RAM, lotsa disk=20
Oracle server version: 10.1.0.3
Oracle client version: 10g Instant Client

We'll follow up directly with Anthony on the query itself.

D.R. Boxhoorn also mentioned a similar weird case where running
hextoraw() on the bound parameter sped up the query a lot (but it was a
column with hex strings in it). I don't think that applies to our issue,
but it's good to know--thanks for that.

Cheers!
--
David Hancock | dha...@ar... | 410-266-4384=20


-----Original Message-----
From: cx-...@li...
[mailto:cx-...@li...] On Behalf Of
Anthony Tuininga
Sent: Wednesday, November 02, 2005 9:33 AM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Performance differences between bind
parameters and string substitution


No bells ringing here. :-) We haven't used 10g much yet but haven't
noticed anything of this nature. Could you give some additional
information on what platform you are running Oracle on and what
version of Oracle you are running -- both client and server. Could you
also send a sample query so that I can try this for myself on a 10g
database? We are considering moving to 10g fairly soon so I'd like to
know about these sort of problems up front. :-)

On 11/1/05, Hancock, David (DHANCOCK) <DHA...@ar...> wrote:
>
>
> We're using Oracle 10g, Python 2.3, cx_Oracle "HEAD" (sorry no better
> version number than that, but we picked up the latest
version--4.1--earlier
> this year and compiled against 10g headers).
>
> We're seeing counterintuitive behavior with one of our queries (we
can't
> reproduce it with other "biggish" queries). If we construct the query
by
> substituting strings instead of using bind parameters, the query runs
100
> times faster! For the same dataset, that's 30 seconds with bind
parameters
> and 0.3 seconds with string substitution. We're holding as much
constant as
> possible (arraysize, for example, is staying at 20). This is
repeatable. The
> furthest we've gotten towards isolating the problem is to learn that
we can
> reproduce the "fix" by only string-substituting the date fields.
>
> A few more data points: When we "explain plan" on both versions of the
> query, we get identical results. When we run both queries in SQL*Plus,
we
> get consistent fast results (< 1 second). But when we run both queries
from
> Python via cx_Oracle, we get the huge discrepancy. We only started
noticing
> this a couple weeks ago, but that doesn't mean it wasn't happening
before,
> we just didn't notice.
>
> We've worked around this by changing just this one query to do string
> substitution, but I'd REALLY like to know what the cause is and fix
it.
>
> Does this ring a bell for anyone? I'd expect bind-parameter queries to
run
> faster, not slower, and this one is a LOT slower.
>
> Cheers!
> --
> David Hancock | dha...@ar... | 410-266-4384


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server.
Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] Performance differences between bind parameters and string substitution

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

No bells ringing here. :-) We haven't used 10g much yet but haven't
noticed anything of this nature. Could you give some additional
information on what platform you are running Oracle on and what
version of Oracle you are running -- both client and server. Could you
also send a sample query so that I can try this for myself on a 10g
database? We are considering moving to 10g fairly soon so I'd like to
know about these sort of problems up front. :-)

On 11/1/05, Hancock, David (DHANCOCK) <DHA...@ar...> wrote:
>
>
> We're using Oracle 10g, Python 2.3, cx_Oracle "HEAD" (sorry no better
> version number than that, but we picked up the latest version--4.1--earli=
er
> this year and compiled against 10g headers).
>
> We're seeing counterintuitive behavior with one of our queries (we can't
> reproduce it with other "biggish" queries). If we construct the query by
> substituting strings instead of using bind parameters, the query runs 100
> times faster! For the same dataset, that's 30 seconds with bind parameter=
s
> and 0.3 seconds with string substitution. We're holding as much constant =
as
> possible (arraysize, for example, is staying at 20). This is repeatable. =
The
> furthest we've gotten towards isolating the problem is to learn that we c=
an
> reproduce the "fix" by only string-substituting the date fields.
>
> A few more data points: When we "explain plan" on both versions of the
> query, we get identical results. When we run both queries in SQL*Plus, we
> get consistent fast results (< 1 second). But when we run both queries fr=
om
> Python via cx_Oracle, we get the huge discrepancy. We only started notici=
ng
> this a couple weeks ago, but that doesn't mean it wasn't happening before=
,
> we just didn't notice.
>
> We've worked around this by changing just this one query to do string
> substitution, but I'd REALLY like to know what the cause is and fix it.
>
> Does this ring a bell for anyone? I'd expect bind-parameter queries to ru=
n
> faster, not slower, and this one is a LOT slower.
>
> Cheers!
> --
> David Hancock | dha...@ar... | 410-266-4384

Re: [cx-oracle-users] Performance differences between bind parameters and string substitution

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

Hoi David,

What you describe does ring a bell, but whether that will be of any help ...
We noticed that queries with "WHERE OBJECT_ID=:1" performed _much_ worse than
"WHERE OBJECT_ID=HEXTORAW(:1)", where the bind variable contains a
hexadecimal string.
In our case the execution plan differed between both cases. A full table
scan was performed when the HEXTORAW() was not used. We have never tried
to find out what was the cause of this difference in behaviour, though.
We had a suspicion that it could be due to the way string/RAW conversion
is handled by OCI and the cx_Oracle module. If this is the kind of
conversion your query has to perform, then maybe there is a connection.

Also note that the cost-based optimizer can choose different execution plans
for bind variables on one hand and for hard-coded constants on the other
hand if your data is skewed. From your explanation I understand that this
is not the case.

Hoping that this helps in finding the cause of the strange behaviour,

                                                   Danny

On Tue, Nov 01, 2005 at 03:36:51PM -0500, Hancock, David (DHANCOCK) wrote:
> We're using Oracle 10g, Python 2.3, cx_Oracle "HEAD" (sorry no better
> version number than that, but we picked up the latest
> version--4.1--earlier this year and compiled against 10g headers).
> 
> We're seeing counterintuitive behavior with one of our queries (we can't
> reproduce it with other "biggish" queries). If we construct the query by
> substituting strings instead of using bind parameters, the query runs
> 100 times faster! For the same dataset, that's 30 seconds with bind
> parameters and 0.3 seconds with string substitution. We're holding as
> much constant as possible (arraysize, for example, is staying at 20).
> This is repeatable. The furthest we've gotten towards isolating the
> problem is to learn that we can reproduce the "fix" by only
> string-substituting the date fields.
> 
> A few more data points: When we "explain plan" on both versions of the
> query, we get identical results. When we run both queries in SQL*Plus,
> we get consistent fast results (< 1 second). But when we run both
> queries from Python via cx_Oracle, we get the huge discrepancy. We only
> started noticing this a couple weeks ago, but that doesn't mean it
> wasn't happening before, we just didn't notice.
> 
> We've worked around this by changing just this one query to do string
> substitution, but I'd REALLY like to know what the cause is and fix it.
> 
> Does this ring a bell for anyone? I'd expect bind-parameter queries to
> run faster, not slower, and this one is a LOT slower.
> 
> Cheers!
> --
> David Hancock | dha...@ar... | 410-266-4384 
>