This content has been marked as final. Show 11 replies
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.
all lib files
I've also a navicat demo running. My preferences are:
DYLD_LIBRARY_PATH=<empty>, cause I have libs in a standard path, as described
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
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?
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:
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.
P.S. what is the differnce between
Edited by: user985641 on 19-feb-2009 9.53
-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.
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
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!