FYI.....this worked fine for DBD::Oracle 1.12 also.  Many thanks to Mr.
Eisenman and Mr. Bunce for their generous help.  I truly appreciate it.

Regards,
Bill Benner

-----Original Message-----
From: Richard_Eisenman [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:11 PM
To: [EMAIL PROTECTED]
Subject: Oracle 8.1 on Solaris


The symptoms you describe (insert works OK but
core dump on exit) are identical to a problem
I experienced.

But my setup is quite a bit different. Anyway,
you might find these notes helpful:

Let me know if they help

======================
TROUBLESHOOTING DBI
1. Core dump on exit
PROBLEM:
Core dump / segmentation faults with Solaris 8 Intel, Oracle 8i 8.1.7 and
DBD::Oracle 1.07 (or 1.06).

The oracle connection seems to work OK, but get core dump on exit.

SUMMARY:
  Edit $ORACLE_HOME/lib/sysliblist, remove the
    '-lthreads' from the list

  relink Oracle with 'relink all'

  recompile and reinstall DBD

Note: Per our test, you can get away with not relinking all of Oracle if
you can just relink the file lib/libclntsh.so.8.0 with no '-lthreads'.
You cannot move back the lib/libclntsh.so.8.0 with '-lthreads' after
recompiling DBD. (Maybe its not necessary to recompile DBD again if
its already installed? But did not test that.)

You can ignore the ldflags issue if you aren't doing anything in Java.

the majority of the following comes from message posted by John E. Leon
Guerrero on 01/22/2001:

.nf
1. follow the steps for solution #1 in README.java

2. if you continue to get coredumps, check if libclntsh.so
   is still using threads "ldd $ORACLE_HOME/lib/libclntsh.so"

3. if you still find threads, then examine $ORACLE_HOME/lib/sysliblist
   if you see a "-lthread" entry, then remove it and regenerate
   libclntsh.so once again

- use oracle's relink commands to re-generate - relink all, etc
NOTE: I just did 'relink all'. That seemed to work. - [EMAIL PROTECTED]

4. verify that the new libclntsh.so does not include threads

Please note the following:

editing ldflags and sysliblist are unsupported by oracle support.


======================
Richard Eisenman
InterLinear Technology
[EMAIL PROTECTED]
510/522-5077 x213

Reply via email to