• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

TNS Name prob

 
Tuhin Ghosh
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 98
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic