Connection Pool :Error

[Anand Kuwadia]

While trying to create a connection pool in weblogic6.1 using the following configuration settings
URL jdbc.weblogic.oracle
Driver Classname weblogic.jdbc.oci.Driver
properties user-...
server-...
passwd ...
I am not able to create an active connection pool
I get the following error
java.lang.reflect.InvocationTargetException: weblogic.management.DistributedManagementException: Distributed Management [1 exceptions]
Can any one help
Anand

[Ajith Kallambella]

Moving this discussion to BEA/WebLogic forum.....

[Chris Mathews]

There is some configuration involved when using the JDriver. Take a look at this document: Installing WebLogic jDriver for Oracle.
If you still can't get it to work then write back and I go step by step.

[Anand Kuwadia]

hi,Chris
I have followed all the steps in proper order,yet I am getting some errors
Let me List the steps I have followed
I have Win NT m/c with Oracle 8.1.6.0.0 and bea weblogic server6.1
1] I have set the System Path to include the directory that contains my driver
i.e I have included
c:\bea\wlserver6.1\bin\oci817_8
in my path.
2] Also I have included the directory in which vendor-supplied libraries from Oracle reside

D:\Oracle\Ora81\bin
3] Also included the following in System Classpath for weblogic files
C:\bea\wlserver6.1\lib\weblogic.jar
4] Have Put the 2 files tnsnames.ora and listener.ora reqd by oracle(With appropriate descriptors) in Ora\admin\..
5] Tried to create a connection Pool through Weblogic Console(With proper configuration details)

But got the error

Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating a user


Please Help
Anand

[Chris Mathews]

Originally posted by Anand Kuwadia:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating a user

This means that you database connection information for Oracle (in tnsnames.ora and/or sqlnet.ora) is wrong. Do a tnsping from commandline on the Oracle SID you are trying to connect to from WebLogic. Most likely it will fail. Resolve that issue and you should be set.