Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Perl DBI broken after 8i upgrade
Hi Ethan,
It's great that you and Jared's responses are so quick. Here are the answer
:
SHLIB_PATH=/usr/lib:/u01/app/oracle/product/8.1.7/lib:/u01/app/oracle/produc t/8.1.7/network/lib SHLIB=/usr/lib:/u01/app/oracle/product/8.1.7/lib:/u01/app/oracle/product/8.1.7/network/lib
All references to 8.0 are gone.
I will try to search more information on the specified URL
Thank you,
Thang
-----Original Message-----
Sent: Wednesday, December 19, 2001 12:02 PM
To: Thang Nguyen (E-mail)
-----Original Message-----
Sent: Wednesday, December 19, 2001 12:02 PM
To: Ethan.Post_at_ps.net
Ethan,
I don't have any experience on HP, so I can't help with any HP specific stuff.
A couple of questions:
When Perl was compiled, was 'make test' run, and did it run without error?
When building DBD::Oracle: is the newer version of Perl being used and the old one gone from PATH?
Is ORACLE_HOME set for 8i, is LD_LIBRARY_PATH set appropriately and all references to 8.0 gone from the environment?
A few posts with the same error message on other plaforms suggest a problem with the C compiler. On Solaris for instance, the std /usr/ucb/cc will not compile Perl properly.
If you ask this question on the DBI users list, someone is sure to know the anwer. You can find the list at lists.perl.com
Also, search the archives. The following URL may help: http://www.xray.mpe.mpg.de/cgi-bin/w3glimpse/dbi?query=DBD+Unable+to+interpr et+OCI+&errors=0&case=on&maxfiles=100&maxlines=30
HTH Jared
Jared (King of all Perl and Oracle)...
I have a guy I work with sitting next to me who is having some problems
with
getting DBI to work after an Oracle 8i (8.1.7 HPUX) upgrade from 8.0.6.
Everything worked fine before the upgrade. Oracle was installed in a new
home. Perl was also installed in a new location (5.6.1). He is using DBI
1.20 and attempting to install the DBD-Oracle-1.12 drivers. During
Makefile.PL compile he is hitting a "Unable to interpret Oracle oci build
commands. Using fallback approach" warning. After that pretty much
everything else goes wrong. The HPUX readme file says to add in a couple
of
options to the Perl build to get rid of dld.sl related errors. He did that
but is still getting errors for the dld.sh library. It says "Can't
shl_load() a library containing Thread Storage: /usr/libt/base....FAILED
tests 4-5" and then a bunch more errors related to this. The Perl
installation was installed after the Oracle upgrade. An earlier version of
Perl was alrady installed but was generating core dumps. The initial
solution was to upgrade Perl.
I can post log files and such if you want. Would really appreciate some pointers on this one. Internet searches have not turned up much.
Thanks,
Ethan Post
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: Ethan.Post_at_ps.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Dec 19 2001 - 13:01:42 CST
![]() |
![]() |