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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Using SQL Loader with Oracle Instant Client

Re: Using SQL Loader with Oracle Instant Client

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 28 Jun 2007 07:50:03 -0700
Message-ID: <1183042203.473254.66580@u2g2000hsc.googlegroups.com>


On Jun 28, 4:26 pm, fd96..._at_yahoo.com wrote:
> Hi,
>
> We are trying to use oracle SQL loader with oracle instant client
> (10g) on solaris boxes.
>
> After copying the files to the solaris box and setting the class path,
> if we try to run sqlldr, then we get the following error:
> ld.so.1: sqlldr: fatal: libm.so.2: open failed: No such file or
> directory
>
> Instant client was downloaded from oracle site, installed it on a box
> with solaris version 9 and sqlldr was from an installation on solaris
> box with version 10.
>
> Please let me know if any one has faced this issue in the past.
>
> Thanks

At a minimum (as it looks like you simply copied sqlldr into the bin directory of the instant client) you would need to relink sqlldr. I'm curious why you think you can combine binaries from two different versions of Oracle and two different versions of Solaris without relinking.
I would also like to stress you need to verify from the docs (or any other Oracle site) sqlldr actually does work with the instant client. I seem to recall these utilities were excluded.

--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jun 28 2007 - 09:50:03 CDT

Original text of this message

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