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
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.
Joined: Jan 08, 2003
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 18.104.22.168.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
Joined: Jul 18, 2001
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.