wls6.1 oracle 8.1.6 connection pool

polo

unread,

Feb 2, 2002, 6:41:27 AM2/2/02

to

In win2K ,weblogic 6.1sp1,oracle 8.1.6 two computer
one is app server, name:server
one is db server, name:database
I have success in
java utils.dbping ORACLE_THIN .......
now, I create a connection pool like
in config.xml
<JDBCConnectionPool DriverName="weblogic.jdbc.oci.Driver"
Name="MyJDBC Connection Pool"

Properties="user=administrator;password=winchannel;server=database:1521:winc
hdb"
Targets="myserver" TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false" TestTableName="lin"
URL="jdbc:weblogic:oracle"/>

when start the server,the exception is

<2002-2-2 > <Notice> <Management> <Starting discovery of Managed
Server... This feature is on by default, you may turn this off by
passing -Dweb
logic.management.discover=false>
Starting Loading jDriver/Oracle .....
<2002-2-2 > <Error> <JDBC> <Cannot startup connection pool "MyJD
BC Connection Pool" weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: System.loadLibrary(weblogicoci37) threw
java.lang.Unsatis
fiedLinkError: no weblogicoci37 in java.library.path
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:226)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Con
nectionEnvFactory.java:192)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Con
nectionEnvFactory.java:134)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllo
cator.java:698)

how can i do

Jim Clark

unread,

Feb 2, 2002, 8:17:49 PM2/2/02

to

take a look at:
http://edocs.bea.com/wls/docs61/oracle/install_jdbc.html#1064104

Basically you need to add the Oracle JDriver dll to your path. It should
look something like
path=%path%;c:\bea\wlserver6.1\bin\oci816_8

Jim

"polo" <l...@post.pim.tsinghua.edu.cn> wrote in message
news:3c5b...@newsgroups.bea.com...

Jim Clark

unread,

Feb 2, 2002, 8:18:03 PM2/2/02

to

take a look at:
http://edocs.bea.com/wls/docs61/oracle/install_jdbc.html#1064104

Basically you need to add the Oracle JDriver dll to your path. It should
look something like
path=%path%;c:\bea\wlserver6.1\bin\oci816_8

Jim

"polo" <l...@post.pim.tsinghua.edu.cn> wrote in message
news:3c5b...@newsgroups.bea.com...

polo

unread,

Feb 2, 2002, 11:36:00 PM2/2/02

to

later ,I change from wls6.1 to wls6.2,
and I add all those path
but there are another error ora 24327
do i need
modify server=database:1521:winc
to server=XXXXX;XXX is a alias in tnsnames.ora

"Jim Clark" <jim....@idea.com> wrote in message
news:3c5c...@newsgroups.bea.com...

Deepak Vohra

unread,

Feb 3, 2002, 9:12:37 PM2/3/02

to

Add /weblogic/bin/oci817_8 & oracle/ora81/lib to
PATH environment variable.

Deepak Vohra

unread,

Feb 3, 2002, 9:16:12 PM2/3/02

to

polo

Add /weblogic/bin/oci816_8 & oracle/ora81/lib to
PATH environment variable.

Deepak

Deepak Vohra

unread,

Feb 3, 2002, 9:25:38 PM2/3/02

to

winchdb as the Database in tnsnames.ora
In Jdbc Configuration
properties
specify
user=<user>
password=<password>
server=winchdb