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

Dismiss

Oracle 9i Personal Edition

0 views

Skip to first unread message

David Roytenberg

unread,

Jan 7, 2002, 11:30:44 AM1/7/02

Hi all,

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