no weblogicoci37 in java.library.path (Solaris 9, WLS 6.1)

Holger Wienecke

unread,

Aug 19, 2004, 7:58:43 AM8/19/04

to

Hello All,

I'm struggling with JDBC connection pools and data sources.

Remote DB's properties:
Username: TCINT
Password: *****
DB Server:hpdcx100

To figure out what's going wrong, I thought of using dbping to check if the jdbc connect will work, with the following results:

$ echo $LD_LIBRARY_PATH
/apps/Weblogic/wwws/wls61sp5/lib/solaris:/opt/SUNWspro/lib:/usr/openwin/lib
$ echo $CLASSPATH
/apps/Weblogic/wwws/wls61sp5/lib/weblogic.jar:/apps/Weblogic/wwws/wls61sp5
$ java utils.dbping ORACLE TCINT tcint hpdcx100
Starting Loading jDriver/Oracle .....

Error encountered:

java.sql.SQLException: System.loadLibrary(weblogicoci37) threw java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:243)
at weblogic.jdbc.oci.Driver.connect(Driver.java:79)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at utils.dbping.main(dbping.java:167)
$

Do you folks can explain what went wrong?

Thank you in advance,

Holger

Hussein Badakhchani

unread,

Aug 20, 2004, 9:31:25 AM8/20/04

to

Here is a segment of my LD_LIBRARY_PATH

:/bea/wlserver8.1sp1/wlserver8.1/server/lib/solaris/oci920_8

We are using Weblogic 8.1 and Oracle, looks like you may be missing that bit.

Look under

/bea/wlserver8.1sp1/wlserver8.1/server/lib/solaris/

(or similar directory for oracle libs)

Hope this helps.

Hussein Badakhchani

unread,

Aug 20, 2004, 9:40:58 AM8/20/04

to

Also check the permissions of the oracle lib files, they should be executable by your weblogic user.

Hussein Badakhchani

unread,

Aug 20, 2004, 9:51:52 AM8/20/04

to

Sorry about the quick fire answers, here is a bit more detail.

1) check your LD_LIBRARY_PATH is correct, under

/apps/Weblogic/wwws/wls61sp5/lib/solaris

you should see the file weblogicoci37.so and it should be executable, if that file is missing look for it and add the path to it to your LD_LIBRARY_PATH. (On out server the orcle libs are in their own directory check yours).

This should be enough to fix your problem if not

2) Check your startup scripts java.library.path and set it approriately e.g.

java -Djava.library.path=/apps/Weblogic/wwws/wls61sp5/lib/solaris

bodapati

unread,

Aug 20, 2004, 5:05:04 PM8/20/04

to

Make sure you have

<WLS_HOME>/wlserver6.1/bin/oci817_8

in LD_LIBRARY_PATH.

And ensure ORACLE_HOME exported.

Holger Wienecke

unread,

Aug 20, 2004, 7:36:26 PM8/20/04

to

Hello All,

thanks you all for the effort, but non of the tips & hints didn't helped.

On a different machine I also introduced the Oracle Lib directory to the LD_LIBRARY_PATH and then used ORACLE_THIN instead of ORACLE - now it works!

(See snipped at the end of posting)

Unfortunately, on the site where I had the problems, oracle runs on a different machine and therefore on no oracle libraries are installed on the WLS machine ...

Any ideas from your side?

Regards,
Holger

>8->8->8->8->8->8->8->8->8->8->8->8->8->8->8->8->8-

$ echo $CLASSPATH
/opt/apps/bea/wls61sp5/wlserver6.1/lib/weblogic.jar:/opt/apps/bea/wls61sp5/

$ echo $LD_LIBRARY_PATH
/opt/apps/bea/wls61sp5/wlserver6.1/lib/solaris:/opt/SUNWspro/lib:/usr/openwin/lib:/opt/apps/ora9/lib/

$ java utils.dbping ORACLE_THIN INTDB oracle zrhxsrvsun1:1521:TC40

**** Success!!! ****