File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes ORA-24327 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "ORA-24327" Watch "ORA-24327" New topic



Joined: Sep 26, 2002
Posts: 6
Hi everybody...
I had read all the topics in this forum about my problem, but don't have yet the solution.
I have installed in a server
RedHat 7.2
Oracle Client 9.0.1
WebLogic 6.1
And in an other server
Oracle Database 8.1

The error message is:
java utils.dbping ORACLE user password host ort:instance
Starting Loading jDriver/Oracle .....
---------- LOGIN ERROR CODE: 24327
Error encountered:
java.sql.SQLException: ORA-24327: need explicit attach before
authenticating a user - (user/********@host ort:instance)
weblogic.db.oci.OciConnection.getLDAException( at
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at utils.dbping.main(

My variables are:
echo $PATH

And I don't known where is the problem, can you helpme please???
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Usually means your box can't resolve the location of the Oracle instance.
Try a tnsping on the instance you are trying to connect to, I bet it fails.
If so, then you have a Net8 configuration issue. If you are using tnsnames then make sure the information is correct and that a test from within Net8 Assistant passes. If you are using an Oracle Naming Server then confirm all of that information is correct. Also make sure you are resolving the names in the correct order (usually ONames then TNSNames).
If you have an Oracle DBA around then call him/her over and save yourself the headache.

Joined: Sep 26, 2002
Posts: 6
Hi Chris
When I execute tnsping, this is the result:
# tnsping
TNS Ping Utility for Linux: Version - Production on 26-SEP-2002 17:31:04
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
OK (0 msec)

I'm going to check the Net8 configuration...
Thanks a lot
I agree. Here's the link:
subject: ORA-24327
It's not a secret anymore!