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: export from linux

Re: export from linux

From: <davide_at_yahoo.com>
Date: 4 Apr 2002 14:08:49 GMT
Message-ID: <a8hmph$s3gf4$1@ID-18487.news.dfncis.de>


s Lehaire <s.lehaire_at_meilleuregestion.com> wrote:
> I can imagine that ORACLE_HOME is the path of the insttal of Oracle but I
> don't see what is the ORACLE_SID

The ORACLE_SID is the name of the SID (service) you want to talk with. You should be able to see that in $ORACLE_HOME/network/admin/tnsnames.ora

> loading shared libraries: libclntsh.so.1.0: cannot open shared object file:
> No such file or directory

Probabily the Oracle client have not been installed using the default installer, so you have to setup also the LD_LIBRARY_PATH to point to the $ORACLE_HOME/lib directory.

export ORACLE_HOME=where/oracle/is/installed export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

Check in $ORACLE_HOME/network/admin/tnsnames.ora which SID you want to talk with.

Then you should be able to use

exp <username>/<password>@<sidname>

Ask also to the system administrator.

Davide Received on Thu Apr 04 2002 - 08:08:49 CST

Original text of this message

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