Unix/Linux Go Back    


Shell Programming and Scripting Unix shell scripting - KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and shell scripts and shell scripting languages here.

tnsname.ora file - location

Shell Programming and Scripting


Closed Linux or Unix Question    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 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 Unix and Linux 08-01-2009
TonyFullerMalv's Unix or Linux Image
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 Unix and Linux 08-07-2009
jim mcnamara jim mcnamara is offline Forum Staff  
...@...
 
Join Date: Feb 2004
Last Activity: 27 May 2015, 12:00 AM EDT
Location: NM
Posts: 10,453
Thanks: 336
Thanked 860 Times in 799 Posts
$ORACLE_HOME/admin/network/tnsnames.ora is the normal place for tnsnames.ora in unix implmentations of Oracle.
    #4  
Old Unix and Linux 08-07-2009
durden_tyler's Unix or Linux Image
durden_tyler durden_tyler is offline Forum Advisor  
Registered User
 
Join Date: Apr 2009
Last Activity: 5 April 2015, 4:04 PM EDT
Posts: 1,904
Thanks: 9
Thanked 285 Times in 259 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 Linux or Unix Question

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux 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 01:40 AM.