I am trying to set up a WLS/WLI development environment on my
home Windows 2000 machine. I have installed WLS 6.0 SP2 and
successfully used JDBC to connect to the Cloudscape database.
Now I am trying to get up and running with Oracle. I have installed
the Oracle 9i Personal edition and am trying to deploy an Oracle
connection
pool.
First of all, is there any reason to think that using Personal vs
Standard or
Enterprise edition should prevent connections from succeeding?
Second, has anyone succeeded in connecting to 9i using the oci817
DLL?
I've included a transcript of the error I'm getting at deployment
time below.
Thanks for any insight.
Regards,
David Roytenberg
The error I am getting while trying to deploy my connection pool is
as follows:
Starting Loading jDriver/Oracle .....
---------- LOGIN ERROR CODE: 24327
---------- LOGIN ERROR CODE: 24327
<Jan 7, 2002 11:20:45 AM EST> <Error> <JDBC Connection
Pool> <Cannot startup connection pool "oracle
Pool" weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver
exception was:
java.sql.SQLException: ORA-24327: need explicit attach
before authenticating a user - (scott/*******
*@localhost)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
at
weblogic.jdbcbase.oci.Driver.connect(Driver.java:92)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.ja
va:158)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.ja
va:114)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:653)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:261)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:695)
at
weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:108)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:32
7)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:2
77)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarg
et.java:232)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.jav
a:192)
at java.lang.reflect.Method.invoke(Native
Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:28
5)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy41.updateDeployments(Unknown Source)
at
weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_C
achingStub.java:2299)
at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManage
r.java:240)
at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:122)
at java.lang.reflect.Method.invoke(Native
Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:28
5)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy35.start(Unknown Source)
at
weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationMa
nagerMBean_CachingStub.java:435)
at
weblogic.management.Admin.startApplicationManager(Admin.java:1033)
at
weblogic.management.Admin.finish(Admin.java:493)
at
weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at
weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.ja
va:173)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.ja
va:114)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java:653)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java:261)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:695)
at
weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:108)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:32
7)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:2
77)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarg
et.java:232)
at
weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.jav
a:192)
at java.lang.reflect.Method.invoke(Native
Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:28
5)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy41.updateDeployments(Unknown Source)
at
weblogic.management.configuration.ServerMBean_CachingStub.updateDeployments(ServerMBean_C
achingStub.java:2299)
at
weblogic.management.mbeans.custom.ApplicationManager.startConfigManager(ApplicationManage
r.java:240)
at
weblogic.management.mbeans.custom.ApplicationManager.start(ApplicationManager.java:122)
at java.lang.reflect.Method.invoke(Native
Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:562)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:548)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:28
5)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:439)
at
weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:180)
at $Proxy35.start(Unknown Source)
at
weblogic.management.configuration.ApplicationManagerMBean_CachingStub.start(ApplicationMa
nagerMBean_CachingStub.java:435)
at
weblogic.management.Admin.startApplicationManager(Admin.java:1033)
at
weblogic.management.Admin.finish(Admin.java:493)
at
weblogic.t3.srvr.T3Srvr.start(T3Srvr.java:429)
at
weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:170)
at weblogic.Server.main(Server.java:35)
>
<Jan 7, 2002 11:21:05 AM EST> <Notice>
<WebLogicServer> <WebLogic Server started>
<Jan 7, 2002 11:21:05 AM EST> <Notice>
<WebLogicServer> <ListenThread listening on port 7001>
<Jan 7, 2002 11:21:05 AM EST> <Notice>
<WebLogicServer> <SSLListenThread listening on port 7002>
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
The WLS OCI driver does not support Oracle 9i. See
http://edocs.bea.com/wls/platforms/index.html#jdbc for details on what dbms's are supported.
If you really need to use this db then check with Oracle for a type 4 JDBC driver. The above
link also details qualifications for 3rd party JDBC drivers that should work with WLS.
Hope this helps,
Michael
David Roytenberg wrote:
--
Michael Young
Developer Relations Engineer
BEA Support