utils.dbping -> LOGIN ERROR CODE: ORA-24327

[Bhavin Raichura]

Hi All,

I am facing the following problem with utils.dbping

D:\bea\wlserver6.1\config\examples>java utils.dbping ORACLE SFA SFA SANSKRUT
Starting Loading jDriver/Oracle .....
---------- LOGIN ERROR CODE: 24327
Error encountered:
java.sql.SQLException: ORA-24327: need explicit attach before authenticating
a u
ser - (SFA/********@SANSKRUT)
at
weblogic.db.oci.OciConnection.getLDAException(OciConnection.java:161)
at weblogic.jdbc.oci.Driver.connect(Driver.java:112)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at utils.dbping.main(dbping.java:167)

Can anyone please help me out there ?

Thanks in advance.

Bhavin Raichura

[Utpal]

I tried following with 510, should be same with 61.

=====================

C:\opt\bea\wls510>java -classpath %CLASSPATH% utils.dbping ORACLE utpal
utpal ORA815

+++ WebLogic Native Layer for OCI 8.x (BETA-2)

**** Success!!! ****

You can connect to the database in your app using:

Class.forName("weblogic.jdbc.oci.Driver").newInstance();

java.sql.Connection conn =

DriverManager.getConnection("jdbc:weblogic:oracle:ORA815", "utpal", "utpal")

;

**** or ****

java.util.Properties props = new java.util.Properties();

props.put("user", "utpal");

props.put("password", "utpal");

props.put("server", "ORA815");

Class.forName("weblogic.jdbc.oci.Driver").newInstance();

java.sql.Connection conn =

DriverManager.getConnection("jdbc:weblogic:oracle", props);

=====================

2) I have following entry in my tnsnames.ora ( under
ORACLE_HOME/network/admin folder ).

ORA815 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = dhruv)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ORA815.Dhruv)

)

)

3) Make sure that Oracle Listner is up and running.

"Bhavin Raichura" <bhavin....@sanskrut.com> wrote in message
news:3bba...@newsgroups.bea.com...

[Raj Alagumalai]

Bhavin,

Can you check if you are able to login to the same database with the same
username password combination using SQL Plus utility.

Also make sure that ORACLE_HOME is set on the Oracle Client installation
Check to see if the TNSNAMES.ORA file is configured in the correct manner.

This file can be found in /oracle/network/admin/TNSNAMES.ORA

A sample entry in TNSNAMES.ORA:

databaseInstanceName=
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= hostName)(Port= 1521))
(CONNECT_DATA = (SID = databaseInstanceName))
)

Hope this helps

Raj Alagumalai