11 Replies Latest reply: Feb 24, 2009 10:40 AM by 685115 RSS

    Problems with instant client

    685115
      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
          jgehrke
          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
            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
              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
                jgehrke
                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
                  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
                    jgehrke
                    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
                      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
                        jgehrke
                        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
                          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
                            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
                              Thanks a lot for all