ORA-24327 error

[Atif Mumtaz Khan]

Hi all,
I am using Oracle 8.1.5 on NT and Weblogic 5.1 evaluation version

I am trying to connect to Oracle DB using the Weblogic tour given with
the installation. I am getting the following error continuously:

java.sql.SQLException: ORA-24327: need explicit attach before
authenticating a user - (scott/********@testdb.ct)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:143)
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:157)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:106)
at tutorial.tootbe.SQL2Table.service(SQL2Table.java:140)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:865)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:98)

at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:737)

at
weblogic.servlet.internal.ServletContextImpl.invokeServlet(ServletContextImpl.java:681)

at
weblogic.servlet.internal.ServletContextManager.invokeServlet(ServletContextManager.java:210)

at
weblogic.socket.MuxableSocketHTTP.invokeServlet(MuxableSocketHTTP.java:354)

at
weblogic.socket.MuxableSocketHTTP.execute(MuxableSocketHTTP.java:255)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java,
Compiled Code)

I saw some messages regarding this on the newsgrp, but without any
satisfactory answers or at least the answers which are not working for
me. Please help.

Regards,
Atif

[Kumar Allamraju]

1. Make sure ORACLE_HOME is properly set in your PATH.
2. Try java utils.dbping ORACLE [user name] [password] [service name]
http://www.weblogic.com/docs50/techstart/dbping.html
See if you can connect to the database.

Let us know if you still have problems.
--Kumar

[Commission Junction]

I can "ping" my database, but I still get the same error.

Brian Haueter

[Ivor Durham]

The cause of my ORA-24327 (need explicit attach ...) error was a mis-match
between the "server" component of the "props" parameter in the
weblogic.jdbc.connectionPool.oraclePool property in the weblogic.properties
file and the entry for the database in tnsnames.ora file in the Oracle
installation. In the latter file the database was identified with the domain
name attached while in my weblogic.properties file I had only the database
name. i.e. "mydbname.abc.com" in tnsnames.ora and just "mydbname" in
weblogic.properties. Adding the domain name to the server property in the
weblogic.properties file fixed the problem.

Simply getting the right name for the "server" entry from the tnsnames.ora
file rather than specifying it independently would have saved me a lot of
time!

Many thanks to David Maw for the hint.

Ivor Durham