This content has been marked as final. Show 5 replies
did you get any error during installation process?
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
-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
[dxcosx:~/instantclient] oracle% sqlplus username@dbname
SQL*Plus: Release 10.1.0.3.0 - Production on Mon Jan 23 16:16:14 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Oracle9i Enterprise Edition Release 18.104.22.168.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 22.214.171.124.0 - Production
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:
Then I closed the terminal and opened a new one to make sure my changes took affect. I ran 'sqlplus' and was successful.
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
thanks... Mac newbee here... this solution really worked for me.