wood burning stoves 2.0*
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
Author

ORA-24327

sergio_mr
Greenhorn

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)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:164) at
weblogic.jdbc.oci.Driver.connect(Driver.java:112)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at utils.dbping.main(dbping.java:167)

My variables are:
echo $ORACLE_PATH
/home/oracle
echo $PATH
/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/usr/local/java/bin:/usr/weblogic/wlserver6.1/bin:/usr/weblogic/wlserver6.1/bin/oci901_8:/home/oracle/bin
echo $CLASSPATH
/usr/local/java/lib/tools.jar:/usr/weblogic/wlserver6.1/lib/weblogic_sp.jar:/usr/weblogic/wlserver6.1/lib/weblogic.jar:/usr/weblogic/wlserver6.1/lib/weblogic_sp.jar:/usr/weblogic/wlserver6.1/lib/weblogic.jar:/usr/weblogic:/root/bea:/usr/weblogic/wlserver6.1/samples/eval/cloudscape/lib/cloudscape.jar:/home/oracle/lib:/home/oracle/JRE:/home/oracle/jlib:/home/oracle/rdbms/jlib:/home/oracle/network/jlib:/home/oracle/jdbc/lib/classes12.zip:/home/oracle/jdbc/lib/classes12.jar
$LD_LIBRARY_PATH
/usr/weblogic/wlserver6.1/lib/linux/i686:/usr/weblogic/wlserver6.1/lib/linux/i686/oci901_8:/home/oracle/lib:/home/oracle/jdbc/lib

And I don't known where is the problem, can you helpme please???
regards...
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.
sergio_mr
Greenhorn

Joined: Sep 26, 2002
Posts: 6
Hi Chris
When I execute tnsping, this is the result:
# tnsping 10.0.0.1
TNS Ping Utility for Linux: Version 9.0.1.0.0 - Production on 26-SEP-2002 17:31:04
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/home/bd/oracle/network/admin/sqlnet.ora
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=10.0.0.1))(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.1)(PORT=1521)))
OK (0 msec)

I'm going to check the Net8 configuration...
Thanks a lot
Regards...
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ORA-24327
 
Similar Threads
LOGIN ERROR CODE:24327
Hope Mr Parthasarathy madhira or other friend help me to solve this problem
WLS 6.1 sp3 server won't start with rh7.2
Oracle JDrivers
connecting weblogic 6.1 and oracle thru thin driver