tnsname.ora file - location | Unix Linux Forums | Shell Programming and Scripting

  Go Back    


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

tnsname.ora file - location

Shell Programming and Scripting


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 08-01-2009
ajincoep ajincoep is offline
Registered User
 
Join Date: Apr 2009
Last Activity: 20 October 2010, 5:24 AM EDT
Posts: 32
Thanks: 9
Thanked 0 Times in 0 Posts
tnsname.ora file - location

Hi,

Could you please tell me at which location is the file located on unix server

Thanks.
Sponsored Links
    #2  
Old 08-01-2009
TonyFullerMalv's Avatar
TonyFullerMalv TonyFullerMalv is offline Forum Advisor  
Registered User
 
Join Date: Sep 2008
Last Activity: 1 July 2013, 6:45 PM EDT
Location: Malvern, Worcs. U.K.
Posts: 1,033
Thanks: 0
Thanked 8 Times in 8 Posts
If you are running Oracle on a Linux machine then run the following as root to find it:
# updatedb
# locate tnsname.ora
Sponsored Links
    #3  
Old 08-07-2009
jim mcnamara jim mcnamara is offline Forum Staff  
...@...
 
Join Date: Feb 2004
Last Activity: 31 August 2014, 5:38 PM EDT
Location: NM
Posts: 10,180
Thanks: 275
Thanked 785 Times in 734 Posts
$ORACLE_HOME/admin/network/tnsnames.ora is the normal place for tnsnames.ora in unix implmentations of Oracle.
    #4  
Old 08-07-2009
durden_tyler's Avatar
durden_tyler durden_tyler is offline Forum Advisor  
Registered User
 
Join Date: Apr 2009
Last Activity: 25 August 2014, 5:53 PM EDT
Posts: 1,841
Thanks: 7
Thanked 266 Times in 241 Posts
It's actually .../network/admin/...


Code:
$ 
$ echo $ORACLE_HOME
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
$ find $ORACLE_HOME -name tnsnames.ora
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/samples/tnsnames.ora
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/tnsnames.ora
$

tyler_durden
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Location of log file mohan705 UNIX for Advanced & Expert Users 1 04-22-2009 12:34 AM
Bash copy file contents into an existing file at a specific location gshepherd7 Shell Programming and Scripting 6 03-11-2009 09:26 AM
copy files from one location to similar location pharos467 UNIX for Advanced & Expert Users 1 09-21-2008 12:21 PM
how to put file from one ftp to another ftp location prasee Shell Programming and Scripting 1 03-28-2008 05:34 AM
What is the file location? Chanakya.m Shell Programming and Scripting 5 07-17-2006 12:42 AM



All times are GMT -4. The time now is 07:36 AM.