This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "TNS Name prob" Watch "TNS Name prob" New topic
Author

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
Windows

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

UNIX

For 9i

cd to $ORACLE_HOME/network/admin

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

$ORACLE_HOME/net80/admin
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: TNS Name prob
 
Similar Threads
what is a TNS name?
how can I know my TNS Names_Entry?
jsp page give this error Database Log In Failed
Oracle9i DB with Oracle9i DS
How to connect to Oracle db using TNS