File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes General Computing and the fly likes TNS Name prob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "TNS Name prob" Watch "TNS Name prob" New topic

TNS Name prob

Tuhin Ghosh
Ranch Hand

Joined: Oct 11, 2006
Posts: 33
hi i am trying to execute Java Stored Procedure . i like to where to look in the directories for my oracle TNS Name
Chris Hendy
Ranch Hand

Joined: Mar 04, 2006
Posts: 98

cd to your ORACLE_HOME directory (look in the registry for HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE - HOMEn where n is a number 0 upwards since you can have multiple ORACLE_HOMES).

For Oracle8i its in the NET80\ADMIN subdirectory

For Oracle9i its in the network\admin subdirectory


For 9i

cd to $ORACLE_HOME/network/admin

I haven't got an 8i DB to look at but I suspect it's

I agree. Here's the link:
subject: TNS Name prob
jQuery in Action, 3rd edition