Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problems testing a Connection to the OCI8 Driver for Oracle 8.1.7 from the Command Line

0 views
Skip to first unread message

Ricardo De la Rosa

unread,
Sep 16, 2002, 12:32:37 PM9/16/02
to

Hello,

I am configuring a JDBC Connection to an Oracle 8.1.7 from WebLogic 7.0.0. I want
to use an OCI driver.

When I am testing the driver, I execute the command (From DOS console in Win 2k
Professional):

java utils.dbping ORACLE myUser myPassword myDB

But it produces the next error:
________
Error encountered:

java.sql.SQLException: System.loadLibrary(weblogicoci38) threw java.lang.Unsatis
fiedLinkError: C:\bea\weblogic700\server\bin\oci817_8\weblogicoci38.dll: No se
e
ncontr¾ el proceso especificado
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:218)
at weblogic.jdbc.oci.Driver.connect(Driver.java:94)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at utils.dbping.main(dbping.java:175)
___________
Also, a window appears and displays the next message:
"It does not find the entry point to procedure OCILobLocatorAssign" in the dll
OCI.dll"

My environment variable PATH is defined as follows:
Path=C:\bea\weblogic700\server\bin;
C:\bea\jdk131_02\bin;C:\bea\weblogic700\server\bin\oci817_8; C:\orant\bin;C:\local\bin;c:\DMI\WIN32\BIN;H:\AURORA\BIN;C:\WINDOWS;
C:\WINDOWS\system32;C:\WINDOWS\system32\WBEM

Can you help me !

In advance thanks !

- Ricardo (Bogota-Colombia-South America).

Sree Bodapati

unread,
Sep 16, 2002, 1:15:34 PM9/16/02
to
Hi Ricardo,

You need to have a environment variable ORACLE_HOME set and then make sure
you have "%WL_HOME%\bin\oci817_8; %ORACLE_HOME%\bin;ORACLE_HOME%\lib" in the
path .

(replace WL_HOME with what ever your path to the WLS bin folder is)

hth
sree

"Ricardo De la Rosa" <rdla...@yahoo.com> wrote in message
news:3d86...@newsgroups.bea.com...

Ricardo De la Rosa

unread,
Sep 17, 2002, 10:35:39 AM9/17/02
to

Sree,

In this moment I don't have an environment variable ORACLE_HOME, and I have two
candidate directories to be the value of this variable: The first candidate directory
is C:\orant, and C:\orant\bin exists but C:\orant\lib doesn't exist.

The second candidate is C:\local; and C:\local\bin exists, but C:\local\lib doesn't
exist, and C:\local\oci80\lib\borland\oci.lib & and C:\local\oci80\lib\borland\ociw32.lib
and C:\local\oci80\lib\msvc\oci.lib & and C:\local\oci80\lib\msvc\ociw32.lib

I tested the conection with both candidates but it doesn't work with anyone.

Sree, do you know what happen ??

Thank you !!
- Ricardo (Colombia-South America).

Sree Bodapati

unread,
Sep 17, 2002, 10:48:20 PM9/17/02
to
Do you see a folder lib32 instead. Otherwise you will have to install Oracle
client on the machine to use OCI.

sree

"Ricardo De la Rosa" <rdla...@yahoo.com> wrote in message

news:3d873dbb$1...@newsgroups.bea.com...

0 new messages