[cx-oracle-users] 4.1.2 install: Ubuntu Linux, Oracle 10.1.0.3 instant client problems

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi,
I am trying to install cx_Oracle 4.1.2 on a new Ubuntu Breezy Box. Its a
64bit amd box.
I have already installed the oracle 10.1.0.3 64 bit instant client.
Install looks like this

root@athena:/usr/lib/oracle/10.1.0.3/client# ls -R
.:
bin  lib  tnsnames.ora

./bin:
sqlplus

./lib:
classes12.jar  glogin.sql  libclntsh.so  libclntsh.so.10.1  libnnz10.so
libocci.so  libocci.so.10.1  libociei.so  libocijdbc10.so  libsqlplus.so
ojdbc14.jar  sdk

./lib/sdk:
demo  include

./lib/sdk/demo:
cdemo81.c  demo.mk  occidemod.sql  occidemo.sql  occidml.cpp

./lib/sdk/include:
nzerror.h  occiAQ.h      occiControl.h  occi.h         oci1.h    ociap.h
ocidef.h  ocidfn.h   oci.h     ocixmldb.h  oratypes.h  ori.h  oro.h  xa.h
nzt.h      occiCommon.h  occiData.h     occiObjects.h  oci8dp.h  ociapr.h
ocidem.h  ociextp.h  ocikpr.h  odci.h      orid.h      orl.h  ort.h

Env:
ORACLE_HOME=3D/usr/lib/oracle/10.1.0.3/client/lib
TNS_ADMIN=3D/usr/lib/oracle/10.1.0.3/client
LD_LIBRARY_PATH=3D/usr/lib/oracle/10.1.0.3/client/lib

Installing the client:
root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
setup.py build
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.linux-x86_64-2.4
gcc -pthread -fno-strict-aliasing -DNDEBUG -g -O3 -Wall -Wstrict-prototypes
-fPIC -I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/demo
-I/usr/lib/oracle/10.1.0.3/client/lib/rdbms/public
-I/usr/lib/oracle/10.1.0.3/client/lib/network/public
-I/usr/lib/oracle/10.1.0.3/client/lib/sdk/include -I/usr/include/python2.4
-c cx_Oracle.c -o build/temp.linux-x86_64-2.4/cx_Oracle.o
-DBUILD_TIME=3D"February 06, 2006 10:21:45"
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2327,
                 from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci1.h:148: warning:
function declaration isn=B9t a prototype
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:206,
                 from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
                 from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:674: warning: functio=
n
declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: warning:
function declaration isn=B9t a prototype
In file included from
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/oci.h:2351,
                 from cx_Oracle.c:9:
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9952: warning:
function declaration isn=B9t a prototype
/usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: warning:
function declaration isn=B9t a prototype
In file included from SessionPool.c:134,
                 from cx_Oracle.c:76:
Connection.c: In function =8CConnection_Acquire=B9:
Connection.c:184: warning: pointer targets in passing argument 5 of
=8COCISessionGet=B9 differ in signedness
In file included from Variable.c:89,
                 from Cursor.c:211,
                 from Connection.c:354,
                 from SessionPool.c:134,
                 from cx_Oracle.c:76:
NumberVar.c: In function =8CNumberVar_SetValue=B9:
NumberVar.c:178: warning: pointer targets in passing argument 2 of
=8COCINumberFromText=B9 differ in signedness
NumberVar.c:178: warning: pointer targets in passing argument 4 of
=8COCINumberFromText=B9 differ in signedness
In file included from Variable.c:93,
                 from Cursor.c:211,
                 from Connection.c:354,
                 from SessionPool.c:134,
                 from cx_Oracle.c:76:
DateTimeVar.c: In function =8CDateTimeVar_SetValue=B9:
DateTimeVar.c:81: warning: unused variable =8Cstatus=B9
In file included from cx_Oracle.c:76:
SessionPool.c: In function =8CSessionPool_Init=B9:
SessionPool.c:246: warning: pointer targets in passing argument 6 of
=8COCISessionPoolCreate=B9 differ in signedness
creating build/lib.linux-x86_64-2.4
gcc -pthread -shared build/temp.linux-x86_64-2.4/cx_Oracle.o
-L/usr/lib/oracle/10.1.0.3/client/lib/lib
-L/usr/lib/oracle/10.1.0.3/client/lib -lclntsh -o
build/lib.linux-x86_64-2.4/cx_Oracle.so -s
root@athena:/usr/local/build/Python-CxOracle/cx_Oracle-4.1.2# python
setup.py install
running install
running build
running build_ext
running install_lib
copying build/lib.linux-x86_64-2.4/cx_Oracle.so ->
/usr/lib/python2.4/site-packages

Not sure if these warnings are normal but have seen other people have them
in the postings.=20

root@athena:/tmp#  ldd /usr/lib/python2.4/site-packages/cx_Oracle.so
        libclntsh.so.10.1 =3D>
/usr/lib/oracle/10.1.0.3/client/lib/libclntsh.so.10.1 (0x00002aaaaabc3000)
        libpthread.so.0 =3D> /lib/libpthread.so.0 (0x00002aaaaba7b000)
        libc.so.6 =3D> /lib/libc.so.6 (0x00002aaaabb90000)
        libnnz10.so =3D> /usr/lib/oracle/10.1.0.3/client/lib/libnnz10.so
(0x00002aaaabdc7000)
        libdl.so.2 =3D> /lib/libdl.so.2 (0x00002aaaac038000)
        libm.so.6 =3D> /lib/libm.so.6 (0x00002aaaac13a000)
        libnsl.so.1 =3D> /lib/libnsl.so.1 (0x00002aaaac2bf000)
        /lib64/ld-linux-x86-64.so.2 (0x0000555555554000)

I get the following error when trying to run a script

[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]   File
"/usr/lib/cgi-bin/cxOracle-test.py", line 10, in ?
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]     connection =3D
cx_Oracle.connect("ectuser", "xxxxxx", "ect1");
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect
identifier specified
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33]
[Mon Feb 06 10:00:01 2006] [error] [client 146.137.1.33] Premature end of
script headers: cxOracle-test.py

It appears that cx_oracle can not find the tns admin file whish I defined i=
n
my environment.

Thank you much,

Chris Poetzel