Re: [cx-oracle-users] 4.1.2 install: Ubuntu Linux, Oracle 10.1.0.3 instant client problems
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] 4.1.2 install: Ubuntu Linux, Oracle 10.1.0.3 instant client problems
|
From: cpoetzel <cpo...@an...> - 2006-02-07 21:00:39
|
Anthony,
Thanks for the response.
I was able to get a connection and response when using a script as myself
with cx_Oracle.
However, when I try to run the same script from the web server, I get the
same error.
[Tue Feb 07 14:42:56 2006] [error] [client 146.137.1.33] ORA-12154:
TNS:could not resolve the connect identifier specified
I passed the web server the same env variables I have
Variable Value
LD_LIBRARY_PATH /usr/lib/oracle/10.1.0.3/client/lib
TNS_ADMIN /usr/lib/oracle/10.1.0.3/client
PATH /usr/local/bin:/usr/bin:/bin
PWD /etc/apache2
LANG C
SHLVL 1
ORACLE_HOME /usr/lib/oracle/10.1.0.3/client
_ /usr/sbin/apache2
Is there a way have a python program print out what tnsadmin.ora is looking
for when called from the web server?
There are only a handfull of python scripts that use cx_Oracle through the
web and if I have to statically set the env for TNS_ADMIN
I can live with that. I just don=E2=80=99t know how.
Thanks,
Chris Poetzel
On 2/7/06 10:06 AM, "Anthony Tuininga" <ant...@gm...> wrote:
> Its unfortunate that you don't have tnsping available as that tells
> you whether or not the Oracle client can find the tnsnames.ora file
> and whether it contains what you think it contains. :-) You do,
> however, have SQL*Plus so you should first verify that you can connect
> using it with the same connect string you are using with cx_Oracle.
> You can also make use of the cx_Oracle.make_dsn() method to generate
> the string that is normally found in a tnsnames.ora file and use that
> to connect. If you want to know which locations Oracle is searching
> for tnsnames.ora you can use the strace command -- there are several
> places. Hope this helps you track down the issue.
>=20
> On 2/6/06, cpoetzel <cpo...@an...> wrote:
>> > 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.s=
o
>> > 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 x=
a.h
>> > nzt.h occiCommon.h occiData.h occiObjects.h oci8dp.h ociap=
r.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-proto=
types
>> > -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/pytho=
n2.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=C2=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:
>> function
>> > declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2665: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2674: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2684: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2693: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2702: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2711: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2719: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2729: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2736: warning:
>> > function declaration isn=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/nzt.h:2744: warning:
>> > function declaration isn=C2=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=C2=B9t a prototype
>> > /usr/lib/oracle/10.1.0.3/client/lib/sdk/include/ociap.h:9958: warning:
>> > function declaration isn=C2=B9t a prototype
>> > In file included from SessionPool.c:134,
>> > from cx_Oracle.c:76:
>> > Connection.c: In function =C5=92Connection_Acquire=C2=B9:
>> > Connection.c:184: warning: pointer targets in passing argument 5 of
>> > =C5=92OCISessionGet=C2=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 =C5=92NumberVar_SetValue=C2=B9:
>> > NumberVar.c:178: warning: pointer targets in passing argument 2 of
>> > =C5=92OCINumberFromText=C2=B9 differ in signedness
>> > NumberVar.c:178: warning: pointer targets in passing argument 4 of
>> > =C5=92OCINumberFromText=C2=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 =C5=92DateTimeVar_SetValue=C2=B9:
>> > DateTimeVar.c:81: warning: unused variable =C5=92status=C2=B9
>> > In file included from cx_Oracle.c:76:
>> > SessionPool.c: In function =C5=92SessionPool_Init=C2=B9:
>> > SessionPool.c:246: warning: pointer targets in passing argument 6 of
>> > =C5=92OCISessionPoolCreate=C2=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.
>> >
>> >
>> >
>> > 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 (0x00002aaaaabc3=
000)
>> > 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] connectio=
n =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 defi=
ned
>> in
>> > my environment.
>> >
>> > Thank you much,
>> >
>> > Chris Poetzel
>> >
>> >
>> >
>> > -------------------------------------------------------
>> > This SF.net email is sponsored by: Splunk Inc. Do you grep through log
>> files
>> > for problems? Stop! Download the new AJAX search engine that makes
>> > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK=
!
>> > http://sel.as-us.falkag.net/sel?cmdlnk
>> <http://sel.as-us.falkag.net/sel?cmdlnk&kid> =103432&bid#0486&dat=121642
>> > _______________________________________________
>> > cx-oracle-users mailing list
>> > cx-...@li...
>> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>> >
> NH=C2=B5=C5=A0=C2=B2=C2=B2u=C2=A6=C2=90=0E=C2=BA=C2=A6=C2=A2=E2=80=93=C5=A0~=C2=AEz=C2=B6=C2=A3=C2=A1=E2=80=A6=C3=80^=C2=AD=C5=BEz=C2=B6zj=C5=A0=C2=A2=C2=A2=E2=80=A2=C2=B1=C3=89=C2=BA=C5=BE{=0C,H=
4=C2=B6=C2=B1=C2=B2j=E2=80=9A=C3=BE
>=20
|
