This discussion is archived
11 Replies Latest reply: Feb 24, 2009 8:40 AM by 685115 RSS

Problems with instant client

685115 Newbie
Currently Being Moderated
Dear all
I am new user and I have problem in the step 3 of install instant client:
3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On the Macintosh OSX platform, DYLD_LIBRARY_PATH is the appropriate environment variable.
I dont know how set the library loading path ........
Thanks in advance
Mac OsX 10.5.6, sql developer
  • 1. Re: Problems with instant client
    422185 Newbie
    Currently Being Moderated
    Hi,
    to make things easy, just put the libs in a standard path's directory, /usr/local/lib, for example.
    So you don't need to set the path explicitly.

    Jens
  • 2. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi jens
    I have done this but doesnt work and also all file in the path end with .dylb, the files in instant client end with 10.1; is this a problem?
    I have to put in the usr\local\lib all the file of instant client? also the .jar?
    Many thanks
    Emiliano
  • 3. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi jens
    I have done this but doesnt work and also all file in the path end with .dylb, the files in instant client end with 10.1; is this a problem?
    I have to put in the usr\local\lib all the file of instant client? also the .jar?
    Many thanks
    Emiliano
  • 4. Re: Problems with instant client
    422185 Newbie
    Currently Being Moderated
    Hi,
    my setup is like follows, and it works: The jar-files are not necessary, they ar for jdbc-connections and must go in Java's classpath. If you want make it always available without the need of putting it in a -cp option, put the jar-files to any java-extension directory, for example /Library/Java/Extensions. It works, for sure.

    /usr/local/bin:
    sqlplus
    genezi
    glogin.sql

    /usr/local/lib:
    all lib files
         libclntsh.dylib.10.1
         libnnz10.dylib
         libocci.dylib.10.1
         libociei.dylib
         libocijdbc10.dylib
         libocijdbc10.jnilib
         libheteroxa10.dylib
         libsqlplus.dylib
         libheteroxa10.jnilib
         libsqlplusic.dylib
  • 5. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi jgehrke
    I have done all as your direction but it doesnt work, I downloaded a demo of Navicat for Oracle and i set in the preferences the DYLD_LIBRARY_PATH= the folder where instant client is and it connect instantly to db.
    I dont know where I am wrong.
    Any suggestion is welcome!
    Emiliano
  • 6. Re: Problems with instant client
    422185 Newbie
    Currently Being Moderated
    Hi Emiliano,
    I've also a navicat demo running. My preferences are:
    DYLD_LIBRARY_PATH=<empty>, cause I have libs in a standard path, as described
    TNS_ADMIN=<empty>
    ORACLE_HOME=/usr/local/oracle/Database/InstantClient <- this is where the client is installed, the libs and executables are linked to the /usr/local/lib also

    sqlplus-path=/usr/local/oracle/Database/InstantClient/sqlplus

    the rest is as described. Maybe you have some unpleasant acces rights?
    I've set up all libs like this, but this might be not necessary:
    -rwxr-xr-x@ 2 <username> admin 1442316 21 Feb 2008 libsqlplusic.dylib

    Try chmod 755 to all libs and executables, it not done already.

    What exactly is your error message when trying to launch sqlplus from command line?

    Jens
  • 7. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi jens
    the error I receive is =-1.
    I tryed to reinstall all; I put instant client in /usr (that is my home in GUI), I put the prg sqldev in Application folder.
    My preferences in Navicat:
    DYLD_LIBRARY_PATH=/Users/emilianoaroasio/instantclient_10_2
    TNS_ADMIN=/Users/emilianoaroasio/instantclient_10_2
    ORACLE_HOME=/Users/emilianoaroasio/instantclient_10_2
    Navicat works fine but sqldevelopert does not work.
    Thanks a lot I am sorry but I am a Ph D Biology and I want to mine data from a large db, I use sqldev in win but I prefere to use my mac.
    Emliano

    P.S. what is the differnce between
    /Users/emilianoaroasio/instantclient_10_2 and
    /usr/local/......

    Edited by: user985641 on 19-feb-2009 9.53
  • 8. Re: Problems with instant client
    422185 Newbie
    Currently Being Moderated
    Hi Emiliano,
    -1 ? From running sqlplus? I have never seen it as an error messages. Please simply type ./sqlplus using terminal app after cd to the directory, where sqlplus is in.
    I'd like to see, what it is saying.
    Please type "ls -la" in the directory /Users/emilianoaroasio/instantclient_10_2

    Did you follow all installation steps? chmod's, ln's and so on?

    What is the difference?

    With unix, local programs and libs should be installed in a /usr/local - subdir, sometimes in /opt.
    That's why - so on MacOSX also - the /usr/local/lib and /usr/local/bin directories are in the standard search path for executables and libraries. Mostly, new "plain" programs are put directly in there, others have a link here.
    It is unlike Windows, where no such directory is around. On MacOSX, this is the tribute to UNIX standard. MacOSX applications (.app) are in an "Applications"-directory, though to be found easily. /Applications or /Users/XXX/Applications.

    Jens
  • 9. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi Jens
    the error -1 is in sqldeveloper; I run sqlplus now and I receive this in terminal:
    Last login: Tue Feb 24 09:57:22 on ttys000
    /Users/emilianoaroasio/sql\ plus/sqlplus ; exit;
    [Computer-di-EA:~] emilianoaroasio% /Users/emilianoaroasio/sql\ plus/sqlplus ; exit;
    dyld: Library not loaded: /scratch/plebld/208/rdbms/lib/libclntsh.dylib.10.1
    Referenced from: /Users/emilianoaroasio/sql plus/sqlplus
    Reason: image not found
    Trace/BPT trap
    logout

    [Processo completato]

    I have not done the command "ls -la" because I am not able to go, in terminal mode, in the directory /Users/emilianoaroasio/instantclient_10_2
    I am sorry!
    Thanks
    Emiliano
  • 10. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Hi Jens
    I resolved the problem!!!!!!!!!!!!!!!!!
    In my ethernet configuration I was using a proxy and sql dev doesnt work.
    I changed my configuration with no proxy and sql dev works fine!!!!
    Thanks a lot for the time you spent for me.
    Emiliano
    PS I have to mark this question as answered
  • 11. Re: Problems with instant client
    685115 Newbie
    Currently Being Moderated
    Thanks a lot for all

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points