cx-oracle-users

[cx-oracle-users] problems running cx_oracle in RH 7.2

[Gustavo R. <gu...@gr...>]

Hi all

I was trying to run cx_Oracle and got error. Output below.
The system is running RedHat 7.2, activepython 2.4


[rmsplus@dksl0013 cx_Oracle-4.1]$ ../python24/bin/python setup.py install
running install
running build
running build_ext
building 'cx_Oracle' extension
creating build
creating build/temp.linux-i686-2.4
gcc -pthread -fno-strict-aliasing -fPIC -DNDEBUG -g -O3 -Wall 
-Wstrict-prototypes -fPIC -I/opt/oracle/rdbms/demo 
-I/opt/oracle/rdbms/public -I/opt/oracle/network/public 
-I/home/rmsplus/python24/include/python2.4 -c cx_Oracle.c -o 
build/temp.linux-i686-2.4/cx_Oracle.o -DBUILD_TIME="October 26, 2005 
06:53:39"
In file included from /opt/oracle/rdbms/demo/oci.h:1623,
                 from cx_Oracle.c:9:
/opt/oracle/rdbms/demo/oci1.h:148: warning: function declaration isn't a 
prototype
In file included from /opt/oracle/rdbms/demo/oci.h:1648,
                 from cx_Oracle.c:9:
/opt/oracle/rdbms/demo/ociap.h:6266: warning: function declaration isn't 
a prototype
/opt/oracle/rdbms/demo/ociap.h:8748: warning: function declaration isn't 
a prototype
/opt/oracle/rdbms/demo/ociap.h:8754: warning: function declaration isn't 
a prototype
In file included from Variable.c:89,
                 from Cursor.c:211,
                 from Connection.c:303,
                 from cx_Oracle.c:75:
NumberVar.c: In function `NumberVar_SetValue':
NumberVar.c:178: warning: passing arg 4 of `OCINumberFromText' discards 
qualifiers from pointer target type
In file included from Variable.c:93,
                 from Cursor.c:211,
                 from Connection.c:303,
                 from cx_Oracle.c:75:
DateTimeVar.c: In function `DateTimeVar_SetValue':
DateTimeVar.c:81: warning: unused variable `status'
In file included from Connection.c:304,
                 from cx_Oracle.c:75:
Callback.c: In function `Callback_BindByNameArgs':
Callback.c:78: warning: value computed is not used
Callback.c:79: warning: value computed is not used
Callback.c: In function `Callback_DefineByPosArgs':
Callback.c:123: warning: value computed is not used
Callback.c:124: warning: value computed is not used
Callback.c: In function `Callback_ExecuteArgs':
Callback.c:155: warning: value computed is not used
Callback.c:157: warning: value computed is not used
Callback.c: In function `Callback_FetchArgs':
Callback.c:178: warning: value computed is not used
Callback.c: In function `Callback_PrepareArgs':
Callback.c:203: warning: value computed is not used
creating build/lib.linux-i686-2.4
gcc -pthread -shared build/temp.linux-i686-2.4/cx_Oracle.o 
-L/opt/oracle/lib -lclntsh -o build/lib.linux-i686-2.4/cx_Oracle.so -s
running install_lib
copying build/lib.linux-i686-2.4/cx_Oracle.so -> 
/home/rmsplus/python24/lib/python2.4/site-packages

[rmsplus@dksl0013 cx_Oracle-4.1]$ ../python24/bin/python
ActivePython 2.4.1 Build 247 (ActiveState Corp.) based on
Python 2.4.1 (#1, Jun 20 2005, 17:00:29)
[GCC 2.95.3 20010315 (SuSE)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
 >>> import cx_Oracle
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ImportError: libclntsh.so.8.0: cannot open shared object file: No such 
file or directory
 >>>


Any ideas?


Thanks
Gustavo

Re: [cx-oracle-users] problems running cx_oracle in RH 7.2

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

At a guess libclntsh.so.8.0 is not in your library search path. You
can determine this by running "ldd cx_Oracle.so" and noting that it
can't find libclntsh.so.8.0. You can fix this by setting
LD_LIBRARY_PATH or by setting the system wide library search path. You
can also (although this ties it to your particular Oracle
installation) use the rpath directive. The setup.py in cx_Oracle 4.1
looks for the environment variable "FORCE_RPATH" to set this up. Hope
that helps.

On 10/26/05, Gustavo Rahal <gu...@gr...> wrote:
> Hi all
>
> I was trying to run cx_Oracle and got error. Output below.
> The system is running RedHat 7.2, activepython 2.4
>
>
> [rmsplus@dksl0013 cx_Oracle-4.1]$ ../python24/bin/python setup.py install
> running install
> running build
> running build_ext
> building 'cx_Oracle' extension
> creating build
> creating build/temp.linux-i686-2.4
> gcc -pthread -fno-strict-aliasing -fPIC -DNDEBUG -g -O3 -Wall
> -Wstrict-prototypes -fPIC -I/opt/oracle/rdbms/demo
> -I/opt/oracle/rdbms/public -I/opt/oracle/network/public
> -I/home/rmsplus/python24/include/python2.4 -c cx_Oracle.c -o
> build/temp.linux-i686-2.4/cx_Oracle.o -DBUILD_TIME=3D"October 26, 2005
> 06:53:39"
> In file included from /opt/oracle/rdbms/demo/oci.h:1623,
>                  from cx_Oracle.c:9:
> /opt/oracle/rdbms/demo/oci1.h:148: warning: function declaration isn't a
> prototype
> In file included from /opt/oracle/rdbms/demo/oci.h:1648,
>                  from cx_Oracle.c:9:
> /opt/oracle/rdbms/demo/ociap.h:6266: warning: function declaration isn't
> a prototype
> /opt/oracle/rdbms/demo/ociap.h:8748: warning: function declaration isn't
> a prototype
> /opt/oracle/rdbms/demo/ociap.h:8754: warning: function declaration isn't
> a prototype
> In file included from Variable.c:89,
>                  from Cursor.c:211,
>                  from Connection.c:303,
>                  from cx_Oracle.c:75:
> NumberVar.c: In function `NumberVar_SetValue':
> NumberVar.c:178: warning: passing arg 4 of `OCINumberFromText' discards
> qualifiers from pointer target type
> In file included from Variable.c:93,
>                  from Cursor.c:211,
>                  from Connection.c:303,
>                  from cx_Oracle.c:75:
> DateTimeVar.c: In function `DateTimeVar_SetValue':
> DateTimeVar.c:81: warning: unused variable `status'
> In file included from Connection.c:304,
>                  from cx_Oracle.c:75:
> Callback.c: In function `Callback_BindByNameArgs':
> Callback.c:78: warning: value computed is not used
> Callback.c:79: warning: value computed is not used
> Callback.c: In function `Callback_DefineByPosArgs':
> Callback.c:123: warning: value computed is not used
> Callback.c:124: warning: value computed is not used
> Callback.c: In function `Callback_ExecuteArgs':
> Callback.c:155: warning: value computed is not used
> Callback.c:157: warning: value computed is not used
> Callback.c: In function `Callback_FetchArgs':
> Callback.c:178: warning: value computed is not used
> Callback.c: In function `Callback_PrepareArgs':
> Callback.c:203: warning: value computed is not used
> creating build/lib.linux-i686-2.4
> gcc -pthread -shared build/temp.linux-i686-2.4/cx_Oracle.o
> -L/opt/oracle/lib -lclntsh -o build/lib.linux-i686-2.4/cx_Oracle.so -s
> running install_lib
> copying build/lib.linux-i686-2.4/cx_Oracle.so ->
> /home/rmsplus/python24/lib/python2.4/site-packages
>
> [rmsplus@dksl0013 cx_Oracle-4.1]$ ../python24/bin/python
> ActivePython 2.4.1 Build 247 (ActiveState Corp.) based on
> Python 2.4.1 (#1, Jun 20 2005, 17:00:29)
> [GCC 2.95.3 20010315 (SuSE)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>  >>> import cx_Oracle
> Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
> ImportError: libclntsh.so.8.0: cannot open shared object file: No such
> file or directory
>  >>>
>
>
> Any ideas?
>
>
> Thanks
> Gustavo
>
>
>
>
> -------------------------------------------------------
> 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
>