how can I know my TNS Names_Entry?

[ankur rathi]

Hi,
I am trying to connect java with oracle with oci deriver. I have both oracle and java on one machine.

Class.forName("oracle.jdbc.driver.OracleDriver");

This line works perfectly (doesn't give ClassNotFoundException), taken classes111.zip file into classpath.

Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@-----", "system", "manager");

What should I write at the place of TNS Names_Entry. Actually what exactly is this TNS Names_Entry. How can I know the value of this in my computer.

Please help me.

Thanks a lot.
[ November 13, 2005: Message edited by: rathi ji ]

[Arun Prasath]

First, you should have oracle client installed in your machine when you use oracle oci driver.

Then look for the file tnsnames.ora inside "admin" folder of oracle client installation. This file holds the details of the list of services configured by your client.

pick the required service name and use in your java program.

[ankur rathi]

I guess, I have both server and client installed. Because I am writing query from SQL plus prompt (I guess, without client, we can't make query) and server is executing the query.

Unfortunately, I can't look this file now.

Is there a direct entry like this in tnsnames.ora file:

TNS Names_Entry = SHREE

Please reply.
Thanks.

[Sunil Dumpala]

Rathi,

A usual tnsname entry looks like the following

SUNILDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = SUNIL01) (PORT = 1521))
)
(CONNECT_DATA =
(SID = SUNILDB)
(SERVER=DEDICATED)
)
)

-Sunil

[Paul Sturrock]

And to double check the value you think is the tns name, try "tnsping [tnsname]" from the command line.

[ankur rathi]

Originally posted by Sunil Dumpala:
Rathi,

A usual tnsname entry looks like the following

SUNILDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = SUNIL01) (PORT = 1521))
)
(CONNECT_DATA =
(SID = SUNILDB)
(SERVER=DEDICATED)
)
)

-Sunil

Thank you very much Sunil and Paul.
Could you please tell me what is TNS Names_Entry here in this file.

[David O'Meara]

SUNILDB = ...

SUNILDB is the TNS name.

[ankur rathi]

Originally posted by David O'Meara:
SUNILDB = ...

SUNILDB is the TNS name.

Thanks David,
I will try this.

[ankur rathi]

I tried this code.

 
Class.forName("oracle.jdbc.driver.OracleDriver");
 
Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@localhost:1526:SHREE", "system", "manager");
 
 
where SHREE is TNS Name (checked [I]tnsnames.ora[/I] file).
 

It was giving this error:

Unsatisfied link error make_c_safe at oracle.jdbc.oci8.OCIDBAccess.make_c_safe
 
.....
.....
 

Please tell me, what can be wrong here?
Thanks.
[ November 22, 2005: Message edited by: rathi ji ]

[Sri Ram]

I dont know if this will anyway solve ur issue, But it did mine some time back.
First, make sure that the jdbc-oci shared object (libocijdbc8 or liboci80Xjdbc.so etc.) and ${ORACLE_HOME}/lib are in your path. Then, try the Test sample program available in the JDBC samples directory. Sometimes, even after the shared object is loaded successfully, you may get errors such as make_c_state symbol not found. This may happen if your CLASSPATH has classes.zip from JRE 1.1.7 or JDK 1.1.6 and your running java binaries from jdk 1.1.3 or so. Make sure everything (LD_LIBRARY_PATH, CLASSPATH, java binaries) is in sync.

[Sri Ram]

Sorry forgot to post. I actually got this from Here.

[ankur rathi]

Originally posted by Sri Ram:
I dont know if this will anyway solve ur issue, But it did mine some time back.
First, make sure that the jdbc-oci shared object (libocijdbc8 or liboci80Xjdbc.so etc.) and ${ORACLE_HOME}/lib are in your path. Then, try the Test sample program available in the JDBC samples directory. Sometimes, even after the shared object is loaded successfully, you may get errors such as make_c_state symbol not found. This may happen if your CLASSPATH has classes.zip from JRE 1.1.7 or JDK 1.1.6 and your running java binaries from jdk 1.1.3 or so. Make sure everything (LD_LIBRARY_PATH, CLASSPATH, java binaries) is in sync.

I am sorry but I didn't get it.

I have classes111.zip into classpath. Using JDK 1.4 and Oracle 8i. Are they not compatible with each other.

Please help.

Thanks.

[Jesper de Jong]

You have to make sure that the relevant OCI DLL's (if you're using Windows) are in the PATH (note, that's not the same as classpath).

The error you are getting:

Unsatisfied link error make_c_safe at oracle.jdbc.oci8.OCIDBAccess.make_c_safe

sounds like you do have the DLL's in your path, but you have a wrong (too old or too new) version somewhere.

Why do you want to use the OCI driver anyway? Using the thin driver is easier, if you use the thin driver you don't need the Oracle client software at all (and you wouldn't have problems like the error message above).

edit: Aha, I see you have another post which is exactly the same, except you're asking about the thin driver... :roll:
[ November 22, 2005: Message edited by: Jesper de Jong ]