[Zope-DB] DCOracle2 Woes

[Matthew T. Kromer]

Norfleet, Sheppard S. wrote:

>Setup:
>      python 2.1.3
>      Zope 2.6.1
>      DCOracle2 (tried both 1.2 and 1.3b)
>      Oracle 9i (9.0.1)
>      RedHat 8.0 linux
>
>      After building both versions of DCOracle2 I 
>      attempt to run install.py which fails with: unresolved symbol:
>__cmpdi2 in libclntsh9.so. I think the symbol issue actually traces back
>      to libgeneric9.a but not sure if it matters anyway. The binaries
>provided for redhat 7.1 also fail in the same way.
>
>      I attempted to get around this by installing oracle 8.1.6 just to make
>the install.py work, and it does. 
>
>      But when I switch my oracle home back to 9i and attempt to connect to
>the 9i database I get a ORA-01821 Date format error of some
>      sort, which is extremely wacky.
>
>      I have been searching for weeks to find a solution. If anyone has any
>ideas I would be greatly apprecitive.
>
>      thanks 
>
>      shep 
>
>_______________________________________________
>Zope-DB mailing list
>Zope-DB@zope.org
>http://mail.zope.org/mailman/listinfo/zope-db
>  
>

Hi Shep,

This is actually an Oracle problem, because Oracle is expecting a RedHat 
7 system, most likely.

If you look at how the Perl DBI folks do it:
  
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=oprpfvp3errgtvn8%40localhost&rnum=1&prev=/groups%3Fq%3D__cmpdi2%2Bredhat%2B9%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26selm%3Doprpfvp3errgtvn8%2540localhost%26rnum%3D1

you'll see that Oracle is linked against specific libc builds, which 
newer RedHats break.

You can either download a new Oracle install (maybe!) or trying the 
build instructions in that thread to rebuild libclntsh.so.

I was able to follow the instructions (but using gcc 3.2.2 for RedHat 9) 
and rebuild libclntsh.so so that DCOracle2 worked on my RedHat 9 system.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/