Re: [cx-oracle-users] Segmentation Fault

[Anthony T. <an...@co...>]

No idea. I know that Oracle is planning a stripped down version of the
Oracle client (with a minimal number of files like you have here) for
10g so when that is released you might want to take a look at it and see
if you can't do the same for Oracle 9i.

I can give a couple of suggestions for things that I would try but no
guarantees that any of this will work. :-)

1) Execute ldd on the binaries and make sure that there are no missing
libraries.

2) Run strace on your program and see whether that gives you any useful
information (such as files it is attempting to open but can't find, for
example)

3) Take a full client installation and continue paring files away until
you find the minimal set that works.

Have fun... :-)

On Thu, 2003-12-18 at 04:19, Antonio Beamud Montero wrote:
> Hi all:
> I'm developing some python utilities and this utilities need to get/set
> information from a Oracle D.B.
> I have packed the oracle client libraries in a RPM with this files:
> 
> /opt/oracle/client_libs/lib/libclntsh.so.9.0
> /opt/oracle/client_libs/lib/libwtc9.so
> /opt/oracle/client_libs/network/admin/tnsnames.ora
> /opt/oracle/client_libs/oracore/zoneinfo/timezlrg.dat
> /opt/oracle/client_libs/oracore/zoneinfo/timezone.dat
> /opt/oracle/client_libs/rdbms/mesg/bbede.msb
> /opt/oracle/client_libs/rdbms/mesg/bbedus.msb
> /opt/oracle/client_libs/rdbms/mesg/bbedus.msg
> /opt/oracle/client_libs/rdbms/mesg/dbve.msb
> /opt/oracle/client_libs/rdbms/mesg/dbvus.msb
> /opt/oracle/client_libs/rdbms/mesg/dbvus.msg
> /opt/oracle/client_libs/rdbms/mesg/expe.msb
> /opt/oracle/client_libs/rdbms/mesg/expus.msb
> /opt/oracle/client_libs/rdbms/mesg/expus.msg
> /opt/oracle/client_libs/rdbms/mesg/impe.msb
> /opt/oracle/client_libs/rdbms/mesg/impus.msb
> /opt/oracle/client_libs/rdbms/mesg/impus.msg
> /opt/oracle/client_libs/rdbms/mesg/kgpe.msb
> /opt/oracle/client_libs/rdbms/mesg/kgpus.msb
> /opt/oracle/client_libs/rdbms/mesg/kgpus.msg
> /opt/oracle/client_libs/rdbms/mesg/kope.msb
> /opt/oracle/client_libs/rdbms/mesg/kopus.msb
> /opt/oracle/client_libs/rdbms/mesg/kopus.msg
> /opt/oracle/client_libs/rdbms/mesg/kupe.msb
> /opt/oracle/client_libs/rdbms/mesg/kupus.msb
> /opt/oracle/client_libs/rdbms/mesg/kupus.msg
> /opt/oracle/client_libs/rdbms/mesg/lcde.msb
> /opt/oracle/client_libs/rdbms/mesg/lcdus.msb
> /opt/oracle/client_libs/rdbms/mesg/lcdus.msg
> /opt/oracle/client_libs/rdbms/mesg/mige.msb
> /opt/oracle/client_libs/rdbms/mesg/migus.msb
> /opt/oracle/client_libs/rdbms/mesg/migus.msg
> /opt/oracle/client_libs/rdbms/mesg/nide.msb
> /opt/oracle/client_libs/rdbms/mesg/nidus.msb
> /opt/oracle/client_libs/rdbms/mesg/nidus.msg
> /opt/oracle/client_libs/rdbms/mesg/ocie.msb
> /opt/oracle/client_libs/rdbms/mesg/ocius.msb
> /opt/oracle/client_libs/rdbms/mesg/ocius.msg
> /opt/oracle/client_libs/rdbms/mesg/opwe.msb
> /opt/oracle/client_libs/rdbms/mesg/opwus.msb
> /opt/oracle/client_libs/rdbms/mesg/opwus.msg
> /opt/oracle/client_libs/rdbms/mesg/orae.msb
> /opt/oracle/client_libs/rdbms/mesg/oraus.msb
> /opt/oracle/client_libs/rdbms/mesg/oraus.msg
> /opt/oracle/client_libs/rdbms/mesg/qsme.msb
> /opt/oracle/client_libs/rdbms/mesg/qsmus.msb
> /opt/oracle/client_libs/rdbms/mesg/qsmus.msg
> /opt/oracle/client_libs/rdbms/mesg/rmane.msb
> /opt/oracle/client_libs/rdbms/mesg/rmanus.msb
> /opt/oracle/client_libs/rdbms/mesg/rmanus.msg
> /opt/oracle/client_libs/rdbms/mesg/sbte.msb
> /opt/oracle/client_libs/rdbms/mesg/sbtus.msb
> /opt/oracle/client_libs/rdbms/mesg/sbtus.msg
> /opt/oracle/client_libs/rdbms/mesg/ule.msb
> /opt/oracle/client_libs/rdbms/mesg/ulus.msb
> /opt/oracle/client_libs/rdbms/mesg/ulus.msg
> 
> and export ORACLE_HOME=/opt/oracle/oraclient_libs/
> export LD_LIBRARY_PATH=/opt/oracle/oraclient/libs/lib
> 
> And all seems to work, but If I get a cursor, execute an "INSERT INTO
> publicity ..." query and a "SELECT * FROM publicity", the insert is ok,
> but the select give me a segmentation fault...
> Need I other libraries?
> When I installed the full oracle client all works correctly...
> 
> P.D: I'm using SuSE 8.0.
> 
> Thanks.
-- 
Anthony Tuininga
an...@co...
 
Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com