This content has been marked as final. Show 24 replies
The file libocijdbc10.dylib should be in $OH/lib/. Is it present ?
I remember having fiddled with a few libs to get it to work.
neilkodG4:/u01/app/oracle/product/10.1.0/lib oracle$ pwd
neilkodG4:/u01/app/oracle/product/10.1.0/lib oracle$ ls -l libocijdbc10.dylib
-rw-r--r-- 1 oracle oinstall 93028 18 Feb 16:32 libocijdbc10.dylib
The file is there, permissions look ok, its in my $LD_LIBRARY_PATH, things look to be set correctly. Any other suggestions?
Here's a little more info on my environment
neilkodG4:/u01/app/oracle/product/10.1.0/lib oracle$ ls -l $LD_LIBRARY_PATH/*oci*
-rwxr-xr-x 1 oracle oinstall 70640 18 Feb 16:34 /u01/app/oracle/product/10.1.0/lib/libnmeoci.dylib
-rw-r--r-- 1 oracle oinstall 0 19 May 2004 /u01/app/oracle/product/10.1.0/lib/libnmeoci.dylib.0
-rw-r--r-- 1 oracle oinstall 93028 18 Feb 16:32 /u01/app/oracle/product/10.1.0/lib/libocijdbc10.dylib
-rw-r--r-- 1 oracle oinstall 93028 18 Feb 16:32 /u01/app/oracle/product/10.1.0/lib/libocijdbc10.jnilib
-rw-r--r-- 1 oracle oinstall 113264 24 Oct 08:22 /u01/app/oracle/product/10.1.0/lib/libocijdbcst10.a
Bump!! Still having the problem-any ideas?
Have you tried setting DYLD_LIUBRARY_PATH?
Fat fingered it!
its set to
do you have a stripped down version of your code and makefile available ? Maybe we can reproduce it.
Stringe thing is, you say you use OCI and the missing lib is a java lib. Do you also use jdbc ?
Ronald, for what its worth, I've dropped/re-installed the oracle client many times on this machine, all with the same results.
JDBC apps work fine. I'm trying different IDEs like aqua data studio, etc. I'd prefer to connect via OCI because its a lot faster than JDBC.
As far as the code/makefile, I haven't had to touch it, i'm just using whatever came with the 10g OSX client and server cds.
Interestingly enough, sqlplus connects fine. I can't get any other 3rd party query apps to run via OCI. JDBC is too slow for my needs.
you are trying a fat jdbc connection. I thought you created an oci application ...
How does the connect string look like ?
I don't remember having it tested or not, for me thin jdbc is most of the times fast enough.
What happens if you put classes12.zip first in CLASSPATH ?
Nothing happened when I changed the order of my classpath.
Here's what I'm trying to accomplish-I'm trying to evaulate the various 3rd party Interfaces to oracle -I'm looking for something on OSX which gives me the performance of Toad on windows. I'm finding JDBC connections to be too slow for my taste, so I'm trying to connect via OCI.
So far, I've looked at Aqua Data Studio, and a couple of other SQL tools from versiontracker.
Any help would be appreciated!!
At the url:
Try performing steps 1 and 2 (change the syntax since it is for windows). I just did those two steps and could successfully connect. no more of this error:
java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
I'm running Oracle10g on Red Hat Fedora Core 4. I got this error when I used /bea/weblogic81/common/bin/quickstart.sh to try to configure a WebLogic 8.1 server for Oracle. My .bash_profile looks like this:
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
# User specific environment and startup programs
# export PATH=$PATH:$HOME/bin
# lines below added 2005-07-07 for running Oracle
# this actually should have been set by .bashrc -> /etc/bashrc
if [ $LD_LIBRARY_PATH ]; then
# Set the classpath to include the JDBC driver
if [ $CLASSPATH ]; then
# end 2005-07-07 additions
however env | grep "PATH" doesn't list LD_LIBRARY_PATH, so evidently something's unset-ting it.
After entering LD_LIBRARY_PATH from the shell (Emacs: Alt-x shell), I tried it again, and it worked.
I'd previously started oracle:
and verified via a Java JDBC program that I could "select sysdate from dual".