• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Tim Cooke
  • Jeanne Boyarsky
  • Liutauras Vilda
Sheriffs:
  • Frank Carver
  • Henry Wong
  • Ron McLeod
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Himai Minh

ORA-24327

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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...
 
Ranch Hand
Posts: 2713
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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...
 
All of the following truths are shameless lies. But what about this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic