ORA-24327

[sergio_mr]

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]

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]

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...