1 2 Previous Next 24 Replies Latest reply: May 2, 2006 10:37 AM by 131942 RSS

    no ocijdbc10 in java.library.path

    104832
      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
          Ronald Rood
          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
            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
              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
                Bump!! Still having the problem-any ideas?
                • 5. Re: no ocijdbc10 in java.library.path
                  437216
                  Have you tried setting DYLD_LIUBRARY_PATH?

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

                    DYLD_LIBRARY_PATH
                    • 7. Re: no ocijdbc10 in java.library.path
                      104832
                      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
                        Ronald Rood
                        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
                          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
                            Ronald Rood
                            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
                              Ronald Rood
                              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
                                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
                                  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
                                    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