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

ORA-24327 ERROR JOracle driver

0 views
Skip to first unread message

Mike

unread,
Jun 6, 2002, 11:30:03 AM6/6/02
to
Hello,

I'm using wls 6.1 and trying to create an connection pool to an oracle 8i
database using weblogic.jdbc.oci.Driver. I've read over the document and I
think that my classpath and path are fine in the startup script. Does
anyone know how to resolve this problem. Below are parts of my startup
script and error.

Here what i'm entering for my connetion pool.

url: jdbc:weblogic:oracle:@****:****:dev1
Driver class weblogic.jdbc.oci.Driver
Properties user=****
password=****
dll=weblogicoci37


Start Script
set PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\;.\bin;%PATH%
set
CLASSPATH=.;.\lib\weblogic_sp.jar;.\lib\weblogic.jar;%WL_HOME%\oracle\classe
s;.\lib\ejb20_DemoADLSCEntities.jar;%TL40CLASSES%

Error

Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating
a user - (******/********@@******:*****:dev1)
at weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:164)
at weblogic.jdbc.oci.Driver.connect(Driver.java:112)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.java:193)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:134)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j
ava:698)
at weblogic.common.internal.ResourceAllocator.(ResourceAllocator.java:282)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:623
)
at weblogic.jdbc.common.JDBCService.addDeployment(JDBCService.java:107)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:329)
at
weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentT
arget.java:144)
at java.lang.reflect.Method.invoke(Native Method)
at
weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl
.java:636)
at
weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:6
21)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:359)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1555)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at
weblogic.management.internal.ConfigurationMBeanImpl.updateConfigMBeans(Confi
gurationMBeanImpl.java:491)
at
weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBea
nImpl.java:361)
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:468)


thanks

Mike

Joseph Weinstein

unread,
Jun 6, 2002, 1:19:36 PM6/6/02
to Mike
Hi. Do you have your ORACLE_HOME environment variable set correctly?
Please check the entry in your tnsnames.ora file (below ORACLE_HOME)
and verify if the server you define in your URL is correct. IN fact, show
me the tnsnames entry name for the DBMS you want, and show me the
whole URL you are giving the pool.
Joe

Mike

unread,
Jun 6, 2002, 2:02:32 PM6/6/02
to

"Mike" <mcle...@hotmail.com> wrote in message
news:3cff...@newsgroups2.bea.com...

Mike

unread,
Jun 6, 2002, 3:01:20 PM6/6/02
to
Here is my tsnnams

DEV1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = conradb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev1)
)
)

Here's my connection pool info

url jdbc:weblogic:oracle:@conradb:1521:dev1
driver weblogic.jdbc.oci.Driver
properties user=*****
password=*****
dll=weblogicoci37


I checked the ORACLE_HOME and its set correctly. Here's the rest of my
startweblogic.cmd

set JAVA_HOME=d:\jdk1.3.1
set ORACLE_HOME=d:\oracle\ora81
set WL_HOME=D:\bea\wlserver6.1
set
PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%

set
TL40CLASSES=D:\WebGain\TopLink4.0\WDI_J\Classes\wdiall.jar;D:\WebGain\TopLin
k4.0\WDI_J\Classes\xerces.jar;D:\WebGain\TopLink4.0\WDI_J\Classes\wdisdkxerc
es.jar;D:\WebGain\TopLink4.0\WDI_WLS\Classes\wdiwlsx.jar

set
CLASSPATH=.;.\lib\weblogic_sp.jar;.\lib\weblogic.jar;%WL_HOME%\oracle\classe

s;..\lib\ejb20_DemoADLSCEntities.jar;%TL40CLASSES%
set CLASSPATH=%CLASSPATH%;.\lib\jaxm-api.jar
set CLASSPATH=%CLASSPATH%;.\lib\jaxm-client.jar
set CLASSPATH=%CLASSPATH%;.\lib\log4j.jar
set CLASSPATH=%CLASSPATH%;.\lib\commons-logging.jar

I can create a pool fine with oracle thin and weblogic thin

thanks for the help

"Joseph Weinstein" <j...@bea.com> wrote in message
news:3CFF99A8...@bea.com...

Joseph Weinstein

unread,
Jun 6, 2002, 5:01:32 PM6/6/02
to Mike

Mike wrote:

> Here is my tsnnams
>
> DEV1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = conradb)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = dev1)
> )
> )
>

Sure, Ok. Try this:

URL: jdbc:weblogic:oracle


driver: weblogic.jdbc.oci.Driver
properties: user=*****
password=*****

server=DEV1

dll isn't a used property with our driver, and we find the machine and port via the tnsnames
file (OCI does), so that stuff in your original URL doesn't help our driver.

Let me know,
Joe

Mike

unread,
Jun 7, 2002, 11:10:55 AM6/7/02
to
Tried what you suggested and got the following error.

weblogic.common.ResourceException: weblogic.common.ResourceException:


Could not create pool connection. The DBMS driver exception was:

java.sql.SQLException: System.loadLibrary(weblogicoci37) threw
java.lang.UnsatisfiedLinkError: 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(Connection
EnvFactory.java:193)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:134)


So I knew that it wasn't finding the dll. I looked in my startweblogic.cmd
and changed

PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%

to

PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\;.\bin;%PATH%

and it works fine now. I also had a problem with my system path and that
caused weblogic to look in oracle\jdbc\lib for the dll, but that was easly
fixed.

Thanks you really helped me out

Mike

)"Joseph Weinstein" <j...@bea.com> wrote in message
news:3CFFCDAC...@bea.com...

Deepak Vohra

unread,
Jun 7, 2002, 1:34:56 PM6/7/02
to
Connection Pool database should be registered with the tnsnames.ora file.

Joseph Weinstein

unread,
Jun 7, 2002, 3:17:08 PM6/7/02
to Mike
Mike wrote:

> Tried what you suggested and got the following error.
>
> weblogic.common.ResourceException: weblogic.common.ResourceException:
> Could not create pool connection. The DBMS driver exception was:

> java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path
>

> So I knew that it wasn't finding the dll. I looked in my startweblogic.cmd
> and changed
>
> PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\oci817_8\weblogicoci37.dll;.\bin;%PATH%
> to
> PATH=%ORACLE_HOME%\bin;%WL_HOME%\bin\;.\bin;%PATH%
>
> and it works fine now. I also had a problem with my system path and that
> caused weblogic to look in oracle\jdbc\lib for the dll, but that was easly
> fixed. Thanks you really helped me out
> Mike

:-)
Joe

0 new messages