5 Replies Latest reply on Apr 22, 2011 10:27 PM by 857239

    porblems installing instant client on Mac OS X 10.4.2

      I downloaded and extracted the instant client files. and the oracle download page was very vague in what to do next. the page gave this instruction:

      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.

      4. Start your application and enjoy.

      I'm not entirely sure how to set my path, but I tried this from a unix prompt and it didn't give me an error:
      export DYLD_LIBRARY_PATH=/Users/admin/Desktop/instantclient10_1/

      but how do I start the application? I downloaded the SQL plus add in too and when I try to run that I get the following error:

      /Users/admin/Desktop/instantclient10_1/sqlplus; exit
      dyld: Library not loaded: /b/729/sqlplus/lib/libsqlplus.dylib
      Referenced from: /Users/admin/Desktop/instantclient10_1/sqlplus
      Reason: image not found
      Trace/BPT trap

      any help would be greatly appreciated. thanks
        • 1. Re: porblems installing instant client on Mac OS X 10.4.2
          Warren Tolentino
          did you get any error during installation process?
          • 2. Re: porblems installing instant client on Mac OS X 10.4.2
            I have made an installation on Mac OS X 10.4.4 (Client) and it works.

            I have copied the files from the Basic package and SQL*Plus Package into one directory.

            [dxcosx:~/instantclient] oracle% ls -l
            total 172200
            -r--r--r-- 1 oracle dba 21299 Apr 29 2004 README_IC.htm
            -r--r--r-- 1 oracle dba 1461081 Jul 5 2004 classes12.jar
            -r--r--r-- 1 oracle dba 1353 Oct 9 2003 glogin.sql
            -rwxr-xr-x 1 oracle dba 14891264 Dec 13 2004 libclntsh.dylib.10.1
            -rw-r--r-- 1 oracle dba 1516340 Nov 16 2004 libnnz10.dylib
            -rw-r--r-- 1 oracle dba 1841448 Oct 24 2004 libocci.dylib.10.1
            -rwxr-xr-x 1 oracle dba 66160096 Dec 14 2004 libociei.dylib
            -rwxr-xr-x 1 oracle dba 93028 Nov 9 2004 libocijdbc10.dylib
            -rwxr-xr-x 1 oracle dba 744612 Oct 24 2004 libsqlplus.dylib
            -r--r--r-- 1 oracle dba 1397543 Jul 5 2004 ojdbc14.jar
            -rwxr-xr-x 1 oracle dba 15660 Dec 13 2004 sqlplus

            Then the environment needs to be configured with
            setenv PATH /bin:/sbin:/usr/bin:/usr/sbin:/Volumes/Daten/Users/oracle/instantclient
            setenv SQLPATH /Volumes/Daten/Users/oracle/instantclient
            setenv DYLD_LIBRARY_PATH /Volumes/Daten/Users/oracle/instantclient
            setenv TNS_ADMIN /Volumes/Daten/Users/oracle/9iR2/orahome/network/admin

            You must change the path to your instantclient directory.

            Than you can start with

            sqlplus username@dbname

            [dxcosx:~/instantclient] oracle% sqlplus username@dbname

            SQL*Plus: Release - Production on Mon Jan 23 16:16:14 2006

            Copyright (c) 1982, 2004, Oracle. All rights reserved.

            Enter password:

            Connected to:
            Oracle9i Enterprise Edition Release - Production
            With the Partitioning, OLAP and Oracle Data Mining options
            JServer Release - Production

            • 3. Re: porblems installing instant client on Mac OS X 10.4.2
              I found that the previously suggested solutions on this did not produce the same results for me. Perhaps previous posters were using a different shell than I am. Anyway, this works for me.

              First of all, I decided I wanted to install the Oracle Instant Client and SQL*Plus in /Library/oracleinstantclient because I view these resources as being system wide, and not belonging to any particular user. I therefore created a /Library/oracleinstantclient folder at the root of my local drive, and unzipped the instantclient-basic-macosx and instantclient-sqlplus-macosx files to that folder.

              Then I created a /Library/oracleinstantclient/admin folder and copied an already customized tnsnames.ora file from another system to that folder.

              Then I opened a terminal and ran 'echo $SHELL' to see what shell I was using. The response was '/bin/bash'. I therefore decided to edit /etc/bashrc to make modifications to the base environment for all users of the system. I did so by running 'sudo vi /etc/bashrc'. If you've not used vi before, it can be a very confusing text editor. See http://www.vim.org/docs.php before trying it for the first time. Anyway, I added these lines to the end of /etc/bashrc:

              export ORACLE_HOME=/Library/oracleinstantclient
              export DYLD_LIBRARY_PATH=$ORACLE_HOME
              export TNS_ADMIN=$ORACLE_HOME/admin
              export SQLPATH=$ORACLE_HOME
              export PATH=$PATH:$ORACLE_HOME

              Then I closed the terminal and opened a new one to make sure my changes took affect. I ran 'sqlplus' and was successful.
              • 4. Re: problems installing instant client on Mac OS X 10.4.2
                I have scoured the discussion fourms and tried all of the solution that are working of other users but I cannot get SLQ plus to start. at the command lin I get the following error:dyld: Library not loaded: /b/729/sqlplus/lib/libsqlplus.dylib
                  Referenced from: /Applications/Oracle/instantclient/./sqlplus
                  Reason: image not found

                Anyone have any other ideas on how to fix this ?
                Running a PowerMac G5 with Mac OS X 10.5 Developer Beta

                • 5. Re: porblems installing instant client on Mac OS X 10.4.2
                  thanks... Mac newbee here... this solution really worked for me.