Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Perl DBI broken after 8i upgrade

Perl DBI broken after 8i upgrade

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Wed, 19 Dec 2001 11:01:42 -0800
Message-ID: <F001.003E0715.20011219104029@fatcity.com>

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
LD_LIBRARY_PATH=/usr/lib:/u01/app/oracle/product/8.1.7/lib:/u01/app/oracle/p roduct/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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US