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)
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
Hi Chris When I execute tnsping, this is the result: # tnsping 10.0.0.1 TNS Ping Utility for Linux: Version 18.104.22.168.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...