This discussion is archived
1 2 Previous Next 24 Replies Latest reply: May 2, 2006 8:37 AM by 131942 RSS

no ocijdbc10 in java.library.path

104832 Newbie
Currently Being Moderated
I've installed 10g client on 10.3.8. Anytime I try to connect using OCI, I get
the "no ocijdbc10 in java.library.path". I believe my environment has been installed correctly:

neilkodG4:~ neilkodner$ echo $ORACLE_BASE
/u01/app/oracle
neilkodG4:~ neilkodner$ echo $ORACLE_HOME
/u01/app/oracle/product/10.1.0
neilkodG4:~ neilkodner$ echo $LD_LIBRARY_PATH
/u01/app/oracle/product/10.1.0/lib

What else do I need to use OCI apps? In the unix/linux world, setting the above 3 environment vars usually is enough.
  • 1. Re: no ocijdbc10 in java.library.path
    RonaldRood Oracle ACE
    Currently Being Moderated
    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.

    Ronald
    http://homepage.mac.com/ik_zelf/oracle
  • 2. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    neilkodG4:/u01/app/oracle/product/10.1.0/lib oracle$ pwd
    /u01/app/oracle/product/10.1.0/lib
    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?
  • 3. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    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

  • 4. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    Bump!! Still having the problem-any ideas?
  • 5. Re: no ocijdbc10 in java.library.path
    437216 Newbie
    Currently Being Moderated
    Have you tried setting DYLD_LIUBRARY_PATH?

  • 6. Re: no ocijdbc10 in java.library.path
    437216 Newbie
    Currently Being Moderated
    Fat fingered it!

    DYLD_LIBRARY_PATH
  • 7. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    its set to
    /u01/app/oracle/product/10.1/lib32:/u01/app/oracle/product/10.1/lib:/u01/app/oracle/product/10.1/perl/lib:/u01/app/oracle/product/10.1/lib
  • 8. Re: no ocijdbc10 in java.library.path
    RonaldRood Oracle ACE
    Currently Being Moderated
    Hi Neil,

    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 ?

    regards,
    Ronald.
  • 9. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    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.
  • 10. Re: no ocijdbc10 in java.library.path
    RonaldRood Oracle ACE
    Currently Being Moderated
    Hi Neil,

    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.

    regards,
    Ronald.
    http://ciber.nl
    http://ronr.nl/unix-dba
  • 11. Re: no ocijdbc10 in java.library.path
    RonaldRood Oracle ACE
    Currently Being Moderated
    What happens if you put classes12.zip first in CLASSPATH ?

    Ronald.
    http://ronr.nl/unix-dba
  • 12. Re: no ocijdbc10 in java.library.path
    104832 Newbie
    Currently Being Moderated
    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!!
  • 13. Re: no ocijdbc10 in java.library.path
    27876 Newbie
    Currently Being Moderated
    At the url:

    http://www.oracle.com/technology/sample_code/tech/streams/streamsmessaging/install.html#Deploy

    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
  • 14. Re: no ocijdbc10 in java.library.path
    3943 Newbie
    Currently Being Moderated
    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:

    ----------------------------------
    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
         . ~/.bashrc
    fi

    # 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
    umask 022

    export ORACLE_BASE=/oracle
    export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/Db_1
    export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
    export ORACLE_SID=ora10g

    if [ $LD_LIBRARY_PATH ]; then
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib:$ORACLE_HOME/ctx/lib
    else
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib:$ORACLE_HOME/ctx/lib
    fi

    # Set the classpath to include the JDBC driver
    if [ $CLASSPATH ]; then
    export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/ojdbc14.jar
    else
    export CLASSPATH=.:$ORACLE_HOME/jdbc/lib/ojdbc14.jar
    fi

    # end 2005-07-07 additions


    unset USERNAME
    ----------------------------------

    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:
    dbstart
    lsnrctl start

    and verified via a Java JDBC program that I could "select sysdate from dual".
1 2 Previous Next